Custom column sorting in jquery Datatable

Question

I am using jquery datatable to display data. I display '--' when there is no data. Currently when the table sorts the data all the '--' comes in the beginning and the order looks like below:

--
--
10
20
400
800

But I need to make '--' to be displayed last when sorted in ascending order and should look something like below:

10
20
400
800
--
--

Please let me know how can we get this behavior in jquery datatable?

What have you tried ? May be examples at datatables.net/plug-ins/sorting may help. — Alok Swain
– Alok Swain, Commented Apr 7, 2014 at 6:42

user3401335 · Accepted Answer · 2014-04-07 08:15:56Z

1

you can use an exstension

jQuery.extend(jQuery.fn.dataTableExt.oSort, {
    "myorder-pre": function (a) {

    },

    "myorder-asc": function (a, b) {
        if(a == '--' && b != '--')
            return 1;
        else if(b == '--' && a != '--')
            return -1;
        else if(b == '--'&& a == '--')
            return 0;
        else
        {
            a = parseFloat(a);
            b = parseFloat(b);
            return ((a < b) ? -1 : ((a > b) ? 1 : 0));

        }
    },

    "myorder-desc": function (a, b) {
        if(a == '--' && b != '--')
            return -1;
        else if(b == '--' && a != '--')
            return 1;
        else if(b == '--'&& a == '--')
            return 0;
        else
        {
            a = parseFloat(a);
            b = parseFloat(b);
            return ((a < b) ? 1 : ((a > b) ? -1 : 0));

        }
    }
});

myorder-pre is used before all the order call. myorder-asc when you order asc. Return number negative if a minor b, positive if a major b, 0 if equal. Desc work adverse

then in the definition of columns of datatable, use

"aoColumnDefs": [{ "sType": 'myorder'}]

edited Apr 7, 2014 at 8:15

answered Apr 7, 2014 at 6:57

user3401335

2,4152 gold badges23 silver badges37 bronze badges

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

1 Comment

Pradeep Over a year ago

Thanks. This is exactly what I was looking for. I will update my comments once I incorporate your implementation. Thanks once again.

Hamid Narikkoden · Accepted Answer · 2014-04-07 06:42:43Z

0

You can make use of the following code :

 $('#example').dataTable( {
    "aaSorting": [[ 4, "desc" ]]
} );

For the reference

answered Apr 7, 2014 at 6:42

Hamid Narikkoden

8615 silver badges12 bronze badges

1 Comment

Pradeep Over a year ago

No, this solution would not work as expected since we need to define the definition on asc and desc sort with regards to '--'. With the code snippet you have given it only sorts in descending order using the default behavior. Hope I am able to express clearly.

Collectives™ on Stack Overflow

Custom column sorting in jquery Datatable

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related