Question
Cognizant
IN
Last activity: 20 May 2017 2:53 EDT
Class Join works with Index Class but Declarative Join doesnt
Hi,
I created a class Index-ABCD for reporting purpose and a corresponding Declare Index Rule - ABCD.
When I do a class join with the index table giving the following join condition:
JoinPrefix.pxInsIndexedKey is equal to .pzInsKey
I am able to fetch the indexed properties in my report and they display correctly.
However, when I do a declarative index join with the same- my report doesn't return any data on running.
I have seen several Pega OOTB reports using Class Join with an Index Class instead of a Declarative Join. Whats the difference and what is the issue am facing?
Accepted Solution
Pegasystems Inc.
IN
Hi,
The entries into the area,Declarive Index Join, will get automatically added, when you use the those index class properties in the Query tab.
For instance :
if we check the dataaccess tab, it gets automatically added.
Cognizant
IN
Thanks!
I was actually using a different Prefix Name than the Index Name- which works fine in case of a Class Join. Works after having the same name for Prefix as the Index Name.
Regards,
Bhagyashree