RT decides to change my query

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



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

smime.p7s (3.17 KB)