Question
Connection
US
Last activity: 6 Dec 2024 5:51 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
Updated: 6 Dec 2024 5:51 EST
HCLTech
IN
@ShirleyLeung_lcls one more thing regarding this i have observed , if we are use source of Data page as Report definition below thing needs to be checked
1. if we have enabled paging in Report definition by checking the check box in "Report Viewer" tab as shown like below
2. then by default Pega sets maximum number of records which as defined in system settings for report definition to be fetched from Report definition to which is generally set to 500 in data access tab of report definition which can not be seen when paging is enabled , as shown below
so we either need to override this limit from system settings or uncheck the enable paging checkbox based on business needs