CiviCRM Community Forums (archive)

Hi there,

Looking at the civicrm/contact/search page, the first box is called 'Name or Email'.

But the query searches based on sort_name.

Two solutions.  Include an " OR email LIKE '%searchterm%' " in the query or rename the label to more accuratley reflect what is being searched, i.e. Name (or email where name not present).

Looking at the WHERE  (  (  (  ( contact_a.sort_name LIKE '%searchterm%' ) )  )  )  AND (contact_a.is_deleted = 0)   ORDER BY contact_a.sort_name asc  LIMIT 0, 50

But the current interface is confusing and leads people to assume that a contact isn't present when they actually are, which then leads them to enter all the contact details, and get a warning saying that the contact is already there, which is a big usability frustration - what do you think?

Thanks for feedback - good point - will file issue with fix if i get time.