Skip to main content
M
mariae247115
January 23, 2025
Question

Filter more than 5000 records

  • January 23, 2025
  • 13 replies
  • 0 views

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
davidj137213
January 23, 2025

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

M
mariae247115Author
January 23, 2025

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

sarathkumr268295
sarathkumr268295
January 23, 2025

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
konduruc733182
January 23, 2025

Hello [mention:24013d6f58164a50ac574072580fed1f:e9ed411860ed4f2ba0265705b8793d05] ,

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

varuntejg243705
varuntejg243705
January 23, 2025

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
stefanhelzle0001
January 23, 2025

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

konduruc733182
konduruc733182
January 23, 2025

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
stefanhelzle0001
January 23, 2025

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.

Terms & ConditionsAccessibility statement