Embedded Views from other DB's

HCL Domino Domino Forum
1

Hi all,

I’m working on an application in wich I need to have 4 embedded views from different databases and these need to be filtred by the field “lm_proyecto”. (When I create a new doc, the field is filled with the project name and then, i need to search all documents with the same project name and show them into their appropriate embedded view)

The code that I’m using is the following:

DBServer:=@Subset(@DbName;1);

Path := (@LeftBack(@Subset(@DbName; - 1); “\”));

Db := @If(Path = NULL; “DocPTDS.ntf”; Path + “\DocPTDS.ntf”);

@DbLookup(“”:“”;DBServer:Db;“vw_todos”;lm_proyecto;2)

The problem in this code is that I need the entire view filtred by “Proyecto” and this formula only show me one row of the specified column(in this case col 2)

(For entire view it means like an embedded view from the same DB)

**In the others DBs i have the views categorized by “Proyecto”

Thanks for reply!

Jaime Saldaña

2

Subject: Embedded Views from other DB’s

The embedded view and form should stay in the original db. You can open a document in another db that uses that form and embedded view. If you need to pass the value in a field to the other database, you can do it in an Environment Variable.

All that said, this does not sound like a robust design and suspect that you are in for more troubles down the road.