How to order my last column ?

Alexol

Hello,

My table includes several columns that are added as they are added, so they can be extended.
The last column contains a total of these columns and I want to sort on this last column only

"order": [[-1,'desc']] doesn't work...?

Thank you.

colin

Hi @Alexol ,

Yep, order expects the column index. You can calculate it before you initialise the table and pass in a variable.

Cheers,

Colin

Alexol

Thank you, I thought there would be direct feature but this will be enough

$(document).ready( function () {
    var indexLastColumn = $("#table-classement").find('tr')[0].cells.length-1;
    $('#table-classement').DataTable({
        "order":[[indexLastColumn,'desc']]
    });
});