Using the TypeAhead function on the NAB ($VIMPeople) view fails because there are too many records. I started looking up a db with just a few names and it worked ok, however once I got over 2500 documents in the database it failed, ie showed no values. When I put the same formula into a Combobox it presented one value - ‘Infinity’. Not sure now how I am supposed to have a field that can lookup and hold directory names unless they are typed in manually - not looked up. New to xPages and may be missing something right under my nose, any advice appreciated.
Subject: Re: Typeahead
With the typeahead enabled, you can specify the number of minimum characters after which the typeahead starts looking for entries. Change the minimum number of characters to something other than 1 (I usually have at least 3), and this should ensure you return a smaller number of matches.
Subject: Solution
Thanks Paul. I combined your advice with something I found in David Leedy’s Notes In Nine series on YouTube (highly recommend them), who in turn got it from Mark Hughes’ blog (excellent thinker and innovator).
The following formula is used in the Suggestions attribute of the TypeAhead as a computed value:
@DbLookup(@DbName(), “($VIMPeople)”, getComponent(“your_field_id_here”).getValue(),1,“[PARTIALMATCH]”);
The getComponent() function uses the #id of the field used for the type ahead.
Using this method helps to reduce the amount of information in the field to under 64k.
Normally we would use @DbColumn however the above method should work for all typeahead scenarios and probably should be the recommended formulaic approach.