Advanced filter - Order by column

Bungle · 23 February 2020 16:28

How do i add a field to the ‘order by column’ in the advanced search of a listview?

I want to set the default sort order of opportunity, but can’t because the field i want to sort by does not appear in the ‘order by column’ dropdown,

pgr · 23 February 2020 16:37

I’m not sure where it gets that from, maybe from the listviewdefs, like this one?

github.com

salesagility/SuiteCRM/blob/master/modules/Opportunities/metadata/listviewdefs.php#L60


    'label'   => 'LBL_LIST_OPPORTUNITY_NAME',
    'link'    => true,
    'default' => true),
'ACCOUNT_NAME' => array(
    'width'   => '20',
    'label'   => 'LBL_LIST_ACCOUNT_NAME',
    'id'      => 'ACCOUNT_ID',
    'module'  => 'Accounts',
    'link'    => true,
    'default' => true,
    'sortable'=> true,
    'ACLTag' => 'ACCOUNT',
    '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}',

While testing, I suggest you try your changes there directly first, just to see if it works; when you nail it, then move it into a proper custom/Extension file, to make sure it stays upgrade safe.

Other places to look are (under the same directory) the SearchFields and searchdefs files.

Bungle · 25 February 2020 10:45

i have not managed to add the column to the filter popup yet, and unfortunately ‘sortable’ did not work for me.

However, i managed to sort the column by clicking the sort arrow on the column header and then running quick filter - then rearranging the columns.

dgailwhitt · 7 July 2021 13:43

In order to see a field in the Order by column dropdown, it must be a field in the Layout for ListView in the Default column. If you use Studio to make this change, you will see your column show up in the Order by Column dropdown.
Dianna