Page MenuHomePhabricator

Search for email only works if primary email address
Closed, DeclinedPublic

Description

When using the Civi search bar at the top and searching by email address, it will only yield results if the email is selected as primary. Could this be changed to any email address listed under a contact to make merging easier?

Event Timeline

That's a change that has been attempted & reverted in CiviCRM before - so it's probably not going to be something we want to squeeze out during BE - it might be possible to search within the results found on the merge screen if the person is in one of your existing groups?

DStrine triaged this task as Medium priority.Dec 1 2016, 8:50 PM
DStrine moved this task from Triage to Sprint +1 on the Fundraising-Backlog board.

Is this going to be fixed in 4.7.19 along with the phone number search?

@Ejegg yes that is handled by the patch that's in the upgrade.

That feature is deployed but it needs to be turned on and ... I don't trust it. We need to test that it doesn't cause any weird or runaway queries. There has been some follow on bugs from it around tokens & sched reminders upstream

@Eileenmcnaughton and @mepps thanks for following up on this. It would be great if we could test this before Big English to help with merging.

@Eileenmcnaughton did we ever look into this? Is this feature more stable with the new upgrade?

So, there is an underlying problem that it is not compatible with mysql full group by mode which causes me to deeply mistrust it. The issue is that it returns many rows (e.g one per address & then does a group by to get it down to 1). It might 'compensate' but the fact it fails full group by is a bit yuck

2016 issue & much has changed - esp SearchKit option