Question


Sinarmas MSIG Life
ID
Last activity: 22 Nov 2017 23:04 EST
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)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
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


Pegasystems Inc.
IN
Hi Maulana,
For example please have a look at OOTB report pyGetAllFollowedCases
Regards,
Ujjwal


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


Sinarmas MSIG Life
ID
I'm using Pega 7.2.1 version. I only got this.
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


Sinarmas MSIG Life
ID
Thanks bro, very helpful for me


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.


Sinarmas MSIG Life
ID
Thanks bro, very helpful for me