Question
Vodafone Shared Services India
IN
Last activity: 30 Mar 2017 4:35 EDT
difference between joins and association in report definaton
Hi,
Can Anybody help with the exact difference between joins and association in report defination.
Regards,
Prashant Nagargoje
Accepted Solution
Pegasystems Inc.
US
Hi Prashant,
Use an Association rule to define a relationship between two classes based on matching values in pairs of properties. A typical use of an association rule is to enable your application to automatically add a join to a report that displays properties from both classes referenced in the association.
Regards
Mahesh
Pegasystems Inc.
US
Hi Prashant,
This was already discussed over here, please look into this information.
Regards
Mahesh
Vodafone Shared Services India
IN
HI Mahesh,
as per your comment, "For example, If you want to join Class A with Class C where you don't have a common column in them, then we use multiple association."
can you please explain this little more.
Thanks,
Prashant
Pegasystems Inc.
US
Hi Prashant,
For example, if you see the association pxAssignedWorkGroupInfo we are making the multiple association between 3 classes i.e. Work-, Assign-Worklist and Data-Admin-WorkGroup as shown below.
- Work- and Assign-Worklist classes are being joined based on Assign-Worklist.pxRefObjectKey equal to Work.pzInsKey
- Assign-Worklist and Data-Admin-WorkGroup classes are being joined based on Assign-Worklist.pxWorkGroup equal to Data-Admin-WorkGroup.pyWorkGroupName
Note: Class A is joined with Class B and Class B in turn joined with Class C => This is the usage of the multiple association to fetch the data from all the 3 classes, when you don't have common column in all the 3 classes.
Hope this makes you clear about the multiple association usage.
Regards
Mahesh
Accepted Solution
Pegasystems Inc.
US
Hi Prashant,
Use an Association rule to define a relationship between two classes based on matching values in pairs of properties. A typical use of an association rule is to enable your application to automatically add a join to a report that displays properties from both classes referenced in the association.
Regards
Mahesh
Blue Rose Technologies GmbH
BE
Hi,
Please have a look on the below article :
https://docs-previous.pega.com/when-and-how-create-association-rule-support-reporting
Thanks.
Vodafone Shared Services India
IN
My questions is 'what is advantage of using associations above joins'. Above mentioned things can be achieved with Joins as well.
Pegasystems Inc.
IN
Associations are just a way of defining the join outside the RD as a separate rule. They both achieve the same purpose. But one advantage with using associations is that you are decoupling the logic/join conditions so that they can be used in multiple RDs without having to define the same join conditions every time.
E.x. If you need to join work class RDs with other class (let's say tag class) many times in you application, then it will be better to create an association rule to define the join and conditions and reuse the same across multiple RDs.
Let us know if this helps :)