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

[Kenneth Crocker]

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