Copying data from Views

HCL Domino Domino Forum
1

I have a View “Producers” in DB - “Products.NSF” which contains the columns “Producer_Name” and “Address”

I Have another view called “All_Producers” in DB - “Transaction.NSF” Which Contains only one column called “Producer”.

Now my problem to list all the “Producer_Name” column of View “Producers” from DB - “Products.NSF” to the view “All_Producers” in DB - “Transaction.NSF”.

I tried @DBColumn formula in selectction criteria, but it didnt work. I wrote code like

select @DBColumn(“”;“”:“Products.NSF”;“Producers”;1)

Thanks in Advance

2

Subject: Copying data from Views

As stated in Designer help, you cannot use @DbColumn or @DbLookup in column formulas.

Also, you cannot display any data in a view, that does not reside in the very same database (with the exception of DB2 Query Views, which are available only with DB2 as datastore).

Your options include to display a view from Products.NSF in Transaction.NSF (but this will only display data from Products) or to duplicate the info from Products into the documents stored in Transaction. You might also be able to provide a view action, that takes the currently selected Producer_Name as a key and then opens up a view from Products, filtered to display only the info for this specific producer.

There is NO option similar to some kind of “join”, though. Notes is not relational.