Who has not experienced the following:
XPages has a 32 or 64 ( can’t remember which ) limit for the lookup formula whereas in Notes the limit is only for the whole of the formula e.g. after @unique is applied.
It makes it very hard to have meaningful drop downs for filtering data.
Instead you can use SSJS e.g.:
var lookupView:NotesView = database.getView(“<LOOKUPVIEW>”);
This is the equivalent to:
@DbColumn( “”,”<LOOKUPVIEW>”, 1 );
and returns you the full result without the limit.
But this also brings me to the following problem:
When I enable Select2 on a loooong combobox the list is populated the type-ahead / filtering works fine BUT when I select a value long down the list the response of the select2 combobox becomes really sloooow.
Does anyone has an approach to this?