Advanced search fails to properly search for contribution source
Try searching for a contribution source from the Advanced search - bet you don't get any results.
- Create a contact; add a contribution with a source
- Do an advanced search, specifying a contribution with a source
- no results - expected to find your contact.
Reason: the SQL generation generates SQL like this:
civicrm_contribution.source IN ("%findme%")
i.e. it's added
% wildcards as if for a
LIKE operator, but then it's used
It should generate SQL like this:
civicrm_contribution.source LIKE ("%findme%") and return the result.
- CiviCRM: Master and 5.20.0