Answers

• kthorngren Posts: 21,310Questions: 26Answers: 4,948

  February 2018 Answer ✓

  In general I think you will need to use $(sellPriceTd).attr('data-order', price2); instead of $(sellPriceTd).data('order', price2);. From the jQuery data() method docs:

  The data- attributes are pulled in the first time the data property is accessed and then are no longer accessed or mutated (all data values are then stored internally in jQuery).

  DataTables does not know about the changes made directly to the HTML via jQuery. You will need to tell DataTables about the change using the invalidate() method then to redraw the table using draw(). You can use cell().invalidate() or row().invalidate() depending on your selector.

  Something like this might work:

  $(sellPriceTd).attr('data-order', price2)
  $('#mainTable').DataTable().cell( $(sellPriceTd) ).invalidate().draw();
  

  If this doesn't help please put together a test case for help in troubleshooting.

  As a side note the default sort is the fifth column ("aaSorting": [[ 4, "asc" ]],) but you are setting the data-order attribute on the forth column. This may be expected, just wanted to point out that the above won't change the table order if a different column is being sorted.

  Kevin
• SteveScott517 Posts: 2Questions: 1Answers: 0

  February 2018

  Wow thanks! My tables are sorting now, phew! The invalidation and redraw really helped.

  Could you explain the sorting a bit? The way I understand it is aaSorting sets the default sorting, and data:{sort: "<col>.@data-order") tell it to sort by the data-order attribute? I want an initial default sorting, with the option to override by clicking on the column.
• kthorngren Posts: 21,310Questions: 26Answers: 4,948

  March 2018

  The way I understand it is aaSorting sets the default sorting, and data:{sort: "<col>.@data-order") tell it to sort by the data-order attribute? I want an initial default sorting, with the option to override by clicking on the column.

  You are correct and you should have the option to sort by clicking on the columns. Do you not?

  Doesn't look like you posted your full Datatables config. Do you have ordering or its legacy equivalent bSort set to false?

  Kevin