Report Definition contains 2 different class
How to get value from 2 different class for report definiton?
I want to make report definiton with 10 column, but one of them is from different class, can I do that?
Thanks for all guidance.
-
Like (0)
-
Accepted Solution

For example
Check below Screenshots
I have used a class join in Data Access tab and gave it a prefix B and then I have used B.Column in Report Definition
Hi Maulana,
Class joins may be used to enable reporting on data from multiple classes or tables. You can set this in the Data Access tab of the Report Definition. For each class join, define one or more logical conditions that specify how to match or join corresponding instances in different classes.
Please refer the following help document for detailed steps.
https://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm
Thanks,
Shreshta

Hi Maulana,
For example please have a look at OOTB report pyGetAllFollowedCases
Regards,
Ujjwal

pyGetAllFollowedCases is an OOTB Report definition that uses class join, you can just search for it from Designer-Studio or Record Explorer

I'm using Pega 7.2.1 version. I only got this.
Accepted Solution

For example
Check below Screenshots
I have used a class join in Data Access tab and gave it a prefix B and then I have used B.Column in Report Definition

Hi Maulana,
Joins are useful when we associate two different classes and present columns which belong to the class in the second class. For example, we use a predefined association between Assign-Worklist and the work class to display columns belonging to both these classes.
As your intention is just to display the properties from two different classes then you can use Class Joins.
Hope this information might be helpful for you.
Regards
Mahesh

For example, you can look into Assign-Worklist.pyAgeByAssigneeByWorkType report definition to see how class can be joined in Data Access tab. Hope it might help you.