Is the date format correct in $startDate, ie. does $startDate
equal '2007-03-23' exactly? That's the only possible difference, right?
If you turn on full SQL logs, what query do you see being run?
On Fri, 30 Mar 2007, Mathew Snyder wrote:
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
_______________________________________________
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
