Syntax for multi-column sorting

brianK

When a user clicks on column 1 (the second column, they are 0-based right?), I want to sort on 1, and then if they are the same, soft on column 4. Is this the proper syntax?

    $(document).ready(function() {
            var table = $('#example').DataTable( 
            {
                scrollY:        "300px",
                scrollX:        true,
                scrollCollapse: true,
                paging:         false
            },
            {
                "columnDefs": [
                    { "orderData": 0,       "targets": 0 },
                    { "orderData": [1, 4],  "targets": 1 },
              ]
            } 
        );

        new $.fn.dataTable.FixedColumns( table, 
            {
                "leftColumns": 1        
            });

    } );

allan

they are 0-based right?

Yes

Is this the proper syntax?

Not quite, Only pass one object into DataTables:

$(document).ready(function() {
        var table = $('#example').DataTable(
        {
            scrollY:        "300px",
            scrollX:        true,
            scrollCollapse: true,
            paging:         false,
            "columnDefs": [
                { "orderData": 0,       "targets": 0 },
                { "orderData": [1, 4],  "targets": 1 },
          ]
        }
    );
 
    new $.fn.dataTable.FixedColumns( table, {
            "leftColumns": 1       
        });
} );

Allan

brianK

Thanks! I'm just getting started with DataTables.