This is my query I’m trying to do:
(
Status = 'new’
OR
Status = ‘open’
)
AND
(
(
Owner = ‘cbenard’
)
OR
(
Queue = 'General’
AND
(
Owner = 'cbenard’
OR
Owner = ‘Nobody’
)
)
)
RT changes my query to say AND, instead of OR after the owner of
cbenard. I’ve formatted this SEVERAL ways, but none seem to work.
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.
Thanks,
Chris Benard
smime.p7s (3.17 KB)
At Thursday 8/25/2005 11:05 AM, Chris Benard wrote:
RT changes my query to say AND, instead of OR after the owner of
cbenard. I’ve formatted this SEVERAL ways, but none seem to work. 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.
You might find that the ‘Advanced’ search screen is the best way to do what
you need -
Steve
This is where I typed the query. It changes my query when I hit apply.
It’s extremely frustrating.
Chris
Stephen Turner wrote:
smime.p7s (3.17 KB)
At Thursday 8/25/2005 11:05 AM, Chris Benard wrote:
This is my query I’m trying to do:
(
Status = ‘new’
OR
Status = ‘open’
)
AND
(
(
Owner = ‘cbenard’
)
OR
(
Queue = ‘General’
AND
(
Owner = ‘cbenard’
OR
Owner = ‘Nobody’
)
)
)
RT changes my query to say AND, instead of OR after the owner of
cbenard. I’ve formatted this SEVERAL ways, but none seem to work. 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.
I’d say this is definitely a bug - I can reproduce it in 3.4.1 and 3.4.2.
For me it also changes the final AND to OR
Steve
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
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
The rt-users Archives
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
smime.p7s (3.17 KB)