jquery datatables numeric sorting

Question

I have fetched data from database in descending order and formatted in datatable it is being shown in random order it is sorting it as string

My requirements

sort by 1st column descending order considering it numeric
disable sorting on last column
in between these 2, number of columns may vary

OR simply disable ordering data on page load, display it as it is but keep enabled columns order-able

I tried many things but could not find

Curently I am having

$('#dataTables-example').dataTable({
           'aoColumnDefs': [{
                'bSortable': false,
                'aTargets': [-1],
            }]
    });

user3459498 · Accepted Answer · 2014-07-22 21:45:41Z

1

the following code will disable initial sorting and disable sorting of lat column

    $('#dataTables-example').dataTable({
                "aaSorting": [],

                'aoColumnDefs': [{
                    'bSortable': false,
                    'aTargets': [-1],
                }]
    });

answered Jul 22, 2014 at 21:45

user3459498

831 gold badge1 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

jquery datatables numeric sorting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related