Skip to main content

Table of Contents

Creating class joins in reports


Only available versions of this content are shown in the dropdown

Extend the scope of your report by displaying data from various classes. For example, if your report about insurance policies applies to the Work- class, you can include specific data from different classes by joining the classes together.

By default, report definitions include data from only the class to which the report applies. By using the class join functionality, you can make your reports more comprehensive.

In comparison with association rules, joins are not reusable across multiple report definitions, and apply only to the report that you edit.

  1. In the navigation pane of Dev Studio, click Records, and then click Reports Report definition .

  2. In the list of report definitions, click the report definition that you want to edit.

  3. Click the Data access tab.

  4. Create a join between classes:

    1. In the Class joins section, click Add class join.

    2. In the Prefix field, enter a short alias for the class that you want to join with the class to which your report definition applies.

      The prefixes help the system to distinguish classes and ensure that classes are joined accurately.
      Enter A.
    3. In the Class name field, enter the name of the class that you want to join.

    4. Click Edit conditions.

    5. In the Column field, specify a property of the class that you want to join.

      If you set the prefix as A, enter A.pyID.
    6. In the Value field, enter a property of the class to which your report definition applies, and then click Submit.

      Enter .pyResolvedUserID to create a join between data in A.pyID and .pyResolvedUserID classes. The join provides the assignment ID and the name of the responsible assignee.
    7. In the Type list, select the type of join to use.

      Select Only include matching rows to include rows that contain common data for both classes.
  5. Click the Query tab, and in the Edit columns section, click Add column.

  6. In the Column source field, enter the prefix of the joined class, and then select the specific properties that you want to include in the report.

    Enter A.pyID to include the data of the joined A.pyID and .pyResolvedUserID classes.
  7. In the upper-right corner of the report definition, click Save.

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