Filter on Update Feed | Community
Skip to main content
A
Anonymous
July 15, 2024
Solved

Filter on Update Feed

  • July 15, 2024
  • 1 reply
  • 440 views

Hi Community,

 

I've created a Note report filtering on a specific user tag (the USERID). I've got the below which works, but I need to add a few keyword exclusions and can't get that to work. e.g. if I want to surface all comments for the user that excluded the terms "all done" & "this is one", how would I show that please?

 

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=NTAG
EXISTS:a:note:threadID=FIELD:threadID
EXISTS:a:userID=63da3b4400084e28b091db59576247ce

 

Thanks

Matt

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 Richard_Le_

Hi Matt,

 

Give the below a try:

 

AND:1:EXISTS:a:$$EXISTSMOD=EXISTS

AND:1:EXISTS:a:$$OBJCODE=NTAG

AND:1:EXISTS:a:note:threadID=FIELD:threadID

AND:1:EXISTS:a:userID=643d2ecd00163f3e33acfb5bb0debbd5

AND:1:EXISTS:a:userID_Mod=eq

AND:1:noteText=all done

AND:1:noteText_Mod=cinotcontains

EXISTS:a:$$EXISTSMOD=EXISTS

EXISTS:a:$$OBJCODE=NTAG

EXISTS:a:note:threadID=FIELD:threadID

EXISTS:a:userID=643d2ecd00163f3e33acfb5bb0debbd5

EXISTS:a:userID_Mod=eq

noteText=this is done

noteText_Mod=cinotcontains

 

Best Regards,

Rich.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
July 16, 2024

Hi Matt,

 

Give the below a try:

 

AND:1:EXISTS:a:$$EXISTSMOD=EXISTS

AND:1:EXISTS:a:$$OBJCODE=NTAG

AND:1:EXISTS:a:note:threadID=FIELD:threadID

AND:1:EXISTS:a:userID=643d2ecd00163f3e33acfb5bb0debbd5

AND:1:EXISTS:a:userID_Mod=eq

AND:1:noteText=all done

AND:1:noteText_Mod=cinotcontains

EXISTS:a:$$EXISTSMOD=EXISTS

EXISTS:a:$$OBJCODE=NTAG

EXISTS:a:note:threadID=FIELD:threadID

EXISTS:a:userID=643d2ecd00163f3e33acfb5bb0debbd5

EXISTS:a:userID_Mod=eq

noteText=this is done

noteText_Mod=cinotcontains

 

Best Regards,

Rich.

Terms & ConditionsAccessibility statement

Loading footer...