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
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies