[rt-users] Query Builder, report for last 7 days

[Jason A. Diegmueller]

Jared-- (cc: rt-users)

RT accepts some "natural language" date queries, such as "7 days ago" or 
"yesterday".

Here's an example Saved Search we use:
"Status = 'open' AND LastUpdated < '7 days ago' AND  (  Queue =
  'projects' OR Queue = 'support' )"

-jd

On Tue, 12 Sep 2006, Jared Hanks wrote:

> Hello,
>
> I'm using the Query Builder in RT and would like to create a report for 
> tickets created in the last 7 days.  I'm able to get the report to look the 
> way I want, but just am unable to generate this for the last 7 days.  I can 
> use a specific date, but I would like to easily be able to run this search in 
> the future without having to change the date.
>
> Any help or suggestions is appreciated.
>
> Thanks,
> Jared
>
> _________________________________________________________________
> Get real-time traffic reports with Windows Live Local Search 
> http://local.live.com/default.aspx?v=2&cp=42.336065~-109.392273&style=r&lvl=4&scene=3712634&trfc=1
>
> _______________________________________________
> 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
>