CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Advanced Search doesn't find non-Primary email addresses
Pages: [1]

Author Topic: Advanced Search doesn't find non-Primary email addresses  (Read 727 times)

websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
Advanced Search doesn't find non-Primary email addresses
October 21, 2010, 01:31:11 pm
Recreated on the demo site. I created a contact:
http://drupal.demo.civicrm.org/civicrm/contact/view?reset=1&cid=118

Using Advanced Search for their Billing address, newperson2@example.com, gets no results.

Intentional? How do I find non-primary emails?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Advanced Search doesn't find non-Primary email addresses
October 21, 2010, 02:27:29 pm

you might want to check and test if search builder allows u to find non-primary emails

if not, you might want to consider contributing code to help make this happen. note that in general for performance reasons you dont want to search all emails, so potentially u'll need a checkbox to indicate whether to include all emails or not. You can potentially also do this with a custom search

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Advanced Search doesn't find non-Primary email addresses
December 05, 2012, 08:01:27 am
I know this thread is rather old, but I've just come across the same issue in version 4.2.6: Basic and Advanced Search only appear to search primary email addresses. There is no mention of this in the documentation, and I think it is fair to assume from the implications given in the UI that a search for an email address will search the entire database for all email addresses, and not just those tagged as 'primary'. If there are performance issues arising from employing a broader search, then all that is needed is clarification of the guidance in the UI, to something like "Name or Primary Email" instead of "Name or Email" in the basic contact search.
Graham Mitchell
http://mc3.coop

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Advanced Search doesn't find non-Primary email addresses
December 05, 2012, 11:50:53 pm
Hey Graham,

Submitting a UI patch and editing the book to reflect this is a good idea and not to hard if you want to do that.

Not sure amount the reasons that we don't search all email addresses, but i suspect it is performance as you say and/or not overcomplicating that query which is complicated enough.

It is was performance, it could always be added as a search configuration option, but that would add more complexity to that query / more opps for bugs to creep in.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Advanced Search doesn't find non-Primary email addresses

This forum was archived on 2017-11-26.