Allen; Can I also suggest a working practice we adopt and maybe relevant to your question, when we are waiting on a customer response we set a ticket status to stalled , and we have a global scrip to set a ticket status to open on correspondence. So when we look for tickets where the last correspondence was from a customer we simply look for (Status = 'open') AND ( Owner = '__CurrentUser__' ) ; again a process we have is if a ticket is owned its no longer 'new',
Apologies if its not relevant. Regards; Roy Ruslan Zakirov wrote: > Hi Alllen, > > Try LastUpdatedBy.EmailAddress not like '@...'. I think it works in > the latest RT. > > But there is no LastUpdatedBy IS AN UNPRIVILEGED USER thing. > > On Wed, Aug 12, 2009 at 4:02 AM, Allen<allen+rtl...@crystalfontz.com> wrote: > >> We would like to make a Saved Search that will show us all tickets >> where LastUpdatedBy was a client as opposed to one of our support >> staff. >> >> What would the correct TicketSQL be to get something like: >> >> (Status = 'open' OR Status = 'new' ) AND ( Owner = '__CurrentUser__' ) AND >> ( >> LastUpdatedBy IS AN UNPRIVILEGED USER >> OR >> LastUpdatedBy.User.Email Not like '@ourdomain.com' >> ) >> >> Is such a query possible in TicketSQL? >> >> I searched the web and could only find an announcement of release >> 3.6.7 where one of the change notes was: >> >> "* add id to the list of users' properties you can search by [ruz]" >> >> but I don't know how one actually searches on a user's property in the >> QueryBuilder. >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: sa...@bestpractical.com >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> >> > > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com