Discussion

1
Replies
397
Views
VinayY88 Member since 2015 10 posts
Infosys
Posted: 5 years ago
Last activity: 5 years ago
Closed

Sort and Filter not working for property with Declare Expression

Hi,

 

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?

 

Many thanks..!!

Regards,

Vinay

Reporting
Close popover
Moderation Team has archived post
Posted: 5 years ago

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.


 


Work -


Report definition - pyAgeOpenByClass invokes SQL function pxSLAAgeTimelines


Report definition - pyAgeResolvedByResolverOrg invokes SQL function pxSLAWorkTimeliness


Important properties - pySLAGoal and pySLADeadline


 


Assign-


Report definition - pyAgeByAssignee invokes SQL function pxSLAAssignTimeliness


Important properties - pxGoalExecute and pxDeadlineExecute


 


History-Work-


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:



 


Bob Lloyd


PDN Forums Support
Share this page LinkedIn
Copied!