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

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.

-ChrisAm 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

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.

-ChrisAm 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

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.

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.

 //ClaesOn 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

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. :slight_smile:

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.

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.