Posted: 14 Aug 2017 14:56 EDT Last activity: 18 Jan 2018 7:43 EST
Autocomplete control fails to load all results from Data Page
I have an autocomplete control whose source is a Data Page. The source of this Data Page is an activity in which we query call a stored procedure. First 15 to 20 values are displayed and When you scroll down the field, the loading symbol persists on the screen, and the values are never fetched and listed for selection.
Note: Values are present in DB as well as on Data Page in clipboard. There is no pagination format in the grid where this autocomplete field is used.
Thanks for your quick reply. I checked the configuration in UI Gallery. In my case also first 20 values are displayed but on scrolling down its blank even after some time. Also this is happening as around 9000 values fetched from DB. Screenshots are attached.
Is it taking much time to load the data there?
Can there be any issue in DB script?
Posted: 4 years ago
Posted: 17 Aug 2017 0:43 EDT
Susan Liu (SusanLiu_GCS)
Principal Software Solutions Engineer
The most common way is to use a Report Definition as the source of the data page. It will allow you to configure a filter condition based on a parameter value (define the parameter in the parameters tab).
Again, please check the last field of the "Autocomplete" example in UI Gallery. It uses Report Definition as the source of the Data Page.