Hi Appian Community,
I'm working on a PickerField component that needs to display data from a large dataset (~15,000 rows). Here are my requirements:
Requirements:
Current Challenge: I want to avoid loading all 15,000 rows upfront for performance reasons. Instead, I'd like the search to execute only when the user has typed at least 3 characters, and then load the filtered results from the Record Type.
Discussion posts and replies are publicly visible
Can you share a snippet of whatever code you've tried so far? I've implemented a database-backed picker field search function before that just returns an empty result set until it detects that enough search data has been entered (just a quick brute-force check on the length of the string entered thus far), and it worked OK as far as I can tell. I'm unclear (without trying myself) whether being Record Type backed will change this approach much.
Use a!pickerFieldRecords natively queries the Record Type on each keystroke with server-side filtering - it never loads all 15k rows. Use the filters parameter with a dummy filter to block results until 3 characters are typed.
Use a custom picker field to trigger a search after 3 chars.