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?
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.
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?
RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.