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

2006-09-13 Thread Jared Hanks
That worked great. Thanks, Jared From: "Jason A. Diegmueller" <[EMAIL PROTECTED]> To: Jared Hanks <[EMAIL PROTECTED]> CC: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Query Builder, report for last 7 days Date: Tue, 12 Sep 2006 23:57:50 -0400 (EDT) Jare

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 specif

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:

[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