Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.
SOLVED

Can "like" and "cilike" filter multiple values in the same way as "in" and "ciin"

Avatar

Level 3

One of my fields has 9 "contains" criteria, which has forced me to repeat ALL the other criteria 8 times. I was trying to use "cilike" to gather them in one place. I know "ciin" will take a comma-separated list, but that doesn't seem to work. 

 

In the example below, I only get records with "R1 Veeva submission," which is the first name in the list.

 

Here is my code:

plannedCompletionDate=2025-04-14T00:00:00:000-0700
plannedCompletionDate_Mod=between
plannedCompletionDate_Range=2025-07-01T07:00:00.000Z
projectPortfolioID=610c1e93002c8a1778d8ecabfbe8dd7d 614cb4720015ba98c58f09beab1d810b
projectPortfolioID_Mod=in
name=%R1 Veeva submission% %R1 PRC Comments Due% %Consolidated Feedback (PRC + Brand)% %R2 Veeva submission% %R2 PRC Comments Due% %Consolidated Feedback (PRC + Brand)% %Final Veeva Submission% %OPDP% %AFD%
name_Mod=cilike

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I can't answer your question about cilike, but I would suggest you try using "AND:<x>". Sample code can be found here:

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/filter-not-blank-and-not-x/m-p/...

 

You should be able to keep to one filter set and just repeat the ANDs 8 or 9 times.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

I can't answer your question about cilike, but I would suggest you try using "AND:<x>". Sample code can be found here:

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/filter-not-blank-and-not-x/m-p/...

 

You should be able to keep to one filter set and just repeat the ANDs 8 or 9 times.