Is there anything that's gets changed in datatables when we upgrade jQuery from 1.7 to 3.7.1?

hppatel1235

The below code seemed to work correctly with 1.7 jquery but not with 2.2.4 or 3.7.1
Current datatables version is 1.9.4

$('#manualAdjustmentList').dataTable({
            "aaSorting": [[ 4, 'desc' ]],
            "sPaginationType": "full_numbers",
            "aoColumnDefs":[
                {"bVisible":false, "aTargets":[4,6]},
                {"aDataSort":[4],"aTargets":[5]},
                {"aDataSort":[6],"aTargets":[7]}
            ]
            });

4 column is timestamp raw for sorting
5 is timestamp
6 is workof date raw for sorting
7 is workofdate.

Additionally the data gets loaded in table but no pagination is shown and total result count also incorrect
And at the bottom of table gets no data available in table message even when data is there.
Total entries to show in each page is not working.
Also bvisible false seems to hide the heading cells but not the data/record cells.

kthorngren

Datatables 1.9.4 support ended in 2014. This is from the 1.9 docs:

DataTables 1.9 was End Of Life in 2014. Do not use it for new work.

That means new versions of jQuery haven't been tested with it for 10 years. It is highly recommended to upgrade Datatables to get new enhancements and features. Datatables 2.0 was recently released with DT 1.10 being placed at end of life support. Depending on the the complexity of your configuration moving from 1.9.4 to 2.0 might take abit of work as the legacy API from 1.9 has been removed.

Take a look at the browser's console for errors. You are probably getting one or more which is causing the issues above.

Kevin