How to disable sorting of first column of DataTables?

Question

I have tried many ways of disabling sorting on the first column. I have not been able to achieve it.

I have been able to disable all columns beside the first column using:

'columnDefs': [ {
'targets': [],
'orderable': false, // set orderable false for selected columns
}]

Can anyone help me, please?

Avanthika · Accepted Answer · 2019-05-12 17:01:15Z

2

Your columnDefs.targets is empty. You have to pass the index of the column where you want to disable sorting. For first column, you need to pass the first column's index, 0.

As per datatables documentation, you can disable ordering of first column in two ways:

With columnDefs:

$('#example').dataTable( {
  "columnDefs": [
    { "orderable": false, "targets": 0 }
  ]
} );

With columns:

"columns": [
    { "orderable": false },
    null,
    null,
    null,
    null
]

answered May 12, 2019 at 17:01

Avanthika

4,1821 gold badge15 silver badges19 bronze badges

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

4 Comments

Avanthika Over a year ago

jsfiddle.net/d12a9gxn - Works for me, can you share a jsfiddle with your config?

BillNathan Over a year ago

Where does it work? The sorting icon is still active on the first tab. Did you see?

Avanthika Over a year ago

Oh, you want to remove the initial default sorting? aaSorting: [] - This should be passed as a config option. I have removed the initial sort here - jsfiddle.net/xom4qdeL

Avanthika Over a year ago

Or you will have to do order: []

Mayuresh Srivastava · Accepted Answer · 2021-05-24 06:19:50Z

0

order is used to apply initial order (sort) to the table.
It can be used to apply initial sorting on any other column.
By default, DataTables use first column even if you disable sorting for that column using targets.

answered May 24, 2021 at 6:19

Mayuresh Srivastava

1,4201 gold badge20 silver badges29 bronze badges

Collectives™ on Stack Overflow

How to disable sorting of first column of DataTables?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related