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: [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
