[rt-users] combine 'and' 'or' in queries - cant do it?

[Kristopher Lusk]

What I do when I have this problem is get as much of the query as I can
created in the Query Builder, then I click on Advanced and change things
around there (e.g. ANDs to ORs, ORs to ANDs, etc.).  This usually gets me
what I want.

Kris



-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Thornton,
Patrick J
Sent: Monday, May 01, 2006 8:18 AM
To: TeleMole; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] combine 'and' 'or' in queries - cant do it?

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


_______________________________________________
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