How to join Multiple Class Properties in One Report in Pega

How to join Multiple Class Properties in One Report in Pega

Hi Friends , in this post I am going to give a demo on how to perform Join in Pega Report

First of all I created Two class , the structure of class in below image.

Here CustomerID is primary class of CustomerDetails Class and it is a Foreign Key of CustomerPolicyDetails Class so , by CustomerID we can access all the property in CustomerPolicyDetails Class. Below image shows the data I entered in both classes .

Now i created the report in class CustomerDetails.

Now I am adding the properties to access the table contents.

Here U can see I added CPD in front of PolicyDetails dont confuse with that, in next image u can see why we have to add this.

For Joining another one class in report, we have to give Prefix(Any value for accessing the property example: CPD.CustomerName, CPD.CustomerID, CPD.CustomerCity like that for referencing only we used this no other uses.) then we have to give class name (which class property we are going to use.) no need to change the Type , then click Edit Condition, it will open a box like below image.

Here u can add the filter, how to filter the data.In my example, I have to select all the policy id in CustomerPolicyDetails whose customer id is CustomerID in CustomerDetails Class.

U can see the results, by running the report.

If u not understood means U can ask me any Qns, Thanks For reading 😊