Unable to retrieve data from Data Page exceed 500 records

[ShirleyLeung_lcls (Shirley Leung)]

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

[AnthonyTham]

@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.

[PrakashDeep (Prakash Deep Rai)]

@ShirleyLeung_lcls

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

[LondheGS (Gaurav Londhe)]

@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