Support Article
Reportfilter not working when using filter functions
SA-12331
Summary
Developer created a Report Definition which is configured with filter conditions as "pyResolvedTimestamp is not null" OR "The difference in months between [Earlier Date Value] and [Later Date Value]" is less than or equals 18 months , They noticed that when they tried to set other filter on any column, report is displaying the wrong set of results.
Error Messages
No Error Message. But Report is returning wrong set of results.
Steps to Reproduce
1. Create a report definition rule with some OOTB properties like pyID, pyResolvedTimeStamp, pxCreateDateTime,
2. Give two filter conditions
A. pyResolveTimestamp is not null
B. pyworkstatus is equal "New","Resolved-Completed".
3. add two conditions with OR operator.
4. Run the report and try to put filter on Case ID column in report viewer.
Root Cause
The root cause of this problem is a defect in Pegasystems’ code/rules pxRetrieveReportData , pzClearRDTempFilters
Resolution
This issue is resolved by hotfix item HFIX-23124
Published July 17, 2015 - 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.