Search

Possibly pertinent, this is order that I am loading js <script src="https://code.jquery.com/jquery-3.6.0.min.js" ></script> <script src="https://cdn.plot.ly/plotly-latest.min.js"></script> <script src="https://unpkg.com/json5@2.2.0/dist/index.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" > </script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js"> </script> <!-- Datatables JavaScript --> <script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script> <script src="https://cdn.datatables.net/1.11.3/js/dataTables.bootstrap5.min.js"></script> <script src="https://cdn.datatables.net/select/1.3.3/js/dataTables.select.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.0.1/js/dataTables.buttons.min.js"></script>

to track the previous order. So, here my final

the rows in the order they are displayed in

works as expected. In order to help we will

At the moment you would need to call the API method order(). There is a discussion on this topic here which you might be interested in joining in with. Allan

bFilter: true, bSort: true, ordering: true, order: [[0, "asc"]], bPaginate: true,

type: 'POST' }, serverSide: true, order: [[ 1, 'asc' ]], columns: [ { // Responsive

The default order returned using rows() is

sql = "SELECT * from $tableparm order by columnOrder + 0 ASC";

Ok I checked the XHR respose from the server and the data is actually in this weird order, now I feel stupid. Thanks for the answer Kevin!