Need to search contacts by email address

[jchapman1]

Hi everyone,

I just upgraded to 5.1.0 from an older version. I notice that you can no longer search for a contact by email address. I went into the 'Studio' to see if I could add it to the advanced search. The email address is not one of the 'hidden' fields that you can activate for advanced search (or basic search). This is something that we really need. Does anyone have any suggestions?

I've searched the forums and could not find this issue. I apologize in advance if I missed it.

Thanks in advance for your assitance.

Jim Chapman

[jcb23]

Hi everyone,

I just upgraded to 5.1.0 from an older version. I notice that you can no longer search for a contact by email address. I went into the 'Studio' to see if I could add it to the advanced search. The email address is not one of the 'hidden' fields that you can activate for advanced search (or basic search). This is something that we really need. Does anyone have any suggestions?

I've searched the forums and could not find this issue. I apologize in advance if I missed it.

Thanks in advance for your assitance.

Jim Chapman

I also need to be able to search contacts by email address and haven't (to this point) been able to figure out how.

[jcb23]

I also need to be able to search contacts by email address and haven't (to this point) been able to figure out how.

Nevermind - I figured it out. "Any Email" searches the email_address field. I didn't think this was the case because the search wasn't working in my version of sugar. Because it wasn't pulling records when I typed their email in I assumed it was searching the wrong field, but found as I did some research that it was just that the search wasn't working.

The search wasn't working because of an error in the Enhanced Search plugin I had installed. If interested the code to correct this can be found in this thread: http://www.sugarcrm.com/forums/showt...+email+contact message #28.

Also just fyi the "any email" field is only included in the advanced search by default, but you can add it into the basic search as well by simply adding the following code into the basic search portion of the contact searchdefs.php file (/custom/modules/Contacts/metadata/searchdefs.php).

'email' =>
array (
'name' => 'email',
'label' => 'LBL_ANY_EMAIL',
'type' => 'name',
'default' => true,
),

And if your curious you can see how the any email field is able to search the email addresses by exploring the SearchFields.php file (/modules/Contacts/metadata/SearchFields.php). Thats how I figured out what was going on.

Hope this is helpful.

jcb23

[gregbazar]

Bang on!

Thanks. I have been looking for a way to add e-mail to my Basic and Advanced search tabs under contacts.

Can someone explain why it only searches the email address before the "@" sign?

For instance if I want to find all contacts that have a @motorola.com address, and I enter that in my new Contacts->Basic Search->Any Email field, I get zero responses.

If I query the DB directly I have over 50 contacts that match that description.

If however, I query the front half of the email - bob for instance if the address is bob@motorola.com, it works like a champ.

I appreciate the help.

[sugarcane]

Hi Greg,

Can someone explain why it only searches the email address before the "@" sign?

This is the way that the search works by default for any field. It will always search for records whose field begins with whatever you have typed into the search. To expand your search to include records whose fields contain what you entered, use the % sign. By entering %@motorola.com into the search, the records returned will give you anything that starts with @motorola.com or anything that contains @motorola.com.

[kenshiro]

The search wasn't working because of an error in the Enhanced Search plugin I had installed. If interested the code to correct this can be found in this thread: http://www.sugarcrm.com/forums/showt...+email+contact message #28.

jcb23

That bug has been fixed in Enhanced Search 3.0