Question

161

Setting default sorted column in Datatable

rated 0 times [ 163] [ 2] / answers: 1 / hits: 29495 / 12 Years ago, sun, october 14, 2012, 12:00:00

I am working on datatable plugin in Jquery. And have to set the default column by which the data is sorted so I mean that :

I have a table with 4 columns and by default the data is sorted by column no 1, I want that the data should be sorted by column number 2 or 3.

How that can be done:

$('#tblMainTable').dataTable({

    bJQueryUI : true,

    sDom : 'R<Hlfr>t<Fip<',

    aoColumns : [ 

        {bSortable : false}, 

        null, 

        null,

        null,

        {bSortable : false}, 

        {bSortable : false}

    ],

    aaSorting: [[ 2, desc ]]

});

I specified that in aaSorting but not getting the result.

Please shed some light?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

zachary

Add To Favorites

Follow

Total Points: 175

Total Questions: 89

Total Answers: 108

Location: Fiji

Member since Wed, Jul 14, 2021

3 Years ago

zachary questions

1 Bootstrap 5 - Modal Open on Page Load

Tue, Oct 12, 21, 00:00, 3 Years ago

1 React + TypeScript: How to fix return type 'Element[]' is not a valid JSX element.?

Wed, Jun 9, 21, 00:00, 3 Years ago

1 Encountered Error: Material-UI: capitalize(string) expects a string argument. when using snackbar in React Material-UI

Sat, Jul 18, 20, 00:00, 4 Years ago

1 how to format date in jQuery DataTables

Thu, Jun 18, 20, 00:00, 4 Years ago

1 Node.js unable to import ES6 module

Sat, Jan 25, 20, 00:00, 4 Years ago

View All

answered 12 Years ago whitney · Accepted Answer

The example in the datatable api does it like this:

$(document).ready(function() {

  var oTable = $('#example').dataTable();



  // Sort immediately with columns 0 and 1

  oTable.fnSort( [ [0,'asc'], [1,'asc'] ] );

} );