[rt-users] Query builder and multi-select custom fields

[Ruslan Zakirov]

There is a patch on rt3.fsck.com that needs testing:
http://rt3.fsck.com/Ticket/Display.html?id=8541#txn-77170

I'm not sure it applies to the latest 3.8

On Tue, Jan 27, 2009 at 12:49 PM, Alex Young
<alexyoung at scoutsolutions.co.uk> wrote:
> Thanks, but that brings back hundreds of tickets, when we know the other
> query *should* bring back just the one ticket that has the CF set to
> those two values.
>
> Looking through the RT bug system, it looks like this is a known bug and
> is due to be fixed in 3.8.3.
>
>
> -----Original Message-----
> From: Kenneth Crocker [mailto:KFCrocker at lbl.gov]
> Sent: 26 January 2009 18:40
> To: Alex Young
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Query builder and multi-select custom fields
>
> Alex,
>
>
>        Try changing the "AND" to "OR" between your two "like"
> conditions. Hope
> this helps.
>
>
> Kenn
> LBNL
>
> On 1/26/2009 7:04 AM, Alex Young wrote:
>> I have a ticket in the Support queue that has both the 'External' and
>> 'Internal' client types in a custom multi-select field. When I run the
>
>> following search:
>>
>>
>>
>> Queue = 'Support' AND 'CF.{Client}' LIKE 'Internal' AND 'CF.{Client}'
>> LIKE 'Internal'
>>
>>
>>
>> I expected to get the ticket back, but instead I get 0 tickets. Is
> this
>> valid behaviour from RT's perspective? Should I be searching in some
>> other way to return the ticket when it has a CF set to two values?
>>
>>
>>
> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.