Oddly, I think Ruslan's logic was correct. We have one for 'Older than x days' and it goes like this: LastUpdated < 'x days ago' AND ( Status = 'new' OR Status = 'open') AND ( Queue = 'General' OR Queue = 'Another Queue to Monitor')
You get the idea on the first line... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Izz Abdullah Sent: Wednesday, May 02, 2012 1:33 PM To: 'Ruslan Zakirov'; Michael Newland Cc: [email protected] Subject: Re: [rt-users] RT has the worst reporting system Isn't the logic there backwards? Shouldn't it be less than: Status = 'resolved' && Resolved < '7 days ago' We use this...I would have to look at the saved search -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ruslan Zakirov Sent: Wednesday, May 02, 2012 1:20 PM To: Michael Newland Cc: [email protected] Subject: Re: [rt-users] RT has the worst reporting system On Wed, May 2, 2012 at 10:18 PM, Michael Newland <[email protected]> wrote: > I am trying to create a query that will search resolved tickets within > the past 7 days. Anyone have any idea how to do this? Everything I > try is not giving me the results I am looking for. Status = 'resolved' && Resolved > '7 days ago' -- Best regards, Ruslan.
