64k Limit on Xpages Lookups

HCL Domino Domino Forum
1

Hi all,

Having a little problem with the (well documented) 64k lookup problem and XPages.

I’m just trying to do a typeahead lookup of the people view in Names.nsf and due to the size of the list nothing is being returned).

I started with…

var dbname = new Array(@Subset(@DbName(), 1),“names.nsf”);

Return @DbColumn(dbname,“People”,2);

and changed it to… also adjusted typeahead to after 2 chars…

var dbname = new Array(@Subset(@DbName(), 1),“names.nsf”);

var tmpThisVal = getComponent(“txtFromAssociate”).getValue();

var tmpLkup = new Array (@Unique(@DbLookup(dbname,“People”,tmpThisVal,2)));

tmpLkup;

Now the server is giving me some incomprehensible error message. Any ideas where I’ve messed up??

Very frustrating, as it seems I have to learn this stuff all over again :-/

Thanks in advance.

2

Subject: Things that would help you get an answer

Firstly, you might want to post this in the Xpages forum (http://www-10.lotus.com/ldd/xpagesforum.nsf).

Secondly, the error message that makes no sense to you might make a lot of sense to someone else.

Having been in the same boat as you, I can tell you that XPages typeahead has been well discussed in a lot of places. A quick websearch for “Xpages 64k typeahead” finds this page:

Hope this helps,

Phil

3

Subject: Ooops!

Sorry,

didn’t realise there was a separate forum!

An update for anyone tring to do this - put the SSJS in your typeahead and ensure that a FULL refresh is selected AND case sensitivity is turned off;

var dbname = new Array(@DbName()[0], ‘names.nsf’);

var tmpVal = getComponent(“txtFld”).getValue();

@DbLookup(dbname,“($VIMPeople)”,tmpVal,1,“[PARTIALMATCH]”);