No email field for Account & Cases listview

[jason.bazalar]

Hello all,

I am working the the Accounts and Cases modules and would like to get the emails within each record to show on the listview of each one. I tried to stick with Studio to allow this, but I don't see the field for email so I can add it to the listview.

The Accounts dashlet let's me add in the email field in it's list view but is empty for records where I have entered an email address.

Additionally, how do I get these emails to come out in the "export" list?

Currently using: Sugar Community Edition Version 5.0.0d (Build 3235) [normal setup]

Any help would be appreciated.

Jason B.

[jason.bazalar]

I did the following to display the email in the custom email field I created and in the email field in the dashlet:

TO VIEW EMAILS IN ACCOUNTS:
1. {crm_install}/modules/Accounts/Account.php
In the get_list_view_data() function:
----
$temp_array['EMAIL1'] = $this->emailAddress->getPrimaryAddress($this);
----

2.Added a custom field called email, labeled LBL_EMAIL in studio under Accounts. Made this field viewable in listview. Saved and deployed.

3. {crm_install}/custom/modules/Accounts/metadata/listviewdefs.php
Added customCode line to the Email bracket.
----
'EMAIL_C' =>
array (
'width' => '10',
'label' => 'LBL_EMAIL',
'customCode' => '{$EMAIL1}',
'sortable' => true,
'default' => true,
),
----

But this doesn't allow the emails to be sorted correctly, it was just a quick way I found to get the data shown. Plus, the most important part is getting the emails as part of the export feature. Any recommendations?

[jason.bazalar]

Here's what I modified to get the emails to show up along with the other data when clicking the 'export' button the the Accounts ListView page.

1. {CRM_INSTALL}/modules/Accounts/Account.php
In the create_export_query() function:

function create_export_query(&$order_by, &$where)
{
...
$query = "SELECT

/* START ADDED */
accounts.*,email_addresses.email_address,
/* END ADDED */

users.user_name as assigned_user_name ";
...
$query .= " LEFT JOIN users
ON accounts.assigned_user_id=users.id ";

/* START ADDED */
$query .= ' LEFT JOIN email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module=\'Accounts\' and email_addr_bean_rel.primary_address=1 ';
$query .= ' LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id ' ;
/* END ADDED */

$where_auto = " accounts.deleted=0 ";
...
}