Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Duplicate
-
Affects Version/s: 3.2.4
-
Fix Version/s: 3.4.alpha
-
Component/s: Drupal Integration Modules
-
Labels:None
Description
See http://forum.civicrm.org/index.php/topic,16404.0.html
In Views 6.x-2.11 / CiviCRM 3.2.4, filtering by checkbox or field multi-select fields only retrieves contacts that have a single value selected for the relevant field: contacts with multiple values specified are never retrieved, unless the filter is left blank.
An incorrect WHERE clause is generated, e.g. "civicrm_value_test_ocp_6.category_11 in ('2')" - it apparently doesn't know how multi-value fields are stored, with CHAR(1) as a value separator. Further details in the forum post.
Dave J