TYPO3 Sorting.md

1. Add sorting field to table in ext_tables.sql

sorting int(11) DEFAULT '0' NOT NULL,

2. add sorting field in table TCA extension/Configuration/TCA/table_name.php to columns

'sorting' => array(
	'config' => array(
		'type' => 'passthrough',
	),
),

3. add sorting field to interface and types in extension/Configuration/TCA/table_name.php

'interface' => array(
	'showRecordFieldList' => 'sys_language_uid, ..., sorting',
),
'types' => array(
	'1' => array('showitem' => 'sys_language_uid;;;;1-1-1, ..., sorting'),
),

4. Set sortby in ctrl section to sorting in extension/Configuration/TCA/table_name.php

'ctrl' => array(
	'title'	=> 'table title bla bla',
	...
	'sortby' => 'sorting',
       ...
),

5. Add default sorting in Model Repository:

class MyTableRepository extends \TYPO3\CMS\Extbase\Persistence\Repository
{

    /**
     * @var array
     */
    protected $defaultOrderings = array(
        'sorting' => \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_ASCENDING
    );

}