DataTables Sorting
There are two options that control the sorting, and they are bsort and order. Note that the index of columns of the DataTables is start with 0. I.e. The index of the first column is 0.
No Sorting
Adding bSort: false in option. Example:
var table = $("#table").DataTable({
dom: 'rti',
pageLength: -1,
bSort: false
});
Sorting According to the First Column, in Ascending Order
Adding order: [[0, "asc"]] in option. Example:
var table = $("#table").DataTable({
dom: 'rti',
pageLength: -1,
order: [[0, "asc"]]
});
Sorting According to the First Column, in Descending Order
Adding order: [[0, "desc"]] in option. Example:
var table = $("#table").DataTable({
dom: 'rti',
pageLength: -1,
order: [[0, "desc"]]
});
Sorting for Multiple Columns
order option actually accepts an array of input. If we want to sort the first column in descending order, and second column in ascending order, we can use order: [[0, "desc"], [1, "asc"]] in option. Example:
var table = $("#table").DataTable({
dom: 'rti',
pageLength: -1,
order: [[0, "desc"],
[1, "asc"]]
});