Note Text Report using filter "Does Not Contain" on multiple message wordings | Community
Skip to main content
C
cmellic
Level 2
February 6, 2025
Solved

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

  • February 6, 2025
  • 1 reply
  • 647 views

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.

 

Best answer by skyehansen

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? 

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
February 6, 2025

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/m-p/730752#M65745

 

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?

C
cmellicAuthor
Level 2
February 14, 2025

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
Community Advisor
skyehansenCommunity AdvisorAccepted solution
February 14, 2025

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? 

Terms & ConditionsAccessibility statement

Loading footer...