My query:

'Queue = "CustomerCare" AND ((Status = "open" AND LastUpdate > $startDate) OR
(Status = "resolved" AND Resolved > $startDate))'

This, unfortunately, returns all resolved tickets (I'm not sure what it returns
for open tickets).  How can I modify this to only return tickets that are open
and updated according to the date held in $startDate and/or are resolved and
have been resolved according to the date held in $startDate?

For the record, the date is one week prior to the day the script is run.

Mathew
_______________________________________________
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

Reply via email to