Sort and Filter not working for property with Declare Expression
I have requirement where I have to show the total age of a case in a report. This report will be displayed on start up tab (so no preactivity for calculating age or copying it into another property) and I am using report defination for report directly on repeating layout and enabled filter and sorting for all the columns in report defination. For calculating age I have written a Declare expression on Age property and referred it in RD and in the grid but the sorting and filtering functionality is not working here. Is there anyother way that I could make this workout?
You might want to consider studying one of the standard shipped report definitions and SQL functions below used to determine aging and timelines. Remember, you can "Save As" Pega standard reports as templates to begin your own.
Report definition - pyAgeOpenByClass invokes SQL function pxSLAAgeTimelines
Report definition - pyAgeResolvedByResolverOrg invokes SQL function pxSLAWorkTimeliness
Important properties - pySLAGoal and pySLADeadline
Report definition - pyAgeByAssignee invokes SQL function pxSLAAssignTimeliness
Important properties - pxGoalExecute and pxDeadlineExecute
Report definition - pyAgeByFlowAssignment invokes SQL function pxSLAHistoryTimeliness
Important properties - pxAssignmentPastGoal and pxAssignmentPastDeadline
In addition if you need to determine and capture statistics related to performance of a flow action or an assignment , refer below link: