[rt-users] RT decides to change my query

Chris Benard chris at highlandclinic.com
Thu Aug 25 17:05:18 EDT 2005


It changes that to:
   (  Status = 'new' OR Status = 'open' ) AND  (   (  Owner = 'cbenard' 
) AND  (  Queue = 'General' AND Owner = 'Nobody' ) )

It doesn't like that OR.  It changes it to AND, no matter what.

Chris

Stephan Uhlmann wrote:
> On Thursday 25 August 2005 17:05, Chris Benard wrote:
> 
>>Here's what I'm trying to do:  I want to see all tickets in all queues
>>that are owned by me, and I want to see all tickets in General owned by
>>me or Nobody.  The only status on any of the tickets that I want to see
>>is open and new.
> 
> 
> 
> Try reducing your query to:
> 
> (
>    Status = 'new'
>    OR
>    Status = 'open'
> )
> AND
> (
>    (
>      Owner = 'cbenard'
>    )
>    OR
>    (
>      Queue = 'General'
>      AND
>      Owner = 'Nobody'
>    )
> )
> 
> 
> which should be logically the same and maybe doesn't trigger that bug. (If 
> that is a bug and not some genius perl function wanting to hint you at the 
> logical imperfectness of the structure. ;))
> 
> 
> Stephan
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Buy your copy of our new book, RT Essentials, today! 
> 
> Download a free sample chapter from http://rtbook.bestpractical.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3244 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050825/a83c4ebc/attachment.bin>


More information about the rt-users mailing list