For null or undefined value error, Just add this line to attributes : ,columnDefs: [ { “defaultContent”: “-“, “targets”: “_all” } ] Example : oTable = $(“#bigtable”).dataTable({ columnDefs: [{ “defaultContent”: “-“, “targets”: “_all” }] }); The alert box will not show again, any empty values will be replaced with what you specified.
jQuery(‘#querytableDatasets’).dataTable({ “bAutoWidth”: false });
SOLUTION: (Notice: this solution is for datatables version 1.10.4 (at the moment) not legacy version). CLARIFICATION Per the API documentation (1.10.15), the API can be accessed three ways: The modern definition of DataTables (upper camel case): var datatable = $( selector ).DataTable(); The legacy definition of DataTables (lower camel case): var datatable = $( selector … Read more
It’s important that your THEAD not be empty in table.As dataTable requires you to specify the number of columns of the expected data . As per your data it should be <table id=”datatable”> <thead> <tr> <th>Subscriber ID</th> <th>Install Location</th> <th>Subscriber Name</th> <th>some data</th> </tr> </thead> </table>
Well I found the answer set “aaSorting” to an empty array: $(document).ready( function() { $(‘#example’).dataTable({ /* Disable initial sort */ “aaSorting”: [] }); }) For newer versions of Datatables (>= 1.10) use order option: $(document).ready( function() { $(‘#example’).dataTable({ /* No ordering applied by DataTables during initialisation */ “order”: [] }); })