I am trying to build a query to find which tickets a user is not CC’d or
requester on. My query looks something like this:
Requestor.EmailAddress NOT LIKE ‘email@example.com’ AND Cc.EmailAddress
NOT LIKE ‘firstname.lastname@example.org’
The problem I run into is that if a tickets has multiple requesters, or
multiple cc’s, and this user is one of them, the ticket still gets
returned as a result.
The behavior makes sense, but how do I query for all requesters/cc’s are
not like email@example.com?