jQuery DataTable: Disabling sorting for specific columns

Question

I have 6 columns in my jQuery Data table and want to disable sorting for the first and last column.

I have used the following code:

$('#UserDetails').dataTable({
    "aoColumns": [
          { "bSortable": false },
          null,
          null,
          null,
          null,
          { "bSortable": false }
      ]
});

This code disables sorting for the last column but not the first.

Can someone please help?

Can you create a jsfiddle which reproduces the problem? I am not able to -> jsfiddle.net/fw0z7sc3 What version of dataTables are you using? — davidkonrad
– davidkonrad, Commented Dec 3, 2014 at 11:57

IronAces · Accepted Answer · 2017-03-22 13:11:49Z

3

For 1.10.13, you can use the following

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

answered Mar 22, 2017 at 13:11

IronAces

1,9011 gold badge28 silver badges37 bronze badges

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

Comments

faby · Accepted Answer · 2014-12-03 08:25:14Z

2

try this

$('#UserDetails').dataTable( {
      "aoColumnDefs": [
          { 'bSortable': false, 'aTargets': [ 0,5 ] }
       ]
});

where 0,5 are the indexes of the columns that you want to exlude from the sort

answered Dec 3, 2014 at 8:25

faby

7,6043 gold badges30 silver badges45 bronze badges

2 Comments

Mitali Over a year ago

Still the same issue continues. The 6th column becomes unsortable but first column still sorts

faby Over a year ago

can you reproduce it on a fiddle so I can see it?

Sri Tirupathi Raju · Accepted Answer · 2014-12-03 08:30:21Z

1

In Jquery datatable usually we use last column for sending extrdata/payload so if you have 6 visible columns actually they are 7 columns so:

$('#UserDetails').dataTable({
    "aoColumns": [
          { "bSortable": false },
          {"bSortable": true},
          {"bSortable": true},
          {"bSortable": true},  
          {"bSortable": true},
          {"bSortable": false}, 
          {"bSortable": false, "bVisible":false} //invisible column
      ]
});

answered Dec 3, 2014 at 8:30

Sri Tirupathi Raju

8395 silver badges14 bronze badges

1 Comment

Mitali Over a year ago

Generates error that there is no 6th column defined. So I added a new column but still same problem continues..

Collectives™ on Stack Overflow

jQuery DataTable: Disabling sorting for specific columns

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related