Default sort order in list view

[door3ahmed]

I'm trying to have a list view default its sort order to one of the fields, is there a way to do this?

[sugarcane]

Hello,

what module and what field are you trying to sort on? You should be able to click on the field name in the list view, and the list should sort in that order (you can sort ascending or descending). This is on a user by user basis, so the sorting should stick if you change it.

If the field you want to sort by is not sortable, you can modify this in the listviewdefs.php file:

custom/modules/<ModuleName>/metadata/listviewdefs.php
and set
'sortable' => true,

[door3ahmed]

Opportunities module, and a custom field.

It's sortable but I want it to be sorted by the custom field by default, so when a new user comes in it's already sorted properly.

[hugoyar]

Have a look to:
http://www.sugarcrm.com/forums/showt...ght=sort+order

I'm actually trying to do the same think. Not yet succesfull, but I'm getting close I think.

[SugarDev.net]

this is not possible afaik. I agree it's not an advantage that an admin is not able to control more of the user settings.

[hugoyar]

After several tests I finally isolate one file that can be changed :

\custom\modules\MyModul\Ext\Layoutdefs\layoutdefs. ext.php


$layout_defs["MyModule"]["subpanel_setup"]["MyModuleSubPanel"] = array (
'order' => 100,
'module' => 'MyModule',
'subpanel_name' => 'default',
'sort_order' => 'desc',
'sort_by' => 'name',
);

Not yet understand how all this work because SubPanel.php seems to require those in something like $layout_defs[$module]['custom_subpanel_defines'][$subpanel_id]. It is also make reference to an _override prefixed file. This seems to be explained in :
http://developers.sugarcrm.com/docs/...4.html#9002252
but I do not yet have tested this"repair" action.
Still working on it...

[hugoyar]

ok, it works. So I should just RTFM.

If you want to also remove 'select' or 'create' button in subpanel, just add an empty array as 'top_buttons':

$layout_defs["MySourceModule"]["subpanel_setup"]["MySource_MyDest"] = array (
'order' => 100,
'module' => 'myDstModule',
'subpanel_name' => 'default',
'sort_order' => 'desc',
'sort_by' => 'name',
'title_key' => 'LBL_MySource_MyDest_FROM_MyDest_TITLE',
'get_subpanel_data' => 'MySource_MyDest',
'top_buttons' =>
array (
),
);

[martyM]

NONE of these are the answer for the question, I think... I'm trying to solve this too and I get to this point:

if I add to "include/ListView/ListViewData.php" around line 280 just before the line :

 $ret_array = $seed->create_new_list_query($orderBy, $where, $filter_fields, $params, 0, '', true, $seed, true); 
  

this:

 // set default sort order for MyModule
if ($GLOBALS['module'] == 'MyModule')
{
    $orderBy = 'MyModule.MyField DESC';
} 
  

I've got list (classic list view NOT subpanel list) ordered by MyField by default...

BUT:
with this I lost opportunity to order list by another field...

[andopes]

Hi Marty

This is not an upgrade safe approach.
You may consider creating a view.list.php for your module, implement the method listViewPrepare with this content:

 function listViewPrepare() {
  if(empty($_REQUEST['orderBy'])) {
    $_REQUEST['orderBy'] = 'MyModule.MyField DESC';
  }
 
  parent::listViewPrepare();
} 
  

Cheers

[martyM]

Hi Andopes,

i know, it's not upgrade safe, it's just one solution (I'm not saying it's the best ) I found.

Anyway, thank you very much for advice... I'm going to try it that way... Thanks once again!