Reports that filter for primary email address only

Nigel,

This is a current feature request.  If you have access to your database and are comfortable with creating SQL queries, the primary email flag is stored in the email_addr_bean_rel table.  At this time, the reporting engine in Sugar does not look at that table and, as a result, is not able to see the primary email flag information.

Kind Regards,

Lori Arce

As per Lori's note this would require SQL queries. If you have this knowledge you can perform them either directly on the database if you have the access, or via Advanced Reports should you be on the Enterprise or Ultimate editions.

Thanks for this info. I am using Sugar Enterprise but dont have SQL knowledge so will speak to my developer.

Hi,

Same question here but different experience: 

• If you report on the contact module, you're getting only email addresses that are flagged as primary. 
• If you report on the email address module, you're getting primary and non primary addresses. Indeed, without the possibilty to see/filter primary/non primary. 

I'm working on Sugar Enterprise 9.x.

My hunch is that when you start from contacts, the reporting engine filters out non primary by default. 

It would be nice if that flag was accessible in reports.