CiviCRM Community Forums (archive)

Hi,

In Advanced Search, an entry in the "complete or partial name" results in "name or email LIKE" instead of just "name like"
eg on demo site, enter "aol" - results show list of contacts with aol email addresses, but aol is not in the name field
This shows two problems: the search is matching against email (as well as name), and the search is assumed to be partial (ie automatically adding the wildcards.)  Note the help text showing partial matches need '%'

When searching with relationships, the target is treated as a partial match.  For example, on the demo system make 'Paula Adams' an employee of Cisco, then use Advanced Search setting the relationship to 'employee of' and the target as 'sco'.  The search wrongly shows Paula Adams.

We have a case where the full name of an org is a substring of another (although unrelated), and this behaviour makes it impossible to find only employees of the substring org.

The first one looks to me like a bug.  I'm not sure what the intended behaviour is for the relationship search, but for consistency it seems all the fields should be exact matches unless % is included.