database value & display value in templates, detail view and list view

[johnnyo]

I've made several multiple select fields.
What I've noticed is that in list view, detail view and emails using email templates the database key value is being shown.
Is there a way to get the display value to show instead???
Thanks, JohnnyO

[kbrill]

Can you post your custom/modules/MODULE_NAME/metadata/listviewdefs.php file?

[johnnyo]

Here it is. Thanks

<?php
// created: 2007-08-31 17:40:59
$listViewDefs['Contacts'] = array (
'NAME' =>
array (
'width' => '20%',
'label' => 'LBL_LIST_NAME',
'link' => true,
'contextMenu' =>
array (
'objectType' => 'sugarPerson',
'metaData' =>
array (
'contact_id' => '{$ID}',
'module' => 'Contacts',
'return_action' => 'ListView',
'contact_name' => '{$FULL_NAME}',
'parent_id' => '{$ACCOUNT_ID}',
'parent_name' => '{$ACCOUNT_NAME}',
'return_module' => 'Contacts',
'parent_type' => 'Account',
'notes_parent_type' => 'Account',
),
),
'orderBy' => 'last_name',
'default' => true,
'related_fields' =>
array (
0 => 'first_name',
1 => 'last_name',
2 => 'salutation',
3 => 'account_name',
4 => 'account_id',
),
),
'TITLE_DROPDOWN_C' =>
array (
'width' => 10,
'label' => 'title_dropdown_c',
'default' => true,
'sortable' => false,
),
'TITLE' =>
array (
'width' => '15%',
'label' => 'LBL_LIST_TITLE',
'default' => true,
),
'ACCOUNT_NAME' =>
array (
'width' => '34%',
'label' => 'LBL_LIST_ACCOUNT_NAME',
'module' => 'Accounts',
'id' => 'ACCOUNT_ID',
'link' => true,
'contextMenu' =>
array (
'objectType' => 'sugarAccount',
'metaData' =>
array (
'return_module' => 'Contacts',
'return_action' => 'ListView',
'module' => 'Accounts',
'parent_id' => '{$ACCOUNT_ID}',
'parent_name' => '{$ACCOUNT_NAME}',
'account_id' => '{$ACCOUNT_ID}',
'account_name' => '{$ACCOUNT_NAME}',
),
),
'default' => true,
'sortable' => true,
'ACLTag' => 'ACCOUNT',
'related_fields' =>
array (
0 => 'account_id',
),
),
'CREATED_BY_NAME' =>
array (
'width' => '10',
'label' => 'LBL_CREATED',
'default' => true,
),
);
?>