[rt-users] Query for Created 'Last Month'?

Ruslan Zakirov ruz at bestpractical.com
Thu Jul 3 09:14:07 EDT 2008


Created > 'Last Month'

On Thu, Jul 3, 2008 at 4:34 PM, Jean-Sebastien Morisset
<jsmoriss at mvlan.net> wrote:
> Hi everyone,
>
> I'm not very good with SQL queries, so I'm having trouble constructing
> a URL like this to select all tickets from last month...
>
> http://rt.me.org/Search/Results.tsv?Order=DESC%7CDESC%7CDESC%7CASC&Query=%20Created%20%3E%20'2008-06-01'%20AND%20Created%20%3C%20'2008-06-30'&...etc...
>
> It would be nice if "Created = 'Last Month'" would work, but of course,
> it doesn't. :-) Any ideas?
>
> js.
> --
> Jean-Sebastien Morisset, Sr. UNIX Administrator <jsmoriss at mvlan.net>
> _______________________________________________
> 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.



More information about the rt-users mailing list