@dblookup does not return values from all documents but only from one subcategory

HCL Domino Domino Forum
1

I am doing a lookup on response documents of the current doc.The first two columns in the view is categorized, first column displays parent’s universal id ($Ref), and second column displays the field called “Category”. I do a lookup specifying the document’s universal id, which in my knowledge should return values from all responses displayed in the view, but it only returns values from documents under the first sub-category (second column) - what could be the problem?

here is the formula I am using:

@DbLookup(“” : “NoCache” ; @DbName ; “responsesView” ; @Text(@DocumentUniqueID) ; “fieldName” )

Thanks for any help

2

Subject: @dblookup does not return values from all documents but only from one subcategory

hello Basir ,

Even I have faced this kind of issues.I think it is the issue with the second column being categorized.It worked perfectly if the categorization is removed.Did you tried with second column non categorized ?

Ravi.

3

Subject: RE: @dblookup does not return values from all documents but only from one subcategory

yes, it works if the second column is not categorized. I just didn’t want to create another view for this lookup since that will increase the number of views and eventually affect performance.

Basir