Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
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.