ansaurus

Question

Answer 1

+2 A:

I think the answer to #1 is that you have blank fields for some numerical columns causing the tablesorter to detect that column as a "string" column.

Eric Wendelin 2008-11-19 18:00:48

-1 doesn't have a solution, which is to explicitly specify a sorting method. see my answer.

antony.trupe 2009-06-09 04:21:09

Answer 2

A:

Blank fields could be a problem (e.g they are not 0), try using custom parser which removes any non-numericals and forces values to integers (example: http://paste.pocoo.org/show/90863/ )
Put your 'total' row inside a <tfoot> </tfoot> tag right before the end of the table

duckyflip 2008-11-19 18:04:05

Answer 3

+3 A:

I would suggest using some Javascript to remove the last row from the table. Add a footer and then re-add the removed row from the table. To solve the issue with empty data in a numeric cell you may need to add your own custom parser.

   $(function() {
       $('#communityStats').append("<tfoot></tfoot>");
       $('#communityStats > tr:last').remove()
                                     .appendTo('#communityStats > tfoot');
       $('#communityStats').tablesorter();
   });

tvanfosson 2008-11-19 18:10:22

-1 this is a very kloodgy solution

antony.trupe 2009-06-09 04:19:59

But it meets the requirement and doesn't rely on server side changes which the OP indicates can't be made.

tvanfosson 2009-06-09 11:59:30

@tvanfosson true. vote removed

antony.trupe 2009-06-09 13:11:44

Answer 4

+15 A:

The first problem is due to the fact that the table sorter auto detects the column to a 'text'-column (probably because the empty cells). To solve this use this code to initialize the tablesorter and set all the field to either digit or currency depending on the data:

<script type="text/javascript" >
jQuery(document).ready(function() 
{ 
    jQuery("#communityStats").tablesorter({ 
        headers: { 2: { sorter:'digit' } , 
                   3: { sorter:'digit' } ,
                   4: { sorter:'digit' } ,
                   5: { sorter:'digit' } ,
                   6: { sorter:'digit' } ,
                   7: { sorter:'digit' } ,
                   8: { sorter:'currency' } ,
                   9: { sorter:'currency' } ,
                   10: { sorter:'currency' } ,
                   11: { sorter:'currency' } 
                 } 
    }); 
});
</script>

Tjofras 2008-11-19 18:12:58

-1 overkill. much more elegant to use metadata and specify the sorting algorithm tablesorter should use inline. see my answer below.

antony.trupe 2009-06-09 04:22:21

@Antony Trupe but as specified in question does he has control to put meta-data in table html generated by "displaytag" library

TheVillageIdiot 2009-06-09 04:43:18

@The Village Idiot then he's screwed(ie will have kludgy code)

antony.trupe 2009-06-09 13:10:38

Remember to add jquery.metadata.js (seperate project) if you want to set these things seperatly. Not mentioned directly in documentation i believe.

Soraz 2010-08-06 10:04:38

Answer 5

A:

Can someone tell me whether this table sorter could be like this http://joomlicious.com/mootable/'>http://joomlicious.com/mootable/

I need fixed/variable height of table which user can change as per his wish along with sorting feature.

Thanks in advance

2008-12-08 12:11:44

Answer 6

A:

I found that the following will work with unrecognized numeric (digit) columns. It appears that 0 is considered text by the current version (2.0.3) of tablesorter.

Including the sample from tvanfosson, this script at the bottom of your page would move your last row from the footer which prevents it from being sorted with the data within tbody and would force the sorter to use a numeric sort rather than the text sort it is using as you described.

$(document).ready(function() {
  $('#communityStats').append("<tfoot></tfoot>");
  $('#communityStats > tr:last').remove()
    .appendTo('#communityStats > tfoot');

  $("#communityStats").tablesorter({
     debug: true,
     headers: { 
       0:{sorter: 'digit'}
       ...
       10:{sorter: 'digit'}
     }
  });

});

catalpa 2009-05-19 18:27:08

the debug setting can be removed, but it will help you see what the code is setting as each column's parser. If you have firebug installed, it prints to the console.

catalpa 2009-05-19 18:30:26

Answer 7

A:

I am having a problem with sorting currencies with thousand separator.. ex 14,566.50 is sorted as 14,556 and not 14556..

Is this fixable?

2009-05-28 09:05:27

Answer 8

A:

I want to have talbe sorting + Fixed header any idea/Plugins

2009-06-18 01:51:27

Answer 9

A:

Looking for a Fixed header, frozen column, sortable table any pointers will be helpful.

cheetos 2009-12-14 20:01:25

Answer 10

A:

em using Jquery tableSort ,

i need know can I sort gridView ,by clicking button out side the grid ?

means it's working fine on click particular column but here is the to sort grid by clicking on a button , out side the grid....?

please help me if any body knows?

Moazzam ali 2010-02-26 18:48:06

Answer 11

A:

fixed header for tablesorter plugin :

//css//
table.tablesorter thead {
position: fixed;
top: 35px; // 
}
//js//
function tableFixedHeader() {
   var tdUnit = $('.tablesorter tbody tr:first').children('td').length;
   for(var i=0;i<tdUnit; i++) {
     $('.tablesorter thead th').eq(i).width($('.tablesorter tbody td').eq(i).width());
   }
   $('.tablesorter').css('margin-top',$('.tablesorter thead').height()); 
}
//html
<div id="container">
   <div id="topmenu" style="height:35px;">some buttons</div>
   <div id="tablelist" style="width:100%;overflow:auto;">
      <table class="tablesorterw">.....</table>
   </div>
</div>

kemal baylan 2010-03-17 12:18:26

ansaurus

tags:

views:

answers:

JQuery tablesorter problem

related questions