email address from relate field

[momigno]

Hi, is it possible to show and/or export in csv format, an email address related to account module from a relate field of a custom module? I have this custom module, with a relate field from the account module. What I can tryng to do is to show and export the email address from that account.
Any help?

thanks
momigno

PS. I am using Sugar5.2a CE

[Superman]

You need to rewrite create_export_query() in your module bean file.
Especially you need to construct resulting query so that it get email address from related account.
So, say, your module is related with Accounts by field account_id.

then this SQL will return email address from related account:

 SELECT ea.email_address FROM your_module_table ymt LEFT JOIN email_addr_bean_rel eabr ON ymt.account_id = eabr.bean_id AND eabr.bean_module='Accounts' LEFT JOIN email_addresses ea ON eabr.email_address_id = ea.id WHERE eabr.deleted = '0' AND eabr.primary_address='1'