Setting default sorted column in Datatable

Question

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<"H"lfr>t<"F"ip<',
    "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?

live.datatables.net/amipoq/8/edit this at least works, seems problem somewhere else — zb'
– zb', Commented Oct 14, 2012 at 7:27

kannix · Accepted Answer · 2012-10-14 07:21:56Z

25

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'] ] );
} );

answered Oct 14, 2012 at 7:21

kannix

5,1777 gold badges31 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ankur Verma Over a year ago

I want to sort the table on 2 column not on 0 or 1

Gabriel Ojomu · Accepted Answer · 2015-02-12 19:33:25Z

7

I know you have the answer now, but here is an even more easier way from the DatatTable API

$('#tblMainTable').dataTable({
    "order": [[1, "desc"], [2, "desc"]]
});

Do note that the index is from 0 'Zero' so the example means "Column 2 and 3 is the default sorting column and its Descending (use asc for Ascending)."

answered Feb 12, 2015 at 19:33

Gabriel Ojomu

1922 silver badges7 bronze badges

1 Comment

Haris Amjed Over a year ago

oTable.fnSort() was giving an error. But your solution works. Thanks!

Suganthan Madhavan Pillai · Accepted Answer · 2013-12-31 07:18:41Z

2

I know you got the answer, but just for record

You can also sort it from server side by using the parameter

params.iSortCol_0

it is basically an integer 0,1,2.. means first,second,third.. column. so you can write a switch before fetching the data..

 String sortOn = 'firstcolumnname'; //default
 switch(params.iSortCol_0 as int) {

   case 0:
     sortOn = 'id';
     break;
  ......

  }

and include this in order by of your query

 order by ${sortOn}

Hope this will help

answered Dec 31, 2013 at 7:18

Suganthan Madhavan Pillai

5,64510 gold badges59 silver badges86 bronze badges

Collectives™ on Stack Overflow

Setting default sorted column in Datatable

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related