Article

Oct 18, 2019

Reporting is the process of using an SQL (Structured Query Language) query to retrieve and sort information from the Pega Platform™ database, an external database, or the Elasticsearch index. This process generates HTML that displays the query results in a variety of formats in the Report Viewer.…

Article

Oct 8, 2019

Pega Platform™ includes hundreds of maps you can use these maps to illustrate the data in a Report Definition, allowing report users to see graphically how data values are distributed and compare across geographic areas. Optionally, you can set up drill down maps so that, for example, users can…

Article

Aug 21, 2019

Summary By simply creating a model and a trigger rule, you can generate history memos that automatically audit field-level changes to both rules and data instances. For example, you can create a model and trigger that will track changes to user RuleSet lists in an access group. Pega Platform™ also…

Article

Apr 29, 2019

Summary When you execute a list view rule or summary view rule to produce a report, an “invalid column name” SQL error message appears. This message indicates that the problem is not a reporting issue, but arises from a class mapping misconfiguration. This article explains the reason for the error…

Article

Feb 17, 2016

Summary Symbolic dates allow you to choose date values in a list or summary view that are relative to the current date. They can be used on both the rule form and in the report itself. Symbolic dates are only used for values of Date and DateTime properties. Some symbolic dates identify a single day…

Article

Feb 17, 2016

Summary Using the Style Viewer with a text file rule and images (JPG or GIF files), you can define CSS styles that change the appearance of a single report, or all reports in an application, or all reports accessed through a specific report. Suggested Approach Introduction The W3C standard for…

Article

Feb 17, 2016

Business Intelligence Exchange (BIX) is an add-on product for PRPC and the Pega 7 Platform. Use BIX to define Extract rules for any classes to extract data from the PRPC or the Pega 7 Platform database either to external files (in XML or comma-separated values format) or to any relational database…

Article

Nov 15, 2015

Summary A developer asks: The search gadget "Search For Work", defined on the Process Work space of the User portal, includes queries with some of our site-specific fields to use in searching for cases.  Do those fields automatically get indexed somehow when they get created and added to…

Article

Nov 15, 2015

Business Intelligence Exchange (BIX) is an extraction tool in a well-defined ETL (extract, transform, load) process meant to populate a data warehouse with information from a Pega 7 production database. Use BIX to combine Pega 7 data with large amounts of data from other systems and databases for…

Article

Oct 7, 2014

Summary V5.2 includes a statistics-collection facility for those rule types that are assembled into Java. This facility counts executions of activities, flow rules, stream rules (harness, section, HTML, XML and so on),  and other rule types. When a node is shut down, these statistics are saved as…