Issues with Report Defintion after upgrade from Pega 7.3.0 to Pega 8.2.4
Hi,
after the upgrade from Pega 7.3.0 to Pega 8.2.4, our report definitions with class joins are returning empty results when the option "Report on descendant class instances" is set to "Include all descendant classes". But if we change this to "Include Implementation class only" it works.
I want to understand why it is behaving like this? Why is the behavior different in Pega 8?
Regards,
Herve
Accepted Solution
Pegasystems Inc.
US
Please check below pnd link:
"Include all descendant classes" applies to the Applies to Class. It does not apply to Join classes.
If descendant classes are in multiple class tables, the query may fail if the referenced properties are not optimized.
Pegasystems Inc.
IN
Can you check the query being fired by the RD in both cases using tracer.
Check if it is querying from the correct table or not. If the query is correct then run the same query in the DB directly and see if you are getting the result or not.
Also are the properties exposed or not?
Accepted Solution
Pegasystems Inc.
US
Please check below pnd link:
"Include all descendant classes" applies to the Applies to Class. It does not apply to Join classes.
If descendant classes are in multiple class tables, the query may fail if the referenced properties are not optimized.