[rt-users] Query Help Please

[Mathew Snyder]

I am, in fact, getting errors.

070330 23:02:55 [ERROR] /usr/libexec/mysqld: Incorrect information in file:
'./rt3_devel/Users.frm'
070330 23:02:55 [ERROR] /usr/libexec/mysqld: Incorrect information in file:
'./rt3_devel/Queues.frm'
070330 23:02:55 [ERROR] /usr/libexec/mysqld: Incorrect information in file:
'./rt3_devel/Tickets.frm'


Jon Daley wrote:
>     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
>>
> _______________________________________________
> 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
>