Question
Zensar Technologies Ltd
IN
Last activity: 6 Aug 2024 6:58 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?
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.
Tata Consultancy Services
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
Wipro
IN
@Bhumireddy Thank you For Shareing Your knowledge
Can you send the Ans in this Qus:
Q : I want to see the genrated sql query for the Perticular report ?
.naveent@TURLAPATI
Tata Consultancy Services
IN
Hi @NaveenT97
If you want to know particular SQL Query for Report Definition.
You need to enable in the Tracer Settings --> DB Query in Event Types to Trace, Then run the Report Definition.
You can search the by Class Name in Tracer, there you will see Blue Color Lines in the Tracer, find the SQL Query in the tracer and other quires too.
Recently @AbikashSharma published nice article.
Database query debugging for Pega and Pega Tracer DB Query Mapper
I hope this will help you.
Thanks,
Ashok