Adding more than one namecontains rule to one line.

Question

Hello,

I was curious if it is possible to add more than one "namecontains" rule to a filter int text mode. I know I can use OR to add a new set of rules but it would make my life easier if it were possible to add more than one contains rule.

For example. I am attempting to pull projects with "Red" in the name but also I want to find projects with "Blue" in the name. I would like to make one rule that says "Project with Red or Blue in the name pull in" rather than make two separate rules. Is this possible in text mode?

Thank you

skyehansen · Accepted Answer

I'm thinking you might want this old trick published by Galen and more recently by Doug. (showing both since there are variations in syntax that might come in useful)

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

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/and-another-textmode-trick/td-p/619792

RandyRoberts · Answer

Check out "IFIN". Explanation here: https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions.html?lang=en

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded