Need some advice with a query string

Greetings all,

RT 3.2.2
FreeBSD 4.10-RELEASE-p5
MySQL 4.0.18

I’m running into an odd problem with a query string on RT. We have
several queues, and I personally have to monitor three of them.
Right now the Query that runs as my home page is:

Status !=resolved
AND Status !=rejected
AND
Queue = queue1
OR Queue = queue2
OR Queue = queue3

What I need it to be is:
Queue = Queue 1
OR
Queue = queue2
AND Status !=rejected
AND Status !=resolved
OR
Queue = queue3
AND Status !=rejected
AND Status !=resolved

The reason for this is, I have one queue that is a call tracking queue,
and even when resolved, I need to be able to view those tickets.
However, when I run the query builder, even under advanced mode, I can
get the query built, until I try to search or save it. At that point,
it replaces the OR aggregators to AND, which results in no tickets
displayed, as they don’t exist in multiple queues.
Any advice?

Jon Catron
Webexcellence
PH: 317.423.3548 x22
FX: 317.423.8735
TF: 800.808.6332 x22
jcatron@webexc.com
www.webexc.com

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 3/9/2005

http://www.gossamer-threads.com/lists/rt/users/41430?#41430

There is a patch there that Anthony Leong submitted which may address
this. I haven’t had a chance to test that against my test instance, so
I can’t swear how effective it is. Make sure you back up and patch a
copy in your local tree.

DB

Domain Hostmaster wrote:

Jon,

This was discussed recently on the lists. Search for the string ‘query
builder’ in the gossamer lists ( http://www.gossamer-threads.com ) for
some of the threads on this problem.

It appears to be broken.

Stephen HancockOn Thu, 10 Mar 2005 12:33:22 -0500, Domain Hostmaster hostmaster@webexc.com wrote:

Greetings all,

RT 3.2.2
FreeBSD 4.10-RELEASE-p5
MySQL 4.0.18

I’m running into an odd problem with a query string on RT. We have
several queues, and I personally have to monitor three of them.
Right now the Query that runs as my home page is:

Status !=resolved
AND Status !=rejected
AND
Queue = queue1
OR Queue = queue2
OR Queue = queue3

What I need it to be is:
Queue = Queue 1
OR
Queue = queue2
AND Status !=rejected
AND Status !=resolved
OR
Queue = queue3
AND Status !=rejected
AND Status !=resolved

The reason for this is, I have one queue that is a call tracking queue,
and even when resolved, I need to be able to view those tickets.
However, when I run the query builder, even under advanced mode, I can
get the query built, until I try to search or save it. At that point,
it replaces the OR aggregators to AND, which results in no tickets
displayed, as they don’t exist in multiple queues.
Any advice?


Jon Catron
Webexcellence
PH: 317.423.3548 x22
FX: 317.423.8735
TF: 800.808.6332 x22
jcatron@webexc.com
www.webexc.com


No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 3/9/2005


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com