[rt-users] Query for CC

Hef hef at tavros.net
Mon Jun 9 09:28:28 EDT 2008


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 'user at example.com' AND Cc.EmailAddress 
NOT LIKE 'user at example.com'

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 user at example.com?




More information about the rt-users mailing list