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 PROTECTED]' AND Cc.EmailAddress NOT LIKE '[EMAIL PROTECTED]' 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 PROTECTED] _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
