I have created one custom multi-select dropdown field in lead module which is getting value from a function.
I’m using suite-CRM version 7.7.6
My custom field code is:
custom/include/custom_utils.php
function getCompetitorsList()
{
$query = “SELECT id , name FROM accounts where account_type = ‘Competitor’ AND deleted=0”;
$result = $GLOBALS[‘db’]->query($query, false);
$list = array();
$list[’’]=’’;
while (($row = $GLOBALS[‘db’]->fetchByAssoc($result)) != null) {
$list[$row[‘name’]] = $row[‘name’];
}
return $list;
}
custom/Extension/modules/Leads/Ext/Vardefs/customField.php
$dictionary[“Lead”][“fields”][“competitor_users”] = array(
‘name’ => ‘competitor_users’,
‘type’ => ‘multienum’,
‘size’ => ‘20’,
‘function’ => ‘getCompetitorsList’,
‘vname’ => ‘LBL_COMPETITOR_USERS’,
);
This field is working well in editview and detail view and also stores value in database but when I am trying to use this field in list-view then it is not showing any value just showing comma(,)’ and also not showing the value in the subpanel view.