That worked great.
Thanks,
Jared
From: "Jason A. Diegmueller" <[EMAIL PROTECTED]>
To: Jared Hanks <[EMAIL PROTECTED]>
CC: [email protected]
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: [EMAIL PROTECTED]
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/
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
