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
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
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:
to this:Code://$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 ';
RyanCode:$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 ';
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks