Will Cho Member since 2008 90 posts
Posted: 1 year ago
Last activity: 1 year 6 months ago

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:

  1. 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.
  2. 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.
Data Integration Java and Activities Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn