Dblookup and dbcolumn

HCL Domino Domino Forum
1

I have a view with 2 columns.Is there anyway I could perform a dblookup (using a key to match the first column) and then, perform a dbcolumn to get a list of the second column values (when the first column match with the key)?

For example, if below is my view:

Chicago 001

Chicago 002

Chicago 003

New York 004

New York 005

if my key is “Chicago”, I want the dbcolumn to return 001, 002 and 003.

Is it possible at all? I’m trying to avoid creating too many views.

thanks for your help!

2

Subject: dblookup and dbcolumn

@DbLookup will return what you want already. Given the view you’ve shown, @Unique(@DbColumn(“”;“”;“ViewName”;1)) returns “Chicago”:“New York”. @DbLookup(“”;“”;“ViewName”;“Chicago”;2) returns “001”:“002”:“003”.

3

Subject: RE: dblookup and dbcolumn

Hi,

First of all, you should index your database and categorize your first column in your view.

First field formula is :

@DbColumn(“Notes”:“Nocache”;“”:“”;View Name;1)

Return : “Chicago”:“New York”

Second Field formula is :

TMP:=@DbLookup(“Notes”:“NoCache”;“”:“”;View name;First Field;2);

@If(@IsError(TMP);“”;TMP)

Return : “001” : “002” : “003” …

I hope this help…