Close popover
Tim Turbett (turbt1)

Pegasystems Inc.
turbt1 Member since 2019 4 posts
Posted: December 3, 2020
Last activity: December 4, 2020

Autocomplete causes DB query for every keystroke - how to prevent this?

Pega 8.4.1

I have an autocomplete whose "list source" is a Data Page.  This Data Page has a Report Definition as its Data Source.

In the autocomplete field, I type A.  Using tracer I see that a list came back from the DB containing 256 entries.

I continue typing, adding the next character M.  I expected that Pega would be smart enough to filter the existing 256 entries to produce a smaller result set.

Instead, I see a DB query (from the underlying Report Definition).

Is there a way to configure this so that the second character does NOT query the database?

***Edited by Moderator: Pooja Gadige to add platform capability tags***
Pega Platform User Experience Reporting Data Integration Lead System Architect