Question
Zensar Technologies Ltd
IN
Last activity: 16 Mar 2024 3:11 EDT
Default Maximum number of rows to retrieve in Report ?
Hi All, What is the default Maximum number of rows to retrieve in report definition rule ? I am using Pega PRPC Personal Edition 8.7 version.
It is showing 500 .
But in some articles it is written 10K,
Which one is correct?
It is different according to Pega version?
Or it is different for Personal Edition?
-
Reply
-
SHIVAJI JAGDALE -
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Updated: 16 Mar 2024 3:11 EDT
Bits In Glass India Pvt Ltd
IN
@AbhishekC1725 Check the Application setting rule (Pega-RulesEngine • pyMaxRecords) in your Personal edition as shown below you can change the values for respective Production level
Updated: 15 Mar 2024 11:41 EDT
Bits In Glass India Pvt Ltd
IN
@AbhishekC1725 The default is 10K if we leave the field under General data access settings for Max no. of rows to retrieve empty otherwise you can put the desired value for Max no. of rows to retrieve field
Zensar Technologies Ltd
IN
@Amar Deshmukh So why in above screenshot 500 is displaying?
Accepted Solution
Updated: 16 Mar 2024 3:11 EDT
Bits In Glass India Pvt Ltd
IN
@AbhishekC1725 Check the Application setting rule (Pega-RulesEngine • pyMaxRecords) in your Personal edition as shown below you can change the values for respective Production level
Zensar Technologies Ltd
IN
@Amar Deshmukh Thanks , now clear
Maantic Inc
IN
Pega enforces a limit of 10K if left blank. You can get more details here:
Zensar Technologies Ltd
IN
@SohamM95 So why in above screenshot 500 is displaying.
If you check your pega environment and please confirm with screenshot.
Thanks.
Cognizant
IN
Hi @AbhishekC1725,
If you are not mentioning anything: The maximum number of rows to retrieve is 500. It will fetch 500 records by default.
That is placeholder message coming from the : pxRequestor.pyReportSettings.pyMaxRecords
If you want change, you can define the value, e.g., 100 or 600 etc.., it will fetch 100 or 600 records only from the DB.
Can you try changing the value and see?
I hope this will help you.
Thanks,
Ashok
Zensar Technologies Ltd
IN
@Bhumireddy Thanks , now clear