[rt-users] RT decides to change my query

Stephan Uhlmann su at inubit.com
Thu Aug 25 16:41:30 EDT 2005


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050825/08795c7e/attachment.sig>


More information about the rt-users mailing list