Question
Connection
US
Last activity: 8 Feb 2024 9:47 EST
Unable to retrieve data from Data Page exceed 500 records
Hello Pega Community, I am new to Pega and still learning on all the possibilities. Currently I am trying to do an Autocomplete UI element and referencing a data object called `Customer`. The `Customer` data object has a data page with a field of Customer Name with 1000+ records. My goal is to search a customer name with Autocomplete, yet I realized Pega runs only 500 rows by default on pxMaxRecords, which when I type some customer name in the field, it doesn't show up on the Preview. May I ask how can I overcome the limit of 500 so that the search can look for the entire data object?
Thanks
Accepted Solution
Updated: 8 Feb 2024 9:47 EST
SiXworks Limited
GB
@ShirleyLeung_lcls The default is usually 1000 and can be changed/set using the dynamic system setting
datapages/mrucapasity
I can see from your screenshot you're using a report definition to retrieve the records for the data page. It's the report definition that has the 500 limit and this can be changed this using the 'Data Access' tab in the RD.
Aaseya IT Services Pvt LTD
SA
You can set the Max limit to 0 if you don't want to have an upper limit.
With 0 , it will pull all the records from the table irrespective of the count. Not recommended though if you have a huge set of data