I would like to create a project report, with project name not contain string/wording like "VAVE","A3", "Transfer" | Community

Level 2

Solved

I would like to create a project report, with project name not contain string/wording like "VAVE","A3", "Transfer"

Forum|Forum|2 years ago
October 17, 2023
2 replies
1377 views

I would like to create a project report, I do report filter with project name not contain string like "VAVE","A3", "Transfer"...etc.
But when I create the filter project name not contain "VAVE", then create another one not contain "A3", the later one will replace the previous one. how can I get a filter include more "not contain string"? is it a easier way to do this? or by text mode make fix this? thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by skyehansen

my suggestion is that you try using AND modifiers. Sample syntax attached here:

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

Level 4

This can be resolved by using an or statement.

Essentially you appear to have two cases here.

1 filter + Wave

or

1 filter + A3

you have to write it out twice said differently and put it together with an OR statement

Level 2

Thanks D_D, I tried, but it doesn't work, it still show projects which name include A3 and VAVE 😞

Level 4

Okay - then I read that wrongly. It sounds like you need an AND

Community Advisor and Adobe Champion

Accepted solution

my suggestion is that you try using AND modifiers. Sample syntax attached here:

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

Level 2

thanks Skyeh, it works! thank you for your help!