Show Age (in business days) of case in Report Definition
My client has a use case to report an Age (business days) of a case that considers client’s business calendar.
How can we show that in report definition?
Looks like differenceBetweenDays function (attached) calculates what we need, but we don’t know how to use it for RD.
We tried:
- When we used a declare expression (that calls differenceBetweenDays), it calculates and shows Age as expected but the Filter/Sorting in RD do not work.
- When we tried to create a Function Alias (of the Java function below) in Embed-UserFunction (so that it shows up in RD), it would not save.
Pegasystems Inc.
IN
Hi Will,
Thanks for posting on PSC.
Why can't you use differenceBetweenDays function to calculate the difference on RD and even you can apply filtering.
Kindly look onto the attached screen shots might be helpful.
Pegasystems Inc.
IN
Hi Will,
The property which is associated to calendar also can be used in Report definition column and can calculate the difference.
Hope this might be helpful.
Sunera Technologies
US
Hi,
how can we use this difference value in the column in repeating grid. for full name function we use the .pyTextValue() but it can return the text values only . I want display the Difference between the dates in grid.
Pegasystems Inc.
IN
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.