Displaying different module's field in ListView

[robind2]

Hello,

Currently I have two modules, Leads and Clients, and on the Leads module, there is a field called 'Lead Status'. Each lead record can be related to a client record of course. We want to be able to show this 'Lead Status' field on the Clients' ListView page. Anyone have any hints as to how to accomplish this?

Thanks,
D

[davidboris]

Hello,

Create a file custom/Extension/modules/Contacts/Ext/Vardefs/lead_status.php

Add following lines of code, change <YOUR_RNAME> to whatever field of leads you want to display

 $dictionary['Contact']['fields']['lead_stat'] =
array (
        'name' => 'lead_stat',
        'rname' => '<YOUR_RNAME>',
        'id_name' => 'id',
        'vname' => 'LBL_LEAD_STATUS',
        'type' => 'relate',
        'link' => 'leads',
        'table' => 'leads',
        'isnull' => 'true',
        'module' => 'Leads',
        'dbType' => 'varchar',
        'source' => 'non-db',
); 
  

Add the following code in custom/modules/Contacts/metadata/listviewdefs.php

 'LEAD_STAT' => 
  array (
    'default' => true,
    'label' => 'LBL_LEAD_STATUS',
    'width' => '10%',
  ),