[rt-users] searching "select multiple" Custom field

[Kenneth Crocker]

Roy,


	You might get better results if your last "AND" (CF.FOO like xxxx AND 
CF.FOO like xxx) was an "OR". Your query will only pull those tickets if 
that CF has BOTH values. Since you stated the values could be anywhere 
from AAA to FFF, then perhaps you would want ANY ticket that has either 
of the values you are looking for. Just a thought.


Kenn
LBNL

On 1/29/2008 5:29 AM, Roy Sowa wrote:
> 
> I have a queue specific custom field that may contain multiple values. (AAA....FFF)
> If I have a ticket which has set multiple values for that custom field 
> then I do not find the ticket when I specify a search criteria that 
> contains multiple values for that custom field.
>  Eg: 
> The custom field  ( FOO ) may contain the values "AAA" and "CCC".
>  My ticket has set both values. The search criteria is: 
> 
>  Queue = 'TEST' AND  (  Status = 'open' OR Status = 'new' OR Status = 'stalled'  ) AND 'CF.{FOO}' LIKE 'AAA' AND 'CF.{FOO}' LIKE CCC'
> 
> If I search for one of the criteria then those tickets are found. 
> The  ticket is not found if I look for "AAA" and "CCC".  ( tickets with this match do exist in the database ) 
> 
> I am running 3.6.5.
> Am I missing something, how do I search for those records that only contain both 'AAA' and 'CCC'
> 
> Roy
> 
> 
> 
> _______________________________________________
> 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
>