[rt-users] RT has the worst reporting system

[Kenneth Crocker]

Michael,

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
as
"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
criteria.

Kenn



On Wed, May 2, 2012 at 11:41 AM, ktm at rice.edu <ktm at rice.edu> 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.
>
> Regards,
> Ken
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120502/8fdb9e36/attachment.htm>