Skip to main content
Question

Filter specific value in specific column

  • March 25, 2021
  • 2 replies
  • 40 views
.
Level 3
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?

2 replies

D
Level 1
Forum|alt.badge.img+2

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

.
Level 3
  • .14600843
  • Author
  • Level 3
  • March 29, 2021
Thanks David. That solves the issue
Community Code of ConductAccessibility statement