Skip to main content
LinkedIn
Copied!

Table of Contents

More about report definition rules

Version:

Only available versions of this content are shown in the dropdown

About the pxRetrieveReportData activity

Use the Rule-Obj-Report-Definition.pxRetrieveReportData activity to run the retrieval and sorting operations, but not the formatting and display processing, of a report definition.

Parameters

Specify both key parts of a report definition.

Parameter Description
pyReportClass Select the Applies To key part of a report definition. This might identify an internal class or class group, or an external class.
pyReportName Select the Purpose key part of a report definition.
pyPageName Optional. Specify the name of the clipboard page that holds the report results. If you do not specify a name, the results are included in the default Code-Pega-List page called pyReportContentPage.
pyReportParamPageName Optional. Use this parameter to override the columns returned by the report. This parameter enables you to add or remove the columns that the report returns. You can also change the sorting order of these columns.

This parameter is of class Embed-QueryInputs. The page structure is like the following example:

Embed-QueryInputs page structure

<? xml version="1.0" ?> <pageData> <pxObjClass>Embed-QueryInputs </pxObjClass> <pyListFields REPEATINGTYPE="PageList"> <rowdata REPEATINGINDEX="1"> <pxObjClass> Embed-ReportListFields </pxObjClass> <pyFieldName>.pyLabel</pyFieldName> <pyPrefix>PCO</pyPrefix> <pySortType>ASC</pySortType> <pySortOrder> 1 </pySortOrder> </rowdata> </pyListFields> <pyMaxRecords>Maximum no. of records to fetch</pyMaxRecords> <pyPagingSettings> <pxObjClass>Embed-PagingSettings</pxObjClass> <pyPageIndex>Page Number</pyPageIndex> <pyPageSize>Records per page</pyPageSize> <pyPagingEnabled>True/False<pyPagingEnabled> </pyPagingSettings> </pagedata>

Results

The system uses rule resolution to find the report definition and run it, but does not produce any HTML output display. The selection criteria of the report definition rule and the sorting requirements (recorded on the Design tab) are converted to an SQL query that is sent to the PegaRULES database.

The database results are organized into a results page of class Code-Pega-List. The name of this page is the value you provided for the pyPageName parameter.

Each embedded page contains the properties listed on the Design tab. If the Maximum Number of Rows to Retrieve field on the Data Access tab is not blank, the activity returns at most the number of embedded pages specified in the Maximum Number of Rows to Retrieve field.

However, if report paging is enabled on the User Interactions tab, only the rows for the first page are returned.

Performance

This method can return thousands of database rows and create large clipboard pages. To minimize any impact to performance, retrieve only the rows (instances) and columns (properties) that you need.

Other ways to run reports

The pzOpenAndRunReport activity runs a report definition.

You can use the <pega:chart> JSP tag to embed a chart created by a report definition in a section.

Displaying the results of a report definition report in a grid layout

You can display the results of a report definition in a grid layout within a section. The section can be referenced in a flow action or harness.

To add the layout, either drag and drop a report definition from the Application Explorer onto a section, or create the layout in the section and specify the report definition as the data source in the grid's repeating area. In the grid layout, use SmartPrompt to select Column Name values to define the grid's columns.

You can specify joins in the grid. The presentation is determined by the grid layout settings, not the report definition settings. Grid report rows are read-only and cannot be re-sorted.

Limitations for reporting on unoptimized properties

Whenever possible, Optimizing properties from the user interface the properties that you use in reports. Reporting on unoptimized properties causes a performance drain on the system. Reports that use unoptimized properties in filters or selects result in a warning message in the Report Editor or the report definition. Reports that have a join filter with unexposed properties result in a run-time error.

You can view the generated Java code of a rule by clicking Actions View Java . You can use this code to debug your application or to examine how rules are implemented.

Unoptimized decimal and double properties on Microsoft SQL Server

On Microsoft SQL Server has a size limitation for the value that a report definition can report on using the The Calculation Builder to get values out of the BLOB (that is, from an unoptimized property). If a value is greater than precision 18, scale 6, Microsoft SQL server returns an error.

  • Summary views

    Use the Summary View rule form to define a custom or personal query. This rule generates HTML that provides an interactive display or chart.

  • Keystores

    A keystore is a file that contains keys and certificates that you use for encryption, authentication, and serving content over HTTPS. In Pega Platform, you create a keystore data instance that points to a keystore file.

  • List views

    When using the List View rule form, complete the tabs in the following order:

  • Keystores

    A keystore is a file that contains keys and certificates that you use for encryption, authentication, and serving content over HTTPS. In Pega Platform, you create a keystore data instance that points to a keystore file.

  • Report Definition rule form

    A report definition rule defines a report definition report. This rule generates an SQL query that retrieves and sorts information from the PegaRULES database, an external database, or an Elasticsearch index, and generates HTML that displays the results in a variety of formats. You have a range of options for interacting with the results, depending on the settings on the Report Viewer tab.

  • Creating advanced reports

    Facilitate the process of data analysis by presenting the data that you retrieve from the database in the form of a table.

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us