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

[Pei Ku]

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
>