Autocomplete-select custom field is not searchable
Reproduction steps
- 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
Current behavior
Doesn't return any result. Even the Qill message indicates that no values are selected Screencast:
Expected behavior
It should return the result where the options are linked.
Technical comment
Internally the whereClause construct is wrong which is like
civicrm_value_donor_information_3.test_12 = '1[:comma:]2[:comma:]3'
instead of
civicrm_value_donor_information_3.test_12 IN (1,2,3)
Comments
ping @JoeMurray @eileen @seamuslee @JonGold @mattwire @MikeyMJCO @colemanw