Jquery datatables Sorting

twitter logo ・1 min read

Hi guys, I was having trouble sorting manual data for custom data present in column like A, A++ , A+, A-- , A-. The Jquery plugin for this one I am using is- datatables.net . Currently the sorting is working fine for conventional datatypes such as Int - 1,2 3,4,5 Char- A, B, C, D. Does anyone know how to make it work on manual data as well?

twitter logo DISCUSS (3)
markdown guide

Thanks @rhymes & Ben.
After lots of research, I came across:

and used it like this:

//sorting for grades
    $(function() {
        id: 'grades',
        is: function() {
          return false; // do not auto-detect this parser
        format: function(s) {
          var grades = ['A++','A+','A','B++','B+','B','C++','C+','C','A--','A-','B--','B-','C--','C-','NA'],
            index = grades.indexOf(s.toUpperCase());
          return index > -1 ? index : s;
        type: 'numeric'
      $('#datatable').tablesorter({ headers: { 6: {sorter:"grades"} } });

Table is now getting sorted as expected :)


What if you create a custom plugin for sorting?

According to datatables.net/reference/option/co... sorting is done on a few predefined types BUT:

It is expected that the above options will cover the majority of data types used with DataTables, however, data is flexible and comes in many forms, so additional types with different effects can be added through the use of plug-ins. This provides the ability to sort almost any data format imaginable!

There's an example on how to create custom sorting here: datatables.net/examples/plug-ins/s...


That's an interesting problem. Maybe modify the plugin to translate the input before it computes the sort? If it replaced, for example, "+" with "A" and "-" with "B" before computing the sort it would work, right?

I'm not sure this is the cleanest way to go about it but it's what comes to mind. It wouldn't be too tough to pop into the code and insert a .replace() in.


Hey! I've noticed that in this post you use "guys" as a reference to the entire community, which is not made up of only guys but a variety of community members.

I'm running an experiment and hope you'll participate. Would you consider changing "guys" to a more inclusive term? If you're open to that, please let me know when you've changed it and I'll delete this comment.

For more information and some alternate suggestions, see dev.to/seankilleen/a-quick-experim....

Thanks for considering!

Classic DEV Post from Jul 26 '19

🎩 JavaScript Enhanced Scss mixins! 🎩 concepts explained

In the next post we are going to explore CSS @apply to supercharge what we talk about here....

pavan ツ profile image

Sore eyes?

dev.to now has dark mode.

Go to the "misc" section of your settings and select night theme ❤️