XPAGE: @Dblookup error using $Users view of the domino address book

HCL Domino Domino Forum
1

Hi All,

I got an empty value when I tried to do @Dblookup to get the value of the current user’s “Location” from the domino address book (names.nsf)

Here is my code.

mydb=new Array(@DbName()[0],“names.nsf”);

mykey=document1.getItemValueString(“valname”);

arrayresult=@DbLookup(mydb,“($Users)”,mykey,“Location”,‘[FAILSILENT],[PARTIALMATCH]’);

Thanks in advance.