[rt-users] Need some advice with a query string

[Stephen Hancock]

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 Hancock


On Thu, 10 Mar 2005 12:33:22 -0500, Domain Hostmaster
<hostmaster at 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 at 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 at bestpractical.com for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
>