I am trying to create a dropdown filter, where users can select activities and get all cases which pass through these activities. I tried 2 versions:
Using CASE WHEN and returning ‘TABLE’.‘ACTIVITY’ when it fits a certain pattern (with e.g. ‘TABLE’.‘ACTIVITY’ LIKE ‘String%Example%’). The problem here is that if I select any activity in the filter, my report is filtered just for the date of that activity and not the whole process chain. I.e. if I have a case that spans over 4 months, this filtering will only return that month when the activity happened.
Using CASE WHEN with PROCESS EQUALS and listing 1 activity in each WHEN option. It looks something like this:
WHEN PROCESS EQUALS ‘Activity A’ THEN ‘Activity A’
WHEN PROCESS EQUALS ‘Activity B’ THEN ‘Activity B’
However this filter doesn’t work with other filters and presents only 1 option. If I filter for some specific case which includes 5 of listed activities, this filter only allows me to select the first listed option. So filtering e.g. for Case 001 which should have Activities A,B,C,D,E will only allow to select the very first option which would be A, but I would like to see all 5 listed.
Is there any way to solve this topic?
Thanks for any help.