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

Missing filter handler for Multi-Select State/Province

    Details

      Description

      Unlike Multi-Select Country field there is no filter handler for Multi-Select State/Province field result of which, it doesn't properly filter multi-select State Province field. Steps to produce the issue:
      1) Create a new custom field of 'State/Province' data type with 'Multi-Select State/Province' field type under existing or new custom set used for Contacts.
      2) Choose two contacts and set Albama state for Contact 1 and Albama,Alaska etc. for Contact 2.
      3) Create a Drupal View for Civicrm Contacts and add Contact name and its corrosponding Custom state fields.
      4) Choose expose filter for Custom state field and configure to 'allow user to choose multiple values'.
      5) Multi-select Albama and Alaska along w/o other states, it will only show Contact 1

      As expected behaivour for Step 5 will be to show both Contact 1 and Contact 2 that 'contains any words' case or only Contact 2 which 'contains all words' but since both this two operator is lacking in the filter we consider the first case by default still it didn't show the expected result because it is currently using IN operator by default in views query not LIKE as for Multi-Select Country. (Please check the sceenshot)

      Proposed Solution: Write new filter handler for Multi-Select State/Province with needed changes like Multi-Select Country field.

        Attachments

          Activity

            People

            • Assignee:
              ravish.nair Ravish Nair
              Reporter:
              webaccess Web Access
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: