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

2006-09-13 Thread Stephen Turner
At Tuesday 9/12/2006 05:57 PM, 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

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

2006-09-12 Thread Jared Hanks
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

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

2006-09-12 Thread 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,