Will Cho Member since 2008 100 posts
Posted: October 15, 2018
Last activity: March 21, 2019

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