I tried that - when I clicked on save - the ands and ors were reverted :(
On 5/1/06, Kristopher Lusk <[EMAIL PROTECTED]> wrote:
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thornton, Patrick J Sent: Monday, May 01, 2006 8:18 AM To: TeleMole; [email protected] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of TeleMole Sent: Monday, May 01, 2006 9:06 AM To: [email protected] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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
