Simple custom sorting function for jQuery DataTables

Question

Numeric sorting is not working on my dataset. So I made a custom sorting that converts whole string into number then sorts based on that, but for some reasons its not working. What am i missing here?

$.fn.dataTableExt.oSort["test-desc"] = function (x, y)
{

         x = parseInt(x);
        y = parseInt(y);

        if ( x < y)
        {
            return 1;
        }

        return 0;


};

$.fn.dataTableExt.oSort["test-asc"] = function (x, y)
{

    x = parseInt(x);
    y = parseInt(y);

    if ( x > y)
    {
        return 1;
    }

    return 0;

}

$('table').DataTable({
    "pageLength": 300,
    "bLengthChange": false,
    "columnDefs": [
    { "type": "test", targets: 3 }
    ]
});

Both ascending and descending are not working properly. I have checked these functions are being called and properly converting strings to numeric instances.

For what I see on the image you're parsing strings to number (string to int) that includes "A | % : "? — William-H-M
– William-H-M, Commented Nov 14, 2017 at 20:09
Yes, whatever is in the cell is parsed. Which includes div tags as well. — Waleed
– Waleed, Commented Nov 14, 2017 at 20:42

Waleed · Accepted Answer · 2017-11-15 03:21:32Z

5

jQuery DataTable sort function doesn't return 1 and 0. Instead they return 1 and -1. So modifying the sort function made them work perfectly.

    $.fn.dataTableExt.oSort["test-desc"] = function (x, y)
    {

        x = parseInt(x);
        y = parseInt(y);

        if ( x > y)
        {
            return -1;
        }

        return 1;

    };

    $.fn.dataTableExt.oSort["test-asc"] = function (x, y)
    {

        x = parseInt(x);
        y = parseInt(y);

        if ( x > y)
        {
            return 1;
        }

        return -1;
    }

answered Nov 15, 2017 at 3:21

Waleed

1,2102 gold badges21 silver badges49 bronze badges

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

Comments

Daniel Manta · Accepted Answer · 2020-08-27 20:34:05Z

0

The jQuery DataTable sort function does not look 0 or 1, or for 1 or -1 specifically. It looks for either positive or negative values. So you could just do:

$.fn.dataTableExt.oSort["test-desc"] = function (x, y) {
    x = parseInt(x);
    y = parseInt(y);
    return y - x;
};

$.fn.dataTableExt.oSort["test-asc"] = function (x, y) {
    x = parseInt(x);
    y = parseInt(y);
    return x - y;
};

edited Aug 27, 2020 at 20:34

Daniel Manta

6,76317 gold badges43 silver badges49 bronze badges

answered Aug 27, 2020 at 17:29

Govind B

461 bronze badge

Collectives™ on Stack Overflow

Simple custom sorting function for jQuery DataTables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related