PEGA Report Filter with Last Hour Symbolic Date Equivalent
The property to be displayed is .pxCommitDateTime configured with UI Control Format DateTime-Long.
For our report filter, we want to report the LAST HOUR of committed cases. We have tried the argument:
.pxCommitDateTime IS GREATER THAN @addToDate(.pxCurrentDateTime, 0, -1, 0, 0)
The two issues with that attempted solution is:
1) .pxCommitDateTime is not comparable to .pxCurrentDateTime because of their different formats
2) Java functions, such as @addToDate(), is not allowed for defining filter values.
What is a good solution approach? Thank you for your attention.
Updated: 23 Sep 2021 17:42 EDT
Infosys
US
We use the function builder on the LEFT column. Use "Difference in Hours" to compare two time properties. Use the argument "less than or equal to". Set the right hand value to 1. And so, you will have the equivalent of Symbolic DateTime of "Last Hour". Obviously, applicable to any hourly or higher frequency you want with some precision limitations.
A possible issue is Oracle rounding rules may get you a duration between 1 to 1.5 hours as indicated by the function description.
Pegasystems Inc.
IN
@PaulS968You can use the "Difference in Minutes" function and see if the value is less than or equal to 60 so that you get the cases committed in the last hour. Please find the below screenshot for more details.
