My activity table is having three columns ACTIVITY_EN, CHNAGED_FROM, and CHANGED_TO. Now I want to filter all cases which are ever passed through the Cancelled value in CHANGED_TO or CHANGED_FROM column. How can I filter these cases?
Page 1 / 1
Hi,
you can use the CALC_REWORK function, which essentially allows you to count the number of activities per case fulfilling a condition. You want to filter on cases where the result of this is larger than 0:
FILTER CALC_REWORK( Activities.CHANGED_FROM=Cancelled OR Activities.CHANGED_TO = Cancelled ) > 0;
Best
David
Thanks David. That solves the issue
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.