Search

is responsible for the sorting and searching. You will

I don't actually understand the question. Do you have a Javascript back end? Do you need to get the sorted data from DataTables (use rows().data() if so) and then send it to the server? Allan

Hi, Found the solution when trying to fix another. Add: attendanceDetailsTable.columns.adjust().draw(); after: $('.table').css({"width":"100%"});

Ah, that's what I've been missing. I simply didn't realize that we're actually changing the table object itself, I kept thinking that we're working on a copy of that table. I should be able to store a copy of the original table object and first restore that in my function and then apply the second settings. Thanks @kthorngren

this to be date sorted - but you've got non-dates

The problem is the $.fn.dataTable.moment( 'DD-MM-YYYY' ); for doesn't match your format in the table. You have 1/6/2001. I think your format should be$.fn.dataTable.moment( 'D/M/YYYY' );`. You have single digit day and month along with slashes (/). Here is the moment.js formatting table: https://momentjs.com/docs/#/displaying/format/ Kevin

DataTables supports ISO8601 date strings by default only. There are a number of plug-ins available for other formats. The most flexible is the MomentJS sorting plug-in for DataTables. Allan

I found out that I can just use the data-sort attribute on the element? Like on the following: <table> <thead> <tr> <td>Name</td> <td>Age</td> </tr> </thead> <tbody> <tr> <td>John Doe</td> <td data-sort="37">2/1/78 (37 years old)</td> </tr> <tr> <td>Jane Doe</td> <td data-sort="35">12/1/80 (35 years old)</td> </tr> </tbody> </table> I found the anser here: https://stackoverflow.com/questions/7668047/how-can-i-get-jquery-datatables-to-sort-on-hidden-value-but-search-on-displayed

Thanks @rf1234. Its working now.

OrderCellsTop works fine. Thanks a lot