list:=@DbColumn in Dialog List works sometimes/sometimes returns nothing

HCL Domino Domino Forum
1

I have the following as the formula for choices in a Dialog List field.It supposed to return a list of common names from the NAB.

Most times it works fine. Sometimes, it returns nothing.

Any suggestions?

Most users having problems are using R6 client. Server is 6.0.2 CF1.

I posted here as well as R5 forum because I cannot confirm that this is an R6 issue only.

Thanks in advance.

Here is the formula:

list:=@DbColumn(“Notes”:“”;“Notesev”:“NAMES”;“People”;1);

@RightBack(@Name([CN];list);" ") + " " + @Left(@Name([CN];list); " ")

2

Subject: list:=@DbColumn in Dialog List works sometimes/sometimes returns nothing.

Try if you can to use a Names field, with the option ‘Use Address Dialog for choices’.

cheers,

Tom

3

Subject: list:=@DbColumn in Dialog List works sometimes/sometimes returns nothing.

Try using the “NoCache” parameter (the 2nd parameter) to ensure it’s not trying to use cached data.