kenn.crocker at gmail
May 2, 2012, 12:29 PM
Post #6 of 7
Ruslan's logic is correct.
Although I believe it could be shorter since the "Resolved" field is a *date
field* and shouldn't have a value unless the ticket has been resolved.
Therefore 'Resoved > 7 days ago' would work as it interprets your situation
"if the resolved date has a date greater than 7 days ago', that would mean
any ticket with a "Resolved Date" within that last 7 days would meet the
On Wed, May 2, 2012 at 11:41 AM, ktm [at] rice <ktm [at] rice> wrote:
> On Wed, May 02, 2012 at 06:35:18PM +0000, Izz Abdullah wrote:
> > 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...
> The "<" should be translated as "before", not less than and ">" should be
> treated as
> "after" and not "greater than". So the query wants all ticket with a
> LastUpdated date
> AFTER the day, 7 days ago.