Support Article
Invalid subreport join or filter condtion error
SA-18225
Summary
Subreport filter conditions, return an error message. These conditions were working on PRPC 6.3 SP1.
Error Messages
Invalid subreport join/filter condition: The properties referenced in a subreport join/filter condition must either be optimized, or all unoptimized
Steps to Reproduce
1. Create Report Definition with the below settings:
- Main report joins to subreport
- The subreport contains optimized property and page group item
- Subreport join condition configured with optimized property
- Main report contains the subreport's page group item
- Main report has filter which can specify the subreport's page group item
2. Open the report
3. Input filter condition on the column which refers to subreport's page group item
4. Run the report
Root Cause
A defect in Pegasystems’ code or rules which was causing this error even after setting "useStreamInJoinConditions" as "true".
Resolution
Apply HFix-25388 along with setting "useStreamInJoinConditions" as "true" in the configuration.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.