How to disable counting the row in pager plugin

[johnlouie04]

is there a way to disable the count of some row in pager plugin so that it will not displaying in the pagedisplay...

[camallen]

Just remove the <span class="pagedisplay"></span> from your HTML.

[johnlouie04]

What I mean is like this:

<table>
  <thead>
    <th>Table</h1>
    <th>Table</h1>
  </thead>
  <tbody>
    <tr class="count and display me"><td>count and display me</td><td>count and display me</td></tr>
    <tr class="ignore me or do not display"><td colspan="2">ignore me or do not display</td></tr>
  </tbody>
</table>

[camallen]

Sorry - I misunderstood your question.

You could look to not return these rows from the server or failing that override the code around here with custom numbers that you calculate, but this would be a hack.

I think you are trying to shoe horn functionality that isn't compatible with the library. I.e. why would you have a row that you show but do not count. And if you don't want to show it why is it in the table?

Good luck.

[TheSin-]

this seems to be more of a custom thing, I somewhat do the same, so lets say you have a table and one of the cols has a number in it, a sum of something but you only want every sum that is over say 30. I first give that col a class say "coltocheck", then I add a class "countme" to that tr (row). Then I run a count on that, I have a script to update the counts which I won't post, but it's the same type of idea I think. This really wouldn't be part of tablesorter since it's a specific table usage IMHO but thought I'd share how I handle it.

        $('table.tablesorter tbody tr td.coltocheck').each(function() {
                if (parseInt($(this).html()) >= 30)
                        $(this).parent().addClass('countme');
        });

[johnlouie04]

@camallen - It's ok.. What I'm planning to do is to have a show/hide for that.. something like this one

<table>
  <thead>
    <th>Data 1</th>
    <th>Data 2</th>
    <th>Data 3</th>
    <th>Data 4</th>
    <th>Data 5</th>
  </thead>
  <tbody>
    <tr>
      <td>data content</td>
      <td>data content</td>
      <td>data content</td>
      <td>data content</td>
      <td>show statistic</td>
    </tr>
    <tr>
      <td colspan="5">Show Statistics Here</td>
    </tr>
  </tbody>
</table>

so when you click the show statistic it will show the statistic data like that..

@TheSin- Thanks for the idea.. will work for that and see how is it working..

[camallen]

@johnlouie04

A quick thought, if you add the statistics row after creating the table then the row counts would be correct (until you re-evalutated the table) as they are computed on the table update / build events (when your row wouldn't be in the table).

So for instance you could tap into the table build / update event and after each event you compute your stats and insert them as their own row in JS.

Good luck!

[TheSin-]

now that I think about it more, if it's just a stats row you want why not add it to tfoot instead? then it won't be counted. Only tbody gets counted.

[Mottie]

It is as @TheSin- mentioned. Just add your extra statistic row into the tfoot (see this demo).

I did find a bug that will be fixed in the next update. It causes the pager to not properly hide child rows when the removeRows option is false; and breaking when the removeRows option is true... how'd I miss that? o.O

[Mottie]

Oh I guess I misunderstood the question too... to make the pager ignore a row, just make it a child row. It does attach it to the row above it, so keep that in mind.

<tr class="tablesorter-childRow">
    <td colspan="5">Show Statistics Here</td>
</tr>