How can we display more than 5000 records in interface and search by custom picker?
Anyone having Idea?
Discussion posts and replies are publicly visible
I do not think so that will be not a good user experience. If you are filtering with "A" there is so many countries, if you are searching with "AME" may be there has only few countries or America only. Query the data and configure the filter like that. And why do you need to show much more data in an interface? I think you should not.
I think you got my point.
hi kavitar5580 May I know what is your requirement to show more than 5000 records in UI, with a custom picker, this would affect the user experience
What is your rule looking like?
When implementing a custom picker, the trick is to feed the search string directly into the query, and only return the first few hits. In the Appian example, they define all data in local variables, which will not work in your case.
Yes It would be, But if this is the requirement how can we handle this scenario
Yes, as suggested by Stefan Helzle, you need to implement a backend search using a custom picker. Front-end search will not work. Stefan Helzle Please create a blog for this if not available.
Why are you using a Custom Picker for your search if you're showing a paging grid with your record list?
Just use a text field for your filter. When the user presses "search", apply the change to the existing query that's populating the paging grid - the results will be shown instantly. This should work for even a very large number of records, probably hundreds of thousands at least before it gets unusably slow. There's no reason whatsoever to be doing this using a Custom Picker.
you should not be using a custom picker for a grid filtering field in the first place. see my earlier comment above in which I gave more detail.