[rt-users] Query Help Please

[Ruslan Zakirov]

Mathew, how it's possible that the same date field equal to
'2007-04-01' and '2007-04-07' at the same time?

On 4/8/07, Mathew Snyder <theillien at yahoo.com> wrote:
> How do I do a query that searches for a range up to and including a date?
>
> I have this:
>  Queue = 'CustomerCare' AND  (   (  LastUpdated < '2007-04-07' AND LastUpdated >
> '2007-04-01' ) OR  (  LastUpdated = '2007-04-01' AND LastUpdated = '2007-04-07' ) )
>
> But it's returning 0 results.  If I change the 'OR' to an 'AND' it still returns
> 0.  Using '>=' and '<=' doesn't work either.
>
> Mathew
>
> 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
>


-- 
Best regards, Ruslan.