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
_______________________________________________
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
