Expand my Community achievements bar.

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

Filter on Update Feed

Avatar

Level 6

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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.