Hi Team,
I need to populate the data in custom picker. But the data count is huge like 100000 rows available in the database. I have no other filter criteria to reduce the count. My question is is it possible to populate the values after entering the first three characters of the data or is there is any alternative method available .
Discussion posts and replies are publicly visible
Sure. Just query the data inside the suggest function, instead of trying to load everything and pass it along.
I assume the suggest function could even (with some extra coding hyjinks) be forced to return an empty set until it recognizes that the user input has reached at least 3 characters in length. I haven't tried it myself but i assume nothing is preventing this sort of override from working.
for reference reenabala
if( len( /*Text we are putting in*/ ri!filter ) >= a!defaultValue( /*Minimum character on which we want our search work on*/ ri!minChar, 3 ), /*query*/, todatasubset({}) )
As per my understanding,
After entering the first three characters, you can use an auto-complete or suggestion option to populate values. As the user types, dynamically filter and show matching values using JavaScript or a comparable scripting language.
I hope this is helpful for you.