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
