Sorting Table Columns with jQuery Table Sorter

Question

I was wondering if there's a way to sort columns with Table sorter
So that I could arrange the columns themselves according to some ID or anything.
alt text

So here for instance, If I want to sort the table so that the Apple column
Would be first, how do I do that?

Table Sorter doesn't have this built-in, are you tied to that plugin? There are others that will do this inherently, though none as lightweight that I can think of. — Nick Craver, Jun 27 '10 at 14:19

score 1 · Accepted Answer · answered Jun 27 '10 at 15:15

Demo: http://jsfiddle.net/fKMqD/

Code:

var rows = $('tr');

rows.eq(0).find('td').sort(function(a, b){

    return $.text([a]) > $.text([b]) ? 1: -1;

}).each(function(newIndex){

    var originalIndex = $(this).index();

    rows.each(function(){
        var td = $(this).find('td');
        if (originalIndex !== newIndex)
            td.eq(originalIndex).insertAfter(td.eq(newIndex));
    });

});

No plugins necessary.

score 1 · Answer 2 · answered Sep 02 '10 at 15:15

1

There is a plugin for jquery called datatable, it is very easy to use like most plugins and does everything you want on the fly with out all the extra work.

http://www.datatables.net/

check it out.

answered Sep 02 '10 at 15:15

zccool4718

29
1

score 0 · Answer 3 · answered Jun 28 '10 at 21:22

0

Maybe this could help:

http://james.padolsey.com/javascript/sorting-elements-with-jquery/

answered Jun 28 '10 at 21:22

Mark

32,293
33
107
137

score 0 · Answer 4 · answered Sep 03 '10 at 22:21

I got it working thusly

<html>
  <head>
    <script type="text/javascript" src="http://www.google.com/jsapi"></script>
    <script type="text/javascript">
      google.load("jquery", "1");
    </script>
    <script>
      $(function() {
        // Figure out the new column order.
        var isWas = {};
        $("tr").eq(0).find("td").each(function(index) {
          $(this).attr("was", index);
        }).sort(function(left, right) {
          // Change this line to change how you sort.
          return $(left).text() > $(right).text() ? 1 : -1;
        }).each(function(index) {
          isWas[index] = $(this).attr("was");
        });

        // Reorder the columns in every row.
        $("tr").each(function() {
          var tr = $(this);
          var tds = tr.find("td");
          var newOrder = [];
          for (var is = 0; is < tds.length; is++) {
            newOrder.push(tds.eq(isWas[is]));
          }
          for (var is = 0; is < tds.length; is++) {
            tr.append(newOrder[is]);
          }
        });
      });
    </script>
  </head>
  <body>
    <table>
      <tr><td>Potato</td><td>Tomato</td><td>Apple</td></tr>
      <tr><td>20g</td><td>10gr</td><td>40gr</td></tr>
    </table>
  </body>
</html>

Sorting Table Columns with jQuery Table Sorter

4 Answers4

Linked