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: [EMAIL PROTECTED] > > > 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
