[rt-users] Tickets: Query Builder - how to show tickets created within last 7 days?

[Todd Chapman]

RT uses Time::ParseDate for this.

http://search.cpan.org/~muir/Time-modules-2003.1126/lib/Time/ParseDate.pm

On Tue, Dec 07, 2004 at 01:20:47PM -0800, Pei Ku wrote:
> thanks Kevin - that worked.
> 
> apparently the query builder is doing more than just concatenating the WHERE clause... I queried Oracle's dynamic view to see the actual SQLs being executed by RT -- the WHERE clauses don't look exactly like what you see in RT's query builder.
> 
> Which brings to another question - is there documentation on what values you can set in the Query Builder?
> 
> thanks!
> 
> Pei
> 
> > -----Original Message-----
> > From: Kevin Murphy [mailto:murphy at genome.chop.edu]
> > Sent: Tuesday, December 07, 2004 1:05 PM
> > To: Pei Ku; rt-users at lists.bestpractical.com
> > Subject: Re: [rt-users] Tickets: Query Builder - how to show tickets
> > created within last 7 days?
> > 
> > 
> > Pei Ku wrote:
> > 
> > >I am trying to build and save a query within Query Builder 
> > that will show the tickets created within last 7 days.
> > >  
> > >
> > I'm totally ignorant on these matters, but with my PostgreSQL 
> > instance, 
> > I can select AFTER and then type in "8 days ago".  I doubt this is 
> > supported by PostgreSQL itself, so the magic may work for you 
> > also.  You 
> > can also say things like "last wednesday", etc.
> > 
> > Kevin Murphy
> > 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com