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.
Accepted Solution
Pegasystems Inc.
IN
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
Pegasystems Inc.
IN
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
Sinarmas MSIG Life
ID
Pegasystems Inc.
IN
pyGetAllFollowedCases is an OOTB Report definition that uses class join, you can just search for it from Designer-Studio or Record Explorer
Accepted Solution
Pegasystems Inc.
IN
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
Pegasystems Inc.
US
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
Sinarmas MSIG Life
ID
Pegasystems Inc.
US
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.