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
  • 651 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.

 

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

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 and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
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 and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted 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...