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

Jared Hanks jmhanks1373 at hotmail.com
Wed Sep 13 12:24:50 EDT 2006


That worked great.

Thanks,
Jared


>From: "Jason A. Diegmueller" <doogles at doogles.com>
>To: Jared Hanks <jmhanks1373 at hotmail.com>
>CC: rt-users at lists.bestpractical.com
>Subject: Re: [rt-users] Query Builder, report for last 7 days
>Date: Tue, 12 Sep 2006 23:57:50 -0400 (EDT)
>
>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
>>

_________________________________________________________________
Got something to buy, sell or swap? Try Windows Live Expo  
ttp://clk.atdmt.com/MSN/go/msnnkwex0010000001msn/direct/01/?href=http://expo.live.com/




More information about the rt-users mailing list