order: [[ 1, "desc" ]] not working

mitch2k

Hi,

I'm trying to change the default ordening for my table like this:

// Basic ColVis example
$('.datatable-colvis-basic').DataTable({
    colVis: {
        buttonText: "<i class='icon-three-bars'></i> <span class='caret'></span>",
        align: "right",
        overlayFade: 200,
order: [[ 1, "desc" ]],
        showAll: "Show all",
        showNone: "Hide all"
    }
});

I guess the "order: [[ 1, "desc" ]]," should force the table to sort on that column, but it doesn't. Am I missing something?

Thanks

SamuelNZ

Try:

// Basic ColVis example
$('.datatable-colvis-basic').DataTable({
    colVis: {
        buttonText: "<i class='icon-three-bars'></i> <span class='caret'></span>",
        align: "right",
        overlayFade: 200,
        order: 'alpha',
        showAll: "Show all",
        showNone: "Hide all"
    }
});

Additionally, You should be using the Buttons extension now as Colvis is retired.

SamuelNZ

I'm not sure if you can call aaSorting from within Colvis, So try this if the above doesn't work:

// Basic ColVis example
$('.datatable-colvis-basic').DataTable({
    colVis: {
        buttonText: "<i class='icon-three-bars'></i> <span class='caret'></span>",
        align: "right",
        overlayFade: 200,
        showAll: "Show all",
        showNone: "Hide all"
    },
    aaSorting: [[1,'desc']]
});

allan

Yes - the issue is that order is not a property of the colVis options. It is a top level option:

// Basic ColVis example
$('.datatable-colvis-basic').DataTable({
    colVis: {
        buttonText: "<i class='icon-three-bars'></i> <span class='caret'></span>",
        align: "right",
        overlayFade: 200,
        showAll: "Show all",
        showNone: "Hide all"
    },
    order: [[ 1, "desc" ]]
});

See the order reference documentation for details and further examples.

Allan

mitch2k

Thanks Allan, that was indeed the issue.