How can i disable automatic sort of DataTables?

Question

My Data-Tables Initialization Script is

$('#table').DataTable();

I want to disable auto sort of table column

try "bSortable": false , look this jsfiddle: jsfiddle.net/jhfrench/ptr63fxt — Ketan Modi
– Ketan Modi, Commented Nov 11, 2017 at 4:48
The correct answer is order: [] ...This maintain the order capabilities but does not set a default order, which is [[0, 'asc']] ordering the first column ascending. — davidkonrad
– davidkonrad, Commented Nov 11, 2017 at 5:09

vishal ribdiya · Accepted Answer · 2017-11-11 04:57:02Z

6

Ok,i found the solution

just add data-order = ' ' in your table

<table class="table table-striped table-bordered " id="table"  data-order=''>

answered Nov 11, 2017 at 4:57

vishal ribdiya

1,1032 gold badges13 silver badges20 bronze badges

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

1 Comment

Alper Over a year ago

This is actually good answer, sign your answer as a solution. Simple and effective. I have been seaching for this. Edit: This corrupt table sorting property permanently. It is no good for stopping the initial sorting.

dloeda · Accepted Answer · 2018-03-27 10:00:11Z

1

Set the aaSorting option to an empty array. It will disable initial sorting,

"aaSorting": []

Example :

$('#you_table_id').DataTable({
    "aaSorting": []
});

The aaSorting array should contain an array for each column to be sorted initially containing the column's index and a direction string (asc or desc).

edited Mar 27, 2018 at 10:00

dloeda

1,54815 silver badges24 bronze badges

answered Mar 27, 2018 at 9:23

Walid azouzi

811 silver badge9 bronze badges

Comments

A.D. · Accepted Answer · 2017-11-11 05:20:30Z

0

// For updated version

$('#table').dataTable( {
  "ordering": false
} );

// For older version

This is done by setting bSortable to false

$('#table').dataTable({
"bSortable": false 
});

by aoColumnDefs

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

by aoColumns

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

edited Nov 11, 2017 at 5:20

answered Nov 11, 2017 at 5:08

A.D.

2,3722 gold badges17 silver badges25 bronze badges

Comments

Mark Joseph M. Pino · Accepted Answer · 2024-03-05 05:53:08Z

0

Disabling auto-sort with custom pagination icon using Font Awesome

$("#table").dataTable({
    pagingType: "simple",
    ordering: true,
    autoWidth: true,
    language: {
        emptyTable: "No data available in table",
        paginate: {
            previous: '<i class="fa fa-chevron-left"></i>',
            next: '<i class="fa fa-chevron-right"></i>',
        },
        search: "",
        searchPlaceholder: "Search",
        info: "_START_ - _END_ of _TOTAL_",
        infoEmpty: "",
        infoFiltered: "",
    },
    order: [] // Add this to Disable the auto-sorting
});

answered Mar 5, 2024 at 5:53

Mark Joseph M. Pino

1382 silver badges10 bronze badges

Collectives™ on Stack Overflow

How can i disable automatic sort of DataTables?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related