HOWTO - Hack Sugar to support related module info in subpanel (one-many)

[kenneth.thorman]

Updating main post with new infomation due to release 5.0.0a

[vvanio]

Hello...

Assuming that your vardefs is defined this way:

...
'fields'=>array (
'assigned_case_name' =>
array (
'required' => '1',
'source' => 'non-db',
'name' => 'assigned_case_name',
'vname' => 'LBL_ASSIGNED_CASE_NAME',
'type' => 'relate',
'massupdate' => 0,
'comments' => '',
'help' => '',
'duplicate_merge' => 'disabled',
'duplicate_merge_dom_value' => 0,
'audited' => 1,
'reportable' => 0,
'len' => '255',
'id_name' => 'assigned_case_id',
'ext2' => 'Cases',
'module' => 'Cases',
'studio' => 'visible',
),
'assigned_case_id' =>
array (
'required' => false,
'name' => 'assigned_case_id',
'vname' => '',
'type' => 'id',
'massupdate' => 0,
'comments' => '',
'help' => '',
'duplicate_merge' => 'disabled',
'duplicate_merge_dom_value' => 0,
'audited' => 0,
'reportable' => 0,
'len' => 36,
),
),
...

modify module/metadata/subpanels/default.php, like the example below:

...
'list_fields' =>
array (
'assigned_tema_name' =>
array (
'name' => 'assigned_case_name',
'vname' => 'LBL_ASSIGNED_CASE_NAME',
'width' => '15%',
'module' => 'Cases',
'target_record_key' => 'assigned_case_id',
'target_module' => 'Cases',
'widget_class' => 'SubPanelDetailViewLink',
'sortable'=>false,
),
'assigned_case_id' =>
array (
'name' => 'assigned_case_id',
'usage'=>'query_only',
),
...
),
...

That's all folks...

[Kalendrinn]

Thank you for that post, I think that's exactly what I was talking about with modifying the subpanel instead of the core code. You should be able to make it upgrade-safe by moving the modifications to the /custom directory (under the appropriate subdirectories of course). I just haven't had time to work it out.

[kenneth.thorman]

Thank you very much for the input.

I have attempted using the supplied code, I have not yet been able to achieve the results I would like but I will keep on trying. I will post an update when I get there.

Regards
Ken

[kenneth.thorman]

I have been unable to get the other suggested ways to work so I have been using the hack fix that I outlines in this thread for different modules. If anyone need an installable modules that does this for you from SugarCrm 5.0.0, 5.0.0a, 5.0.0b, 5.0.0c and 5.0.0e they can be found here (https://sourceforge.net/project/show...roup_id=210096). There are also some other modules that might be of interest.

[kenneth.thorman]

This can now be downloaded as an installable SugarCrm module from sourceforge. Please note that this module contains 5 different hacks to the Sugar core. So please read the release notes first.

https://sourceforge.net/project/show...kage_id=261293