Expand my Community achievements bar.

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.