[rt-users] Query Help Please

[Kenneth Crocker]

Mathew,


	I'm not a perl expert by any stretch, but I've coded in over 25 
different languages over several decades (I'm really old) so my comments 
are in relation to the conditional logic, not syntax. It seems to me as 
I look at the "OR Resolved > $StartDate" part, you will always get a 
positive result. Reason: I do not think it is possible to have a start 
date less than the resolved date and since the logic said "OR" it will 
always meet that condition. This is also based on the assumption that 
the date formats are consistent. Just a thought.

Kenn
LBNL

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
>