[rt-users] Query builder and multi-select custom fields
Alex Young
alexyoung at scoutsolutions.co.uk
Tue Jan 27 04:49:34 EST 2009
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
More information about the rt-users
mailing list