Want to sort list view on date

[pravin.agham]

Hi All,

I want to sort the list view records on date by Descending order. How I can do this is Sugarcrm.
I want to do this in all modules


Thanks,
Pravin

[andopes]

You just need to edit the custom/modules/<Module>/metadata/listviewdefs.php and add the attribute

 'sortable'=> true, 
  

Inside date field definition.

Then go to Admin -> Repair -> Quick Repair and Rebuild

Cheers

[pravin.agham]

Hi,

I did the changes what you told in your post but there is nothing happen.

I did-

on custom/modules/Accounts/metadata/listviewdefs.php I chnaged-

 'DATE_MODIFIED' => 
  array (
  'width' => '10%',
  'label' => 'LBL_DATE_MODIFIED',
  'default' => true,
  'sortable'=> true,  
), 
  

then make quick repair..

It sorts by name by default. I want to sort on modified date in descending order.

Is i missed up anythings!!

[Abuelodelanada]

Hi All,

I want to sort the list view records on date by Descending order. How I can do this is Sugarcrm.
I want to do this in all modules


Thanks,
Pravin

Hello Pravin,

In this PDF
http://developers.sugarcrm.com/tutor...onships101.pdf
you may read (Page 8):

The Layout File – Tell the module to show a subpanel
The layout file tells SugarCRM® to create a subpanel for the data from this relationship. It does not
actually define the layout of the subpanel, it just makes space for it in the layout of the target module's
DetailView. Again, there are two of these files, one for each module in the relationship. This is the Cases
layout file:

 <?php
$layout_defs['Cases']['subpanel_setup']['opportunities'] = array(
'order' => 99,
'module' => 'Opportunities',
'sort_order' => 'desc',
'sort_by' => 'opportunity_id',
'subpanel_name' => 'ForCases',
'refresh_page' => 1,
'get_subpanel_data' => 'opportunities',
'add_subpanel_data' => 'opportunity_id',
'title_key' => 'LBL_OPPORTUNITIES_SUBPANEL_TITLE',
'top_buttons' => array(
array('widget_class' => 'SubPanelTopSelectButton'),
),
);
?>  

This works for me!!

Best regards

Jose