Sorting
There are 2 sorting approaches.
Local sorting
To enable local sorting, you need to set for columns that needs to be sorting, param
sortable: true,
Server sorting
To enable server sorting, you need either enable sorting for needed columns
sortable: true,
And set in data property
data: {
remoteSort: true,
proxy: {
url: 'ajax.php'
}
},
If data is from server and paged than if to enable sorting than it will be auto set to remoteSort: true.
On server sorting params will be avaliable in params: sort and dir.
sort is for index(key), dir is direction of sorting, can have 2 values(asc, desc)
Server multi-sorting
If data is multisorted than grid sends another params(comparing to usual sorting) on server.
data: {
remoteSort: true,
proxy: {
url: 'ajax.php'
}
},
multiSort: true,
On server it will be sent param sorters
Example: Sorted grid by 2 columns.
Param sorters is Array.
Each item of array contains 3 params - key - column index(key),
dir - sorting derection, type - sorter: string|number.
sorters: [{
key: 'surname',
dir: 'ASC',
type: 'string'
},{
key: 'age',
dir: 'DESC',
type: 'number'
}]