Dblookup not getting all column entries

HCL Domino Domino Forum
1

i have a view that displays the employee name (sorted asc/categorized) then the no. of days absent …

in a form, i have a field (computed, multi-value) with the following formula

@DbLookup(“”:“NoCache”;“”;“AbsenceTotals”;EmployeeName;2;[FailSilent])

the purpose of this field is to get all the days absent in one field

My problem is, it only gets first 5 documents (sometimes 3 or 4 for other employee name)… wondering why it’s not getting the values for all documents.

thanks in advance

2

Subject: dblookup not getting all column entries

Maybe it’s mixing and matching data types? @Dblookup will return most data types, but all the values have to be of the same type. Perhaps if you have numeric values, but some of them are blank (text), it is stopping when it gets to the blanks? Just a guess…

3

Subject: RE: dblookup not getting all column entries

hi anastacia,

you’re right! the values are not of the same data type (text and numeric)

thank you very much for your help.