[rt-users] Query Help Please

Mathew Snyder theillien at yahoo.com
Fri Mar 30 03:59:37 EDT 2007


This is what's in Query Builder:

Queue = 'CustomerCare' AND  (  LastUpdated > '2007-03-23' OR Resolved >
'2007-03-23' )

It returns 168 tickets.

This is what I have in the script:
"Queue = 'CustomerCare' AND (LastUpdated > '" . $startDate . "' OR Resolved > '"
. $startDate . "')"

It returns 0 tickets.


Mathew Snyder wrote:
> 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: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 



More information about the rt-users mailing list