[rt-users] Wildcard in queue search changed from 3.8.8 to 4.0.5?

[Claes Jansson]

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