Skip to main content
This content is now archived and is no longer updated. Progress is not calculated. Pega Cloud instances are disabled, and badges are no longer awarded.

Creating associations and joins in reports

Creating associations and joins in reports

You can report on records in multiple classes mapped to one or more data tables. To create these reports, in a report definition you can reference an association rule or configure a class join.

Referencing an association rule

After you create a report definition in the class you want to report on, reference an association rule to join another class.

  1. Open your report definition.
  2. In the Edit columns section, in the Column source and Column name fields, enter the name of the association rule you want to reference. The system uses the prefix for the properties you want to include.

    The following example shows the pxWorkbasketAssignments association rule prefix and properties.

    workbasket columns
  3. Click Save to save your reference to the association rule. When you add a column that uses an association, the system automatically references the association. The Associations field on the Data Access tab displays the association.

Configuring a class join

After you have created a report definition in the class you want to report on, create a class join to establish a relationship to instances of another class.

  1. Open your report definition.
  2. On the report definition form, open the Data Access tab.
  3. In the Class joins section, click Add class join to add a row.
  4. In the Prefix field, enter a prefix for the class to join to the report definition. Use this prefix to reference properties in the class.
  5. In the Class name field, enter the class to join to the report class. The form looks like the following image.
    class join procedure
  6. At the end of the row, click Edit conditions. The system displays the Enter filter conditions dialog.
  7. In the Column field, select a property within the joined class.
  8. In the Value field, enter a property in the report definition's Applies To class.
    filter procedure
  9. Click Submit to save your filter condition and close the Enter filter conditions dialog.
  10. Open the Query tab.
  11. In the Edit columns section, enter Column source and Column name values.
    Note: Use the class prefix to find properties in the joined class you want to include in the report.

    When you are done, the report definition looks like the following image.

  12. Click Save to save the join configuration in your report definition.

This Topic is available in the following Module:

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

Pega Academy 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