Custom sort not working help please

[kinshibuya]

Hi!
i need some help.
I tryed to customize the subpanel listview of contacts to sort the field, account_name.
I added the sortable=>true and it works, but it's not sorting rigth. I guess it's sorting by id. what to do? any ideas?

[mikesolomon]

Hi!
i need some help.
I tryed to customize the subpanel listview of contacts to sort the field, account_name.
I added the sortable=>true and it works, but it's not sorting rigth. I guess it's sorting by id. what to do? any ideas?

In my listviewdefs I have the following

'ACCOUNT_NAME' =>
array (
'width' => '34%',
'label' => 'LBL_LIST_ACCOUNT_NAME',
'module' => 'Accounts',
'id' => 'ACCOUNT_ID',
'link' => true,
'contextMenu' =>
array (
'objectType' => 'sugarAccount',
'metaData' =>
array (
'return_module' => 'Contacts',
'return_action' => 'ListView',
'module' => 'Accounts',
'parent_id' => '{$ACCOUNT_ID}',
'parent_name' => '{$ACCOUNT_NAME}',
'account_id' => '{$ACCOUNT_ID}',
'account_name' => '{$ACCOUNT_NAME}',
),
),
'default' => true,
'sortable' => true,
'ACLTag' => 'ACCOUNT',
'related_fields' =>
array (
0 => 'account_id',
),
),

It works

[kinshibuya]

I guess mine is Exacly the same

  'ACCOUNT_NAME' => array(
                'width' => '34%',
                'label' => 'LBL_LIST_ACCOUNT_NAME',
                'module' => 'Accounts',
                'id' => 'ACCOUNT_ID',
                'link' => true,
        'contextMenu' => array('objectType' => 'sugarAccount',
                               'metaData' => array('return_module' => 'Contacts',
                                                   'return_action' => 'ListView',
                                                   'module' => 'Accounts',
                                                   'return_action' => 'ListView',
                                                   'parent_id' => '{$ACCOUNT_ID}',
                                                   'parent_name' => '{$ACCOUNT_NAME}',
                                                   'account_id' => '{$ACCOUNT_ID}',
                                                   'account_name' => '{$ACCOUNT_NAME}'),
                              ),
        'default' => true,
        'sortable'=> true,
        'ACLTag' => 'ACCOUNT',
        'related_fields' => array('account_id')),

But i'm tryuing to sort the columns on the contacts subpanel, how is your /sugarcrm/modules/Contacts/metadata/subpanels/default.php?
My is like this:

     'account_name'=>array(
                        'module' => 'Accounts',
                        'target_record_key' => 'account_id',
                        'target_module' => 'Accounts',
                        'widget_class' => 'SubPanelDetailViewLink',
                        'vname' => 'LBL_LIST_ACCOUNT_NAME',
                        'sortable'=>true,
                        'width' => '22%',
                ),

[mikesolomon]

Sorry I misunderstood

[mikesolomon]

In my cases subpanelI have this and it works

'account_name'=>array(
'vname' => 'LBL_LIST_ACCOUNT_NAME',
'widget_class' => 'SubPanelDetailViewLink',
'module' => 'Accounts',
'width' => '31%',
'target_record_key' => 'account_id',
'target_module' => 'Accounts',
),

[kinshibuya]

ok. I'm trying to sort the field: account_name on the contact's subpanel.
but it's sorting it wrong,

I attached the image to the post.

[mikesolomon]

What code do you have in the subpanel?

[kinshibuya]

'account_name'=>array(
'module' => 'Accounts',
'target_record_key' => 'account_id',
'target_module' => 'Accounts',
'widget_class' => 'SubPanelDetailViewLink',
'vname' => 'LBL_LIST_ACCOUNT_NAME',
'sortable'=>true,
'width' => '22%',
),

[mikesolomon]

strange - it works for me in cases

what happens if you remove the 'sortable'=>true,?

I don't have that but it sorts properly

[kinshibuya]

Nothing happens, it doesn't change anything