Autocomplete-select custom field is not searchable
- Create an 'Autocomplete Select' custom field for any component, say Contribution here
- Update/add two or more records with these custom field options
- Go to the desired search form, here 'Find Contribution'
- Select two or more option and submit the criteria
Doesn't return any result. Even the Qill message indicates that no values are selected Screencast:
Internally the whereClause construct is wrong which is like
civicrm_value_donor_information_3.test_12 = '1[:comma:]2[:comma:]3'
civicrm_value_donor_information_3.test_12 IN (1,2,3)