Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-7093

CiviCRM Drupal Views integration: filter by checkbox / multi-select custom field is broken

    Details

      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

        Attachments

          Activity

            People

            • Assignee:
              jalama Jim Taylor
              Reporter:
              davej Dave Jenkins
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: