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

option values with commas are unsearchable

    Details

    • Documentation Required?:
      None
    • Funding Source:
      Paid Issue Queue
    • Payment Status:
      Paid

      Description

      to reproduce:

      • create a custom data set and field for contacts using the multi-select field type. create at least one option where the value has a comma
      • edit a contact and select the comma-value for this field
      • create a profile and add this field. set it to be searchable.
      • view the profile in search mode and attempt to search on the comma value

      no results will be returned. additionally, if you try to search for that value via advanced search, no results will be returned. if you search with search builder, it does return results (likely because it uses a more straightforward sql statement).

        Attachments

          Activity

            People

            • Assignee:
              lcdweb Brian Shaughnessy
              Reporter:
              lcdweb Brian Shaughnessy
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 10 minutes
                2h 10m