I have a question regarding jQuery DataTables.I have the following situation , when table is loading everything should be sorted by third column , but at the same time , I sorting by columns should be disabled (when clicking on the header of the table), and highlighting of column on which sorting is done should be also disabled.

Please if you have any idea , share it with me. Thank You.

I have a question regarding jQuery DataTables.I have the following situation , when table is loading everything should be sorted by third column , but at the same time , I sorting by columns should be disabled (when clicking on the header of the table), and highlighting of column on which sorting is done should be also disabled.

Please if you have any idea , share it with me. Thank You.

• javascript
• jquery
• datatables

Share Improve this question Follow asked Jan 25, 2016 at 19:21 Hank MooodyHank Mooody 5271313 silver badges2929 bronze badges 1

• a quick google search turns up lots of results for this – charlietfl Commented Jan 25, 2016 at 19:29

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 6

SOLUTION

Use order option to define initial sorting along with columnDefs.orderable set to false to disable sorting for specific columns and columnDefs.targets set to _all to target all columns.

var table = $('#example').DataTable({
   order: [[2, 'asc']],
   columnDefs: [{
      targets: "_all",
      orderable: false
   }]
});

If you don't want the sorted column to be higlighted use the following classes for your table: stripe hover row-border, see the HTML example below:

<table id="example" class="stripe hover row-border" cellspacing="0" width="100%">

DEMO

See this jsFiddle for code and demonstration.