Skip to main content
New Participant
Jan 23, 2025 8:27 AM UTC
Question

Filter more than 5000 records

I have a record type which contains about 45000 records. I need to build a dropdown that shows all 45000 records but maximum limit in batchsize in queryRecordType() function is 5000. How can I display 45000 records in a dropdown list?

13 replies

davidj137213
Brainy
Jan 23, 2025 8:35 AM UTC

Do you really need to show all values in that record? Couldn't you use a different approach¿?

New Participant
Jan 23, 2025 8:43 AM UTC

I need to show all values of the record in order to filter and search

sarathkumr268295
Known Participant
Jan 23, 2025 8:45 AM UTC

Instead of using dropdown, you can use the search filter. If all 45000 records are unique, its not really something that should be provided as a dropdown filter

konduruc733182
Inspiring
Jan 23, 2025 8:45 AM UTC

Hello [mention:24013d6f58164a50ac574072580fed1f:e9ed411860ed4f2ba0265705b8793d05] ,

What is the content that you want to show as options? How likely will they have repetitive words. 

varuntejg243705
Inspiring
Jan 23, 2025 8:46 AM UTC

Hi [mention:24013d6f58164a50ac574072580fed1f:e9ed411860ed4f2ba0265705b8793d05] ,

You cannot query 45000 records at once. Try querying batch wise 5000 each time (9 times), and append it to a local variable and use it in dropdown.

Also ensure this will affect the performance. I don't recommend the above method, but it's possible as I've mentioned on top.

Note: Dropdown deoesn't accept duplicate values.

stefanhelzle0001
Brainy
Jan 23, 2025 8:50 AM UTC

Please do not do this. Use a record picker field to allow users to search and pick the values.

konduruc733182
Inspiring
Jan 23, 2025 9:10 AM UTC

I didn't recommend the Record Picker as Appian suggests that we do not use these components where we try to show more than 5000 records. Please correct me if I am wrong.

https://docs.appian.com/suite/help/24.4/Record_Picker_Component.html#row-limit-for-records-powered-components

stefanhelzle0001
Brainy
Jan 23, 2025 10:09 AM UTC

The point is to not directly show that many items to the user at all. I mean, just from a UX perspective, showing any larger list of data to a user to make selections, is a bad idea.

But using a picker field, the user can search for, and select from a more or less unlimited number of items.