I got it all sorted out. Thanks. 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: [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 > > _______________________________________________ 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
