Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Critical
-
Resolution: Duplicate
-
Affects Version/s: 4.5.1
-
Fix Version/s: None
-
Component/s: CiviCRM Search
-
Labels:None
-
Documentation Required?:None
Description
Name search at civicrm/contact/search and via API at use master address splits the given string at blanks and joins them for query with OR.
former query (proposed):
"Office for Development" => WHERE name LIKE "%Office for Development%"
4.5.1 query (proposed):
"Office for Development" => WHERE name LIKE "%Office%" OR name LIKE "%for%" OR name LIKE "%Development%"
Joined via OR the result get's worse every time I'm trying to get more precise.
Work around from SYSTOPIA Organisationsberatung:
Replace blanks with underscore in the input.