Answers

• jamesSampica Posts: 4Questions: 1Answers: 0

  January 2021

  I was able to add this hack to get it to work. It just moves the classes around on initialization and when the column gets changed

  var columnThatsBroke = 3;
  
  $("#myDatatable").DataTable({
      ...
       initComplete: function() {
              $(individualTransfersDataTable.column(columnThatsBroke).header()).toggleClass("sorting sorting_desc_disabled");
      },
      ...
  });
  
  $individualTransfers.on("order.dt", function () {
      var order = individualTransfersDataTable.order();
          if(order[0][0] !== columnThatsBroke) 
              $(individualTransfersDataTable.column(columnThatsBroke).header()).removeClass("sorting_asc_disabled");
  } );
  
• jamesSampica Posts: 4Questions: 1Answers: 0

  January 2021

  Here's a fiddle with the hack in place https://jsfiddle.net/z9L17dmj/
• colin Posts: 15,240Questions: 1Answers: 2,599

  January 2021

  That's behaving as expected - 'asc' is an arrow that goes up. It makes more sense if you compare that to the age field which is numeric.

  Colin
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  January 2021 edited January 2021

  @colin James is right. The behavior of the sort icons is incorrect with Bootstrap 4. After initialization the icon looks like this for `asc:

  

  After sorting the column it looks like this:

  

  The order of the table is correct, just not the icons.

  The same test case not using Bootstrap behaves as expected.

  Kevin
• jamesSampica Posts: 4Questions: 1Answers: 0

  January 2021

  Hi @colin,

  Maybe I did not explain myself correctly.

  When using the bootstrap 4 theme and the orderSequence option is set to "asc" for a column, the arrow displays in the following direction...

  

  https://jsfiddle.net/qyonfhr2/

  When using the default datatables theme and the same option is set, the arrow displays in the following direction...

  

  https://jsfiddle.net/8chjfnwo/

  As you can see, the arrow is different despite using the same options. I believe "asc" should display the arrow upward and "desc" should display it downward
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  February 2021

  Oh wow - I can't believe how long this bug has been present and this is the first it has been picked. Many thanks for letting us know about it - it looks like it might be around a decade old :-/

  I've committed a fix. Its actually a bit of a work around, but it works... I've already committed changes to our v2 development branch to DataTables to make the sorting classes / styling more "sane".

  Regards,
  Allan