sforsandeep sforsandeep - 9 months ago 49
Javascript Question

How to enable sorting only for one column in JQUERY Datatable

Im trying to enable sorting based on one column only in a datatable. but its not working. This is the way I tried

var myTable = $("#tbl_main").dataTable({
"dom": "<'tableinfobar'i><'tablesearchbox'f><'tablestarfilter'><'tablebody't>S<'tablelength'l><'tablepaging'p>",
"ordering": false,
"columnDefs": [{"targets": [0, 6],"searchable": false}, {"targets":2, "type":"html-num","orderable":true}],
"lengthMenu": [
[10, 20, 50, 100, 500, -1],
[10, 20, 50, 100, 500, "All"]

Here I need to enable sorting only for second column only and tried that in columnDefs


add class no-sort to all the <th> except the column which you want to sort.. kindly check https://jsfiddle.net/24zztcL9/

I have enabled sort only for 2nd column "Position"


<table id="example" class="display" cellspacing="0" width="100%">
                <th class="no-sort">Name</th>
                <th class="no-sort">Office</th>
                <th class="no-sort">Age</th>
                <th class="no-sort">Start date</th>
                <th class="no-sort">Salary</th>


$(document).ready(function() {

    "ordering": true,
    columnDefs: [{
      orderable: false,
      targets: "no-sort"