Dynamic Configuration of Maximum number of rows to retrieve for a specific Report definitions

General
, , ,
1

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

2

@SVAQuest I 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 :smiley:

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.

DisplayNrows.png
DisplayNrows.png1204×407 17 KB

Pagination_10.png
Pagination_10.png596×496 20.5 KB

pyMaxRecords_xml_with_pagination_10.png
pyMaxRecords_xml_with_pagination_10.png450×185 4.58 KB

pyMaxRecords_xml_with_pagination_25.png
pyMaxRecords_xml_with_pagination_25.png593×227 5.96 KB

3

@SVAQuest

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:

4

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

5

Hi @Nirmalya.SenSharma

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

6

@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