[rt-users] RT querybuilder problem

[Roedel, Mark]

Got this note from my director regarding our RT (v3.4.0) installation.
I've verified the same behavior by pasting into the Advanced Query
Builder at rt3.fsck.com.  Is this a bug in RT/DBIx::SearchBuilder, or a
problem with our expectations?
 
 
--
Mark Roedel
Web Programmer / Analyst
LeTourneau University
 
 

________________________________

From: Holeman, Gary 
Sent: Wednesday, February 02, 2005 10:55 PM
To: Roedel, Mark
Subject: WIT query problem


I've created a query that is giving me fits.  I finally had to use the
Advanced Query Builder to get it right.  What I want is:
 
( Status != 'resolved'  AND Status != 'rejected'  AND Due < 'today' )
AND (  ( Queue != 'ITS-BlackBoard'  AND Queue != 'ITS-General'  AND
Queue != 'WD-WebDevGeneral' ) OR ( Priority > 88  AND Queue =
'IT-Programming' ) ) 
 
But, when I switch back to the Query Builder mode, it changes that one
OR to an AND.  In the Query Builder, I can highlight that particular AND
and press the And/Or button.  It will change it to an OR, but if I run
it, it changes back to an AND.  Have you used this enough to see if I'm
doing something wrong or do you know of any bugs with this?
 
Gary
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050203/d0c1d5a6/attachment.htm>