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

Known Participant

Question

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

3 replies
27 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.

The Expression Guru

shubhama926776

Brainy

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

Brainy

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

Sign up

Login with SSO

Login to the community

Login with SSO