Filter for "contains all" against a text select field only works with one value [#1023860]

I have a cck text field (select list) with the available values as:

live|Make Conference Live
featured_event|Featured Event
form_location|Location
form_hotel|Hotel

devel for this node shows:
http://drupal.org/files/Screenshot-1.png
as you can see all options are set for this node.

I then have a view that does a filter on this field, set to
http://drupal.org/files/Screenshot-2.png

Here is what the query looks like:
http://drupal.org/files/Screenshot-3.png

However, the corresponding nodes do not seem to show. If I remove one of the search terms then the nodes show correctly. So search for 'live featured_event' does NOT work and searching for either 'live' or 'featured_event' does work. i can't search for both.

I only found one other topic that seems to discuss similar issues: #523114: "contains all words" filter NOT WORKING - Outer brackets missing in the SQL query . It is old and I didn't want to reopen.

My server is running CentOS 5 with PHP 5.2 and MySQL 5.0.

Comment	File	Size	Author
#3	Screenshot-4.png	77.12 KB	nicholas.alipaz
	Screenshot-3.png	26.99 KB	nicholas.alipaz
	Screenshot-2.png	19.98 KB	nicholas.alipaz
	Screenshot-1.png	27.55 KB	nicholas.alipaz

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

nicholas.alipaz CreditAttribution: nicholas.alipaz commented 12 January 2011 at 04:02

The links above did not seem to work, please see the reference attachments below the post.

Comment #2

nicholas.alipaz CreditAttribution: nicholas.alipaz commented 12 January 2011 at 04:07

I have now tested this on my local machine with Ubuntu 10.04.1 and PHP 5.2/MySQL 5.1. Same results. The view is a block display.

Comment #3

nicholas.alipaz CreditAttribution: nicholas.alipaz commented 12 January 2011 at 04:18

File	Size
Screenshot-4.png	77.12 KB

hhmmm, looks like the issue here is that the values of multiple checkboxes get stored in multiple rows in the database (Screenshot 4). So the sql statement used to filter does not seem like it would work properly. I could be wrong, let me know your input.

Comment #4

nicholas.alipaz CreditAttribution: nicholas.alipaz commented 12 January 2011 at 04:37

to work around my issue I have had to resort to creating each checkbox individually as single on/off checkboxes and filtering like that. Luckily content insertion has not yet been performed for this site, so no need to update a mass of nodes.