HOWTO: Prospect list subpanel for Leads in SugarCEM 6.4 (and maybe 6.3)

[gunni]

As the old subpanel stopped working for me, there were some changes needed to show a target list subpanel in Sugar 6.4. My old implementation lead to an sql error as it did leave the leads table in the FROM clause, but had leads.id in the JOIN.
Now here are the two files to create to get it working in 6.4:

custom\Extension\modules\Leads\Ext\Vardefs\prospec tlists_leads_Leads.php

 <?php
$dictionary["Lead"]["fields"]["prospect_list_leads"] = array (
  'name' => 'prospect_list_leads',
  'type' => 'link',
  'relationship' => 'prospect_list_leads',
  'source' => 'non-db',
  'vname' => 'LBL_PROSPECTLISTS_LEADS_FROM_PROSPECTLISTS_TITLE',
);  

custom\Extension\modules\Leads\Ext\Layoutdefs\pros pectlists_leads_Leads.php

 <?php
$layout_defs["Leads"]["subpanel_setup"]['prospect_list_leads'] = array (
  'order' => 100,
  'module' => 'ProspectLists',
  'subpanel_name' => 'default',
  'sort_order' => 'asc',
  'sort_by' => 'id',
  'title_key' => 'LBL_PROSPECTLISTS_LEADS_FROM_PROSPECTLISTS_TITLE',
  'get_subpanel_data' => 'prospect_list_leads',
  'top_buttons' => 
  array (
    0 => 
    array (
      'widget_class' => 'SubPanelTopButtonQuickCreate',
    ),
    1 => 
    array (
      'widget_class' => 'SubPanelTopSelectButton',
      'mode' => 'MultiSelect',
    ),
  ),
);  

Quick repair and Rebuild and you are done.

[dooban]

Worked on 6.3.1

I am trying to do the same with Contacts module, but haven't succeeded. Anyone ?