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:[email protected]] Sent: 26 January 2009 18:40 To: Alex Young Cc: [email protected] 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: [email protected] > > > 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: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
