Filtering Cases by specific activity

 LIKE is used to compare strings, not process patterns.

try to use the following PQL 

FILTER COUNT_TABLE(
  CASE WHEN LOWER("ACTIVITY") LIKE '%reject%' THEN "CASE_ID" END
) > 0

Hi ​@Rami Agha Kassab,

Thank you for your answer. When I type in this PQL query I get an error:
 

If activity is the table name and activities is the column name, you should only use the column name in PQL (no table prefix).
FILTER COUNT_TABLE(
  CASE WHEN LOWER("ACTIVITIES") LIKE '%reject%' THEN "CASE_ID" END
) > 0
 

Hi Rami,

Unfortunately, I still get this error even when I use only column name. I managed to achieve my desired result with this PQL formula:

FILTER PU_COUNT("CASES", "_CEL_MERGED_ACTIVITIES"."ACTIVITY", "_CEL_MERGED_ACTIVITIES"."ACTIVITY" LIKE '%reject%') > 0;

The problem now is that, when I try to create reverse filter (only include cases that do not contain ‘reject’ string in activity name) I do get all cases and only activities are filtered out. For example when I add ‘NOT LIKE’ in PQL statement - all cases remain, but in case details, these activities are filtered out from the views.

Are you able to help on this one?