Set the aaSorting option to an empty array. It will disable initial sorting, whilst still allowing manual sorting when you click on a column. “aaSorting”: [] The aaSorting array should contain an array for each column to be sorted initially containing the column’s index and a direction string (‘asc’ or ‘desc’).
It’s even simpler: just use dataSrc:” option in the ajax defintion so dataTable knows to expect an array instead of an object: $(‘#pos-table2’).DataTable({ processing: true, serverSide: true, ajax:{url:”pos.json”,dataSrc:””} } ); See ajax options
CAUSE Most likely your table is hidden initially which prevents jQuery DataTables from calculating column widths. SOLUTION If table is in the collapsible element, you need to adjust headers when collapsible element becomes visible. For example, for Bootstrap Collapse plugin: $(‘#myCollapsible’).on(‘shown.bs.collapse’, function () { $($.fn.dataTable.tables(true)).DataTable() .columns.adjust(); }); If table is in the tab, you need … Read more
Update 2020: HTML Solution Since HTML 5 is so much developed and almost all major browser supporting it. So now a much cleaner approach is to use HTML5 data attributes (maxx777 provided a PHP solution I am using the simple HTML). For non-numeric data as in our scenario, we can use data-sort or data-order attribute … Read more
jQuery(‘#querytableDatasets’).dataTable({ “bAutoWidth”: false });
With version 1.10.0 of DataTables, it is built-in and easy: var table = $(‘#example’).DataTable(); table.ajax.reload(); or just $(‘#example’).DataTable().ajax.reload(); http://datatables.net/reference/api/ajax.reload()
You should include “bPaginate”: false, into the configuration object you pass to your constructor parameters. As seen here: http://datatables.net/release-datatables/examples/basic_init/filter_only.html
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
You can remove it with the bInfo option (http://datatables.net/usage/features#bInfo) $(‘#example’).dataTable({ “bInfo” : false }); Update: Since Datatables 1.10.* this option can be used as info, bInfo still works in current nightly build (1.10.10).
CAUSE There could be multiple reasons for this error. jQuery DataTables library is missing. jQuery library is loaded after jQuery DataTables. Multiple versions of jQuery library is loaded. SOLUTION Include only one version of jQuery library version 1.7 or newer before jQuery DataTables. For example: <script src=”https://stackoverflow.com/questions/31227844/js/jquery.min.js” type=”text/javascript”></script> <script src=”js/jquery.dataTables.min.js” type=”text/javascript”></script> See jQuery DataTables: Common … Read more