Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Twenty-seven commonly used Join conditions for list view and summary view reports

Updated on September 20, 2019

Summary

Using the Join feature, you can include data from exposed columns in multiple (concrete) classes in your list view and summary view reports.

This article lists the 27 most common joins used with standard classes and properties. 

Suggested Approach

To complete the Join tab of a list view or summary rule, choose a prefix for the joined class, enter the full class name, and click Edit Conditions. In the Join Conditions pop-up dialog, identify the property in the joined class that is to match a specific property in the original class (the Applies To class of the rule, or an ancestor of that class).

In the example below, the original class is Assign-Worklist. The joined class is Data-Admin-Operator-ID, identified succinctly with the prefix "Oper". The match is to the Assign- property pxAssignedOperatorID.

26279

This join allows you to include any of several scalar properties in the Data-Admin-Operator-ID class in the report display.

To simplify your use of this feature, the table below shows many commonly used joins that connect standard properties and classes. Of course, you are not limited to using only those listed.

Original
Joined
Class
Property
Class
Property
Assign-.pxAssignedOperatorIDData-Admin-Operator-ID.pyUserIdentifier
Assign-.pxCreateOperatorData-Admin-Operator-ID.pyUserIdentifier
Assign-.pxUpdateOperatorData-Admin-Operator-ID.pyUserIdentifier
Assign-.pxAssignedOrgUnitData-Admin-OrgUnit.pyOrgUnit
Assign-.pxAssignedOrgDivData-Admin-OrgDivision.pyOrgDivision
Assign-.pxAssignedOrgData-Admin-Organization.pyOrganization
Assign-Workbasket.pxAssignedOperatorIDData-Admin-WorkBasket.pyWorkBasket
Assign-Workbasket.pxWorkGroupData-Admin-WorkGroup.pyWorkGroup
Assign-Worklist.pxWorkGroupData-Admin-WorkGroup.pyWorkGroup
Index-.pxCreateOperatorData-Admin-Operator-ID.pyUserIdentifier
Index-.pxUpdateOperatorData-Admin-Operator-ID.pyUserIdentifier
Link-Attachment.pxLinkedRefToData-WorkAttach-File.pzInsKey
Link-Attachment.pxLinkedRefToData-WorkAttach-Note.pzInsKey
Link-Attachment.pxLinkedRefToData-WorkAttach-URL.pzInsKey
Work-.pxCreateOperatorData-Admin-Operator-ID.pyUserIdentifier
Work-.pxUpdateOperatorData-Admin-Operator-ID.pyUserIdentifier
Work-.pzInsKeyLink-Attachment.pxLinkedRefFrom
Work-.pzInsKeyLink-Folder.pxLinkedRefFrom
Work-.pyOrigOrgUnitData-Admin-OrgUnit.pyOrgUnit
Work-.pyOrigDivisionData-Admin-OrgDivision.pyOrgDivision
Work-.pyOrigOrgData-Admin-Organization.pyOrganization
Work-.pyOwnerOrgUnitData-Admin-OrgUnit.pyOrgUnit
Work-.pyOwnerDivisionData-Admin-OrgDivision.pyOrgDivision
Work-.pyOwnerOrgData-Admin-Organization.pyOrganization
Work-.pzInsKeyAssign-WorkBasket.pxRefObjectKey
Work-.pzInsKeyAssign-Worklist.pxRefObjectKey
Work-.pzInsKeyIndex-WorkPartyUri.pxInsIndexedKey

Tags

Pega Platform 7.1.1 - 7.4 Reporting Financial Services Healthcare and Life Sciences Insurance Communications and Media Government Healthcare and Life Sciences Consumer Services Consumer Services Manufacturing Consumer Services

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us