[rt-users] combine 'and' 'or' in queries - cant do it?
Thornton, Patrick J
patrick.j.thornton at lmco.com
Mon May 1 09:17:59 EDT 2006
Not sure if there is a solution to your question, but this should work
as a quick fix:
Status !='stalled'
AND Status !='rejected'
AND Status !='resolved'
AND created/lastupdates < -48 hours
Pat
-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of TeleMole
Sent: Monday, May 01, 2006 9:06 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] combine 'and' 'or' in queries - cant do it?
HI all,,
I am trying to build a saved search that will show me all tickets that
are over 48 hours old with either no response or update.
So i need to see tickets that are 'new' OR 'open' AND
created/lastupdates < -48 hours - every time i try to create it - it
only allows me to switch all the or's to and's or vice versa....
why is this? Should i not be able to cerate the query above? Am I
missing something obvious? thanks in advance!
Sean Daniels
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
More information about the rt-users
mailing list