Disabling sorting in datatables not functioning

Question

Here is the code i am using

oTable = $('#example').dataTable({
                "bSort": false,
                "bStateSave":true,
                "aoColumns": [ 
                   { "bSortable": false },
                   { "bSortable": false },
                   { "bSortable": false } ] 
            });

The problem i'm having is that the table starts off blank and its populated by user input. Once the user starts to input things into the table, it sorts them by product ID. I'm trying to remove this sorting so that it just lists them as they are input.

EDIT: I have come to the conclusion that NONE of my initialization settings are working. I believe it has to do with the fnAddRow when the table is empty except for headers.

EDIT2: I've isolated it down to the fnAddData. When I initialize the table with trash data everything is formatted as its supposed to be but then once i use the fnAddData, it removes all formating

you may also want to look cbabhusal.wordpress.com/2015/05/20/… — Shiva
– Shiva, Commented Aug 18, 2015 at 2:43

LittleBobbyTables - Au Revoir · Accepted Answer · 2012-10-17 13:23:49Z

103

Try this:

$(document).ready( function () {$('#example').dataTable( {
    "bSort": false
  } );
}

edited Oct 17, 2012 at 13:23

LittleBobbyTables - Au Revoir

33k25 gold badges113 silver badges115 bronze badges

answered Oct 17, 2012 at 13:22

Alborz

2,0432 gold badges20 silver badges17 bronze badges

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

Comments

Daniel · Accepted Answer · 2011-12-29 05:11:52Z

26

try this:

this is to disable initial sort

$(document).ready( function() {
  $('#example').dataTable({
    "aaSorting": []
});
})

edited Dec 29, 2011 at 5:11

answered Dec 29, 2011 at 5:00

Daniel

37.2k10 gold badges122 silver badges208 bronze badges

2 Comments

Onimusha Over a year ago

This should be default setting on data tables. Thanks for this.

Brad M Over a year ago

Thank you. Search brought me here and the answer disabled all sorting, the initial is what I was after. Saved me some time having this here.

roNn23 · Accepted Answer · 2016-07-07 15:02:39Z

8

Since version 1.10 of DataTables, you can use the following option to disable the ordering completely:

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

Also see: https://datatables.net/reference/option/ordering

answered Jul 7, 2016 at 15:02

roNn23

1,7121 gold badge19 silver badges33 bronze badges

Comments

Allan Jardine · Accepted Answer · 2011-12-29 07:49:15Z

2

bSort ( http://datatables.net/ref#bSort ) is the correct way to disable sorting in DataTables. Perhaps you can link to your example which shows sorting still enabled with this parameter set please?

answered Dec 29, 2011 at 7:49

Allan Jardine

5,5315 gold badges33 silver badges34 bronze badges

1 Comment

aport002 Over a year ago

I can't actually link the page due to a login required to populate the drop down menu from a database. I suspect it has to do with having a blank table and then adding rows. I have tried every method i saw on the datatables.net site and nothing seems to be working. The sorting always appears

Bhargav Kaklotara · Accepted Answer · 2018-02-05 11:02:01Z

2

try this one,

set data-orderable ="false" in the table header tag

<table id="orders">
   <thead>
     <tr>
       <th data-orderable="false">ID</th>
       <th>Customer Name</th>
       <th data-orderable="false">Total</th>
       <th>Date</th>
       <th data-orderable="false">Action</th>
     </tr>
   </thead>
</table>

answered Feb 5, 2018 at 11:02

Bhargav Kaklotara

1,4781 gold badge14 silver badges24 bronze badges

Comments

Kailas · Accepted Answer · 2013-10-05 09:35:12Z

1

use the below code

"aoColumnDefs": [
  { "bSortable": false, "aTargets": [ 0 ] }
] } );

OR use the link http://datatables.net/ref#bSortable

answered Oct 5, 2013 at 9:35

Kailas

3,2415 gold badges48 silver badges54 bronze badges

Comments

Scherbius.com · Accepted Answer · 2011-12-28 22:49:47Z

0

Default sorting can be set by asSorting parameter. Please see:

http://datatables.net/usage/columns

answered Dec 28, 2011 at 22:49

Scherbius.com

3,4224 gold badges26 silver badges45 bronze badges

3 Comments

aport002 Over a year ago

i DONT want to have sorting though

Scherbius.com Over a year ago

add a hidden field with timestamp. Set default sorting by this time. Items will show up in the same order as they were added.

aport002 Over a year ago

I did this except with index numbers. The problem is none of the initial parameters are being kept after fnAddData runs. I believe somewhere in the fnAddData code, the oSettings field is being cleared.

Collectives™ on Stack Overflow

Disabling sorting in datatables not functioning

7 Answers 7

Comments

2 Comments

Comments

1 Comment

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

2 Comments

Comments

1 Comment

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related