Get email address in lead report

[devaraja]

Email is not a field in leads table. How to get email address of a lead to be displayed in lead report. I couldn't trace out the relations of the tables to display email id of the lead.

[crmsiva]

Hi

leads -> email_addr_bean_rel -> email_addresses

This is how email addresses are linked with leads or other modules in DB.

[devaraja]

Thanks.. I got it