Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

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

Avatar

Level 3

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!01.png

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 4
6 Replies

Avatar

Level 3

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 

Avatar

Level 3

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

Avatar

Level 3

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

Avatar

Correct answer by
Level 4

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/...