Export email addresses from leads including non-primary

[ranthony]

I'm trying to use the export feature for Leads. It's now exporting only the primary email address, but I would like to have all associated email addresses available. How can I go about changing that?

I'm using Sugar 5.1.

Thank you,
Ryan

[ranthony]

Ok, so I made one solution work, I'd appreciate any others though.

I changed some code in modules\Leads\Lead.php in the create_export_query function. I removed the requirement that email_addr_bean_rel.primary_address=1 in the LEFT JOIN. So from this:

//$query .=  ' LEFT JOIN  email_addr_bean_rel on leads.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module=\'Leads\' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1 ';

to this:

$query .=  ' LEFT JOIN  email_addr_bean_rel on leads.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module=\'Leads\' and email_addr_bean_rel.deleted=0 ';

Ryan