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: Display a PickerField with approximately 15,000 rows of data Implement a search functionality that only triggers after the user enters 3 or more characters Load the data using a Record Type as the data source Optimize performance to handle the large dataset efficiently 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.

rishukumarg1965

Question

How to implement a PickerField with 15,000 rows that searches after 3 characters using Record Type?

Forum|Forum|4 months ago
March 17, 2026
3 replies
0 views

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:

Display a PickerField with approximately 15,000 rows of data
Implement a search functionality that only triggers after the user enters 3 or more characters
Load the data using a Record Type as the data source
Optimize performance to handle the large dataset efficiently

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.

mikes0011

Brainy

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.

shubhama926776

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.

stefanhelzle0001

Use a custom picker field to trigger a search after 3 chars.

Sign up

Login with SSO

Login to the community

Login with SSO