Question
Dynamic Configuration of Maximum number of rows to retrieve for a specific Report definitions
Hi All,
What are the different option to configure the "Maximum number of rows to retrieve" for the specific Report definition?
The default was set to 500 in Design Studio --> Reporting Setting & Data access tab of the Report Definition.
RULE-ADMIN-SYSTEM-SETTINGS PEGA-RULESENGINE PYMAXRECORDS (Default is 500) - This configuration will impact all the Report definition in the application
Do we have any DSS or System setting for Dynamic Configuration of "Maximum number of rows to retrieve" for the specific report definition?
What will default count if the RULE-ADMIN-SYSTEM-SETTINGS PEGA-RULESENGINE PYMAXRECORDS is set to null? What can have the largest impact on the performance in this context?
Any suggestion?
Regards
SVA Quest
Updated: 29 Sep 2021 22:49 EDT
Rulesware
PE
@SVAQuestI think there is no DSS to set the .pyMaxRecords for a single Report Definition.
If you want to change the .pyMaxRecords value, you can change it in the pagination option. If you set it, for example, to 10, it will change the .pyMaxRecords (see the xml attachment).
Change to 25 and you will see that the .pyMaxRecords will change (see the attachments).
Although this will force you to use pagination.
You can always try the "Display N rows overall ..." option :D
btw, I don't know what will happen if it's set to null, and I don't want to. You can try modifying the rule directly using the obj- method.
Updated: 5 Oct 2021 3:14 EDT
Tata Consultancy Services Ltd
AU
Hi @Deivit
Thanks for the details.
And I also opted the paginations, did not get any option to configure max records dynamically in Report definition.
Regards SVAQuest
Updated: 30 Sep 2021 3:14 EDT
Ernst & Young LLP
MT
The OOTB logic to figure out the max row to return is as following -
If (pyReportParamPageName.pyMaxRecords != "")
Max Record = pyReportParamPageName.pyMaxRecords
ElseIf (Max No. Record specified in Report Def)
Max Record = Max No. Record specified in Report Def
Otherwise
Max Record = @getRuleSystemSetting("Pega-RulesEngine","pyMaxRecords")
Look at Step 12 and 30 of OOTB activity pxRetrieveReportData.
Structure of pyReportParamPageName page can be found here:
https://community.pega.com/knowledgebase/articles/reporting/86/more-about-report-definition-rules
Tata Consultancy Services Ltd
AU
Thanks for the details.
If pxRetrieveReportData activity is customized, this may impact the entire application whenever this activity is called.
I am looking to update n max record for different Report definitions.
Regards SVAQuest
Ernst & Young LLP
MT
@SVAQuest You don't even need to customize the pxRetrieveReportData activity.
You just need to create pyReportParamPageName page with required information prior to calling pxRetrieveReportData activity.
Thanks