Mailing List Archive: Request Tracker: Users

Wildcard in queue search changed from 3.8.8 to 4.0.5?

Index | Next | Previous | View Threaded

claes at gastabud

May 31, 2012, 5:09 AM

Post #1 of 6 (498 views)
Permalink

Wildcard in queue search changed from 3.8.8 to 4.0.5?

Hi!

In 3.8.8 I used a advanced search like this:

( Status = 'open' OR Status = 'new' OR Status = 'stalled' ) AND
CF.{Schakt} = 'Bestallt' AND Queue NOT LIKE 'Projekt_%'

This works only partly in 4.0.5. It works when i use the query on the
"Dashboard" but when a user click on the headline to "focus" on that
query it returns blank, zero tickets.

I guess it's because the '%' is handled differently, does anyone have a
workaround for this?

//Claes

cloos at netcologne

May 31, 2012, 6:27 AM

Post #2 of 6 (462 views)
Permalink

Re: Wildcard in queue search changed from 3.8.8 to 4.0.5? [In reply to]

cloos at netcologne

May 31, 2012, 6:27 AM

Post #3 of 6 (462 views)
Permalink

Re: Wildcard in queue search changed from 3.8.8 to 4.0.5? [In reply to]

Queue and the LIKE operator was never supported in any RT version!
But I think this should be on the wish-list for 4.2.

-Chris

Am 31.05.2012 14:09, schrieb Claes Jansson:
> Hi!
>
> In 3.8.8 I used a advanced search like this:
>
> ( Status = 'open' OR Status = 'new' OR Status = 'stalled' ) AND
> CF.{Schakt} = 'Bestallt' AND Queue NOT LIKE 'Projekt_%'
>
> This works only partly in 4.0.5. It works when i use the query on the
> "Dashboard" but when a user click on the headline to "focus" on that
> query it returns blank, zero tickets.
>
> I guess it's because the '%' is handled differently, does anyone have a
> workaround for this?
>
> //Claes
>
>
>

Christian Loos
Network Documentation & Fibre Management
_________________________________________________________________________
NETCOLOGNE Gesellschaft für Telekommunikation mbH
Am Coloneum 9 | 50829 Köln
Tel: 0221 2222-276 | Fax: 0221 2222-7276 | Mobil: 0177 8888276

www.netcologne.de

Geschäftsführer:
Dr. Hans Konle (Sprecher)
Dipl.-Ing. Karl-Heinz Zankel
Vorsitzender des Aufsichtsrates:
Dr. Andreas Cerbe
HRB 25580, AG Köln

Diese Nachricht (inklusive aller Anhänge) ist vertraulich. Sollten Sie diese Nachricht versehentlich erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon unverzüglich zu informieren und die Nachricht zu löschen. Die E-Mail darf in diesem Fall weder vervielfältigt noch in anderer Weise verwendet werden.

claes at gastabud

May 31, 2012, 6:53 AM

Post #4 of 6 (459 views)
Permalink

Re: Wildcard in queue search changed from 3.8.8 to 4.0.5? [In reply to]

I was just a bit surprised that it works in one view and not in the other.

I can "refrase" the query to solve the problem, but it will be less
dynamic as we add Queues with the prefix "Project_" over time...

Hoping for a change in the future, but on the other hand "LIKE" queries
can be a big performance hit, so i understand why it's not enabled.

//Claes

On 2012-05-31 15:27, Christian Loos wrote:
> Queue and the LIKE operator was never supported in any RT version!
> But I think this should be on the wish-list for 4.2.
>
> -Chris
>
> Am 31.05.2012 14:09, schrieb Claes Jansson:
>> Hi!
>>
>> In 3.8.8 I used a advanced search like this:
>>
>> ( Status = 'open' OR Status = 'new' OR Status = 'stalled' ) AND
>> CF.{Schakt} = 'Bestallt' AND Queue NOT LIKE 'Projekt_%'
>>
>> This works only partly in 4.0.5. It works when i use the query on the
>> "Dashboard" but when a user click on the headline to "focus" on that
>> query it returns blank, zero tickets.
>>
>> I guess it's because the '%' is handled differently, does anyone have a
>> workaround for this?
>>
>> //Claes
>>
>>
>>
>
>
>

tjrc at sanger

May 31, 2012, 7:08 AM

Post #5 of 6 (457 views)
Permalink

Re: Wildcard in queue search changed from 3.8.8 to 4.0.5? [In reply to]

On 31 May 2012, at 14:53, Claes Jansson wrote:

> I was just a bit surprised that it works in one view and not in the other.
>
> I can "refrase" the query to solve the problem, but it will be less dynamic as we add Queues with the prefix "Project_" over time...
>
> Hoping for a change in the future, but on the other hand "LIKE" queries can be a big performance hit, so i understand why it's not enabled.

Not likely to ever be a huge performance hit on normal RT installations. The queue table is always going to pretty small. If anyone has an RT installation with tens of thousands of queues, they're probably either doing it wrong or are not really using the right tool for the job. :-)

Regards,

Tim

--
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.

ruz at bestpractical

Jun 25, 2012, 6:22 AM

Post #6 of 6 (360 views)
Permalink

Re: Wildcard in queue search changed from 3.8.8 to 4.0.5? [In reply to]

On Thu, May 31, 2012 at 4:09 PM, Claes Jansson <claes [at] gastabud> wrote:
> Hi!
>
> In 3.8.8 I used a advanced search like this:
>
> ( Status = 'open' OR Status = 'new' OR Status = 'stalled' ) AND CF.{Schakt}
> = 'Bestallt' AND Queue NOT LIKE 'Projekt_%'
>
> This works only partly in 4.0.5. It works when i use the query on the
> "Dashboard" but when a user click on the headline to "focus" on that query
> it returns blank, zero tickets.
>
> I guess it's because the '%' is handled differently, does anyone have a
> workaround for this?
>

Report a bug report.

> //Claes
>
>

--
Best regards, Ruslan.

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads