Jquery/Bootstrap DataTable Sorting not working properly

Question

 $('#StudentTable').dataTable({

    "aaSorting": [],
    "bSorting": false,
    "bProcessing": false,
    "bPaginate": false,
    "bFilter": false,
    "bDestroy": false,
    "bAutoWidth": true,
    "sScrollY": "224px",
    "aoColumns": [
                    { "sTitle": "StudentId" },
                    { "sTitle": "Name" },
                    { "sTitle": "Address" },
                    { "sTitle": "Mobileno" },
                    { "sTitle": "Email" }
                ],

    "aaData": Students
});

I am binding data to datatable dynamically...but problem is sorting not working properly.. it will sort Studentid 1 to 10 properly but if it is gretter then 10 it will come some studentid in top .you can see bellow output of sorting

See output of sorting order

Yes - Perhaps this is treated as string and sorting like string. — r.piesnikowski
– r.piesnikowski, Commented Dec 12, 2013 at 9:49

Webking · Accepted Answer · 2013-12-12 09:49:53Z

3

You need to tell dataTable what kind of datatype each column exist of. Set the StudentId sType to "sType": 'numeric' and it should sort correct.

$('#StudentTable').dataTable({

"aaSorting": [],
"bSorting": false,
"bProcessing": false,
"bPaginate": false,
"bFilter": false,
"bDestroy": false,
"bAutoWidth": true,
"sScrollY": "224px",
"aoColumns": [
                { "sTitle": "StudentId", "sType": 'numeric'  },
                { "sTitle": "Name" },
                { "sTitle": "Address" },
                { "sTitle": "Mobileno" },
                { "sTitle": "Email" }
            ],

"aaData": Students

});

answered Dec 12, 2013 at 9:49

Webking

1,8622 gold badges20 silver badges29 bronze badges

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

2 Comments

Boss Over a year ago

if it is numeric concatenated with string.which data type need to use

Webking Over a year ago

If your column dont follow regular datatypes you should implement a custom sort order function. Se this page for more info. datatables.net/plug-ins/sorting

Collectives™ on Stack Overflow

Jquery/Bootstrap DataTable Sorting not working properly

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related