[rt-users] RT has the worst reporting system

[ktm at rice.edu]

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