Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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.