order datatable
$(document).ready(function() { $('#example').DataTable( { "order": [[ 3, "desc" ]] } ); } );
Source: datatables.net
datatable get order column
var table = $('#example').DataTable(); var order = table.order(); alert( 'Table is ordered by column: ' + order[0][0] + ', direction:' + order[0][1]); var title = table.column(order[0][0]).header(); alert( 'Ordering column title: ' + $(title).html() );
Source: stackoverflow.com
datatable order number
var table = $('#table').DataTable({ data: data, columns: [ {data: 'id', title: '#'}, //must have ], order: [[0, 'desc']], fnRowCallback: function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) { $('td:eq(0)', nRow).html(iDisplayIndexFull +1); } })