Note Text Report using filter "Does Not Contain" on multiple message wordings

[cmellic]

I need to create a Note Text report the filter out Note text containing multiple references.  Is there a way to do that?
Example:

I need to filter out Note Text does not contain "this" or "that" or "these" etc.

I'd like to add up to 10 of them.

[skyehansen]

I think if it were me, the first thing I would experiment with, is a solution similar to this one:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/work-in-progress-reporting-help...

in other words, once you construct your first "not contains" filter, just switch over to text mode and add the others, prepending each one with "AND:<number>:".

What are your thoughts about that?

[cmellic]

Hi Skye - I tried that. But perhaps I didn't do it correctly?  Now it doesn't show anything.

noteText=has passed its date of first use
noteText_Mod=cinotcontains
AND:1:noteText=the principal reviewer has decided that
AND:2:noteText=has passed its date of first use by
DE:task:01 CMP | Link to AWS S3 Bundle_Mod=isblank
ownerID=621fec4a001a637dbe10afa6e88e4eae
ownerID_Mod=in
project:portfolioID=620e57300006a100537a3cadf50b3cc7
project:portfolioID_Mod=in

[skyehansen · Accepted solution]

I can't speak to the rest of your filter but for the "AND" lines, I feel that you should add a second line to each.

So in other words, I feel that you should add:

AND:1:noteText_Mod=cinotcontains

AND:2:noteText_Mod=cinotcontains

You should see this reflected in the previous post link I sent -- i.e., did you see how each "AND:<#>" line consisted of two lines? 

[cmellic]

Thanks so much, this worked beautifully!