Custom field on a subpanel

[arasdeveloper2]

Hi,
I have insert a custom field on "Calls" form. This field is memorized in calls_cstm table. I like insert this field as column of the Acitivities subpanel in the module Accounts, but I don't know where modify the query!!!! :-(
Help me, please!

Thanks a lot!

[andopes]

Have a look on this thread.

Cheers

[arasdeveloper2]

Thank a lot for the help, but i've changed the where clausule in Calls/subpanels/ForActivities.php, but of course it doesn't work, besause the INNER JOIN calls_cstm is missing.
What should I do, to make it work?

SugarCRM CE

Thanks.

[A.Duviol]

i have the same problem with a custom field in tasks (the dropdown action_c) for opportunities module, and by the way i deleted all other activities which are useless for us.

After two searching days i hope someone could help me to sort this out.

The custom field title appears in the lists (in Activities and Opportunities) but none of the values want to show

here is what i have done :

custom/modules/Opportunities/Ext/Layoutdefs/layoutdefs.ext.php

$layout_defs["Opportunities"]["subpanel_setup"]["activities"] = array (
    'order' => 20,
    'sort_order' => 'desc',
    'sort_by' => 'date_start',
    'title_key' => 'LBL_ACTIVITIES_SUBPANEL_TITLE',
    'type' => 'collection',
    'subpanel_name' => 'activities',   //this values is not associated with a physical file.
    'module'=>'Activities',
    
    'top_buttons' => array(
        array('widget_class' => 'SubPanelTopCreateTaskButton'),
/*      array('widget_class' => 'SubPanelTopScheduleMeetingButton'),
        array('widget_class' => 'SubPanelTopScheduleCallButton'),
        array('widget_class' => 'SubPanelTopComposeEmailButton'),
*/
    ),

    'collection_list' => array(    
        'tasks' => array(
            'module' => 'Tasks',
            'subpanel_name' => 'ForOpportunities',
            'get_subpanel_data' => 'tasks',
        ),
    )
);

custom/modules/Tasks/metadata/subpanels/ForOpportunities.php

$subpanel_layout = array (
'where' => "",    
'list_fields' => array( 
		'action_c'=>array(
			 'vname' => 'LBL_LIST_ACTIONS',
			 'widget_class' => 'SubPanelDetailViewLink',
			 'width' => '30%',
		),
		'close_button'=>array(
			'widget_class' => 'SubPanelCloseButton',
			'vname' => 'LBL_LIST_CLOSE',
			'width' => '6%',
			'sortable'=>false,
		),
		'name'=>array(
			 'vname' => 'LBL_LIST_SUBJECT',
			 'widget_class' => 'SubPanelDetailViewLink',
			 'width' => '30%',
		),
		'status'=>array(
			 'widget_class' => 'SubPanelActivitiesStatusField',
			 'vname' => 'LBL_LIST_STATUS',
			 'width' => '15%',
		),
		'contact_name'=>array(
			 'widget_class' => 'SubPanelDetailViewLink',
			 'target_record_key' => 'contact_id',
			 'target_module' => 'Contacts',
			 'module' => 'Contacts',
			 'vname' => 'LBL_LIST_CONTACT',
			 'width' => '11%',
		),
		'date_due'=>array(
			 'vname' => 'LBL_LIST_DUE_DATE',
			 'width' => '10%',
			 'alias' => 'date_start'
		),
		'assigned_user_name' => array (
			'name' => 'assigned_user_name',
			'vname' => 'LBL_LIST_ASSIGNED_TO_NAME',
		),
		'time_due'=>array(
			'usage'=>'query_only',
			 'alias' => 'time_start'	
		),
)
);

custom/modules/Tasks/metadata/listviewdefs.php

$listViewDefs = array (
  'Tasks' => 
  array (
    'ACTION_C' => 
    array (
      'width' => '10',
      'label' => 'LBL_ACTION',
      'sortable' => false,
      'default' => true,
      'required' => '0',
      'source' => 'custom_fields',
      'name' => 'action_c',
      'id' => 'Tasksaction_c',
      'custom_module' => 'Tasks',
    ),
    'PARENT_NAME' => 
    array (
      'width' => '20',
      'label' => 'LBL_LIST_RELATED_TO',
      'dynamic_module' => 'PARENT_TYPE',
      'id' => 'PARENT_ID',
      'link' => true,
      'default' => true,
      'sortable' => false,
      'ACLTag' => 'PARENT',
      'related_fields' => 
      array (
        0 => 'parent_id',
        1 => 'parent_type',
      ),
    ),
    'DATE_DUE' => 
    array (
      'width' => '15',
      'label' => 'LBL_LIST_DUE_DATE',
      'link' => false,
      'default' => true,
    ),
    'STATUS' => 
    array (
      'width' => '10',
      'label' => 'LBL_LIST_STATUS',
      'link' => false,
      'default' => true,
    ),
    'ASSIGNED_USER_NAME' => 
    array (
      'width' => '2',
      'label' => 'LBL_LIST_ASSIGNED_TO_NAME',
      'default' => true,
    ),
  ),
);

module/Activities/metadata/subpaneldefs.php

$layout_defs['Activities'] = array( // the key to the layout_defs must be the name of the module dir
	'default_subpanel_define' => array(
		'subpanel_title' => 'LBL_DEFAULT_SUBPANEL_TITLE',
		'top_buttons' => array(
			array('widget_class' => 'SubPanelTopCreateTaskButton'),
/*			array('widget_class' => 'SubPanelTopScheduleMeetingButton'),
			array('widget_class' => 'SubPanelTopScheduleCallButton'),
			array('widget_class' => 'SubPanelTopComposeEmailButton'),
*/
		),
		'list_fields' => array(
			'Tasks' => array(
				'columns' => array(
					array(
			 		 	'name' => 'nothing',
						'widget_class' => 'SubPanelCloseButton',
			 		 	'module' => 'Tasks',
			 		 	'vname' => 'LBL_LIST_CLOSE',
			 		 	'width' => '6%',
					),
					array(
			 		 	'name' => 'action_c',
			 		 	'vname' => 'LBL_ACTIONS',
						'widget_class' => 'SubPanelDetailViewLink',
			 		 	'width' => '30%',
					),
					array(
			 		 	'name' => 'status',
						'widget_class' => 'SubPanelActivitiesStatusField',
			 		 	'vname' => 'LBL_LIST_STATUS',
			 		 	'width' => '15%',
					),
					array(
			 		 	'name' => 'parent_name',
			 		 	'module' => 'Tasks',
			 		 	'vname' => 'LBL_LIST_RELATED_TO',
			 		 	'width' => '22%',
					),
					array(
			 		 	'name' => 'date_start',
			 		 	//'db_alias_to' => 'the_date',
			 		 	'vname' => 'LBL_LIST_DUE_DATE',
			 		 	'width' => '10%',
					),

				),
				'where' => "(tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')",
				'order_by' => 'tasks.date_start',
			),
		),
	),
);

I may have changed some other files (i really tried everything i found on this forum and over the net)

Thanks.