[rt-users] Query Help Please

[Jon Daley]

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