NOTE!
- As of tablesorter version 2.9+, this widget can no longer be applied to versions of tablesorter prior to version 2.8.
- Sort one or more columns, then reload the page to see that this widget remembers the last table sort.
- Sort saving requires the new "$.tablesorter.storage()" function included with the "jquery.tablesorter.widgets.js" file (v2.1).
- Because this widget uses jQuery's
parseJson()
function, it requires jQuery version 1.4.1+. - Added a
saveSortReset
method which only clears the stored information (v2.7.11).
Demo
Account # |
First Name |
Last Name |
Age |
Total |
Discount |
Diff |
---|---|---|---|---|---|---|
A43 | Peter | Parker | 28 | 9.99 | 20.3% | +3 |
A255 | John | Hood | 33 | 19.99 | 25.1% | -7 |
A33 | Clark | Kent | 18 | 15.89 | 44.2% | -15 |
A1 | Bruce | Almighty | 45 | 153.19 | 44% | +19 |
A102 | Bruce | Evans | 56 | 153.19 | 23% | +9 |
Rank |
Rating |
Title |
Votes |
---|---|---|---|
1. | 9.2 | The Shawshank Redemption (1994) | 734,327 |
2. | 9.2 | The Godfather (1972) | 548,857 |
3. | 9.0 | The Godfather: Part II (1974) | 346,072 |
4. | 8.9 | Pulp Fiction (1994) | 577,426 |
5. | 8.9 | The Good, the Bad and the Ugly (1966) | 229,564 |
Page Header
<link rel="stylesheet" href="css/blue/style.css">
<script src="js/jquery-latest.min.js"></script>
<script src="js/jquery.tablesorter.min.js"></script>
<script src="js/jquery.tablesorter.widgets.min.js"></script>
Javascript
$(function() {
// call the tablesorter plugin
$("table").tablesorter({
theme: 'blue',
// use save sort widget
widgets: ["saveSort", "zebra"]
});
$('button').click(function(){
$('table')
.trigger('saveSortReset') // clear saved sort
.trigger("sortReset"); // reset current table sort
return false;
});
});
HTML
<button type="button">Reset Sort</button>
<br>
<table class="tablesorter">
<thead>
<tr>
<th>Account #</th>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
<th>Total</th>
<th>Discount</th>
<th>Diff</th>
</tr>
</thead>
<tbody>
<tr>
<td>A43</td>
<td>Peter</td>
<td>Parker</td>
<td>28</td>
<td>9.99</td>
<td>20.3%</td>
<td>+3</td>
</tr>
<tr>
<td>A255</td>
<td>John</td>
<td>Hood</td>
<td>33</td>
<td>19.99</td>
<td>25.1%</td>
<td>-7</td>
</tr>
<tr>
<td>A33</td>
<td>Clark</td>
<td>Kent</td>
<td>18</td>
<td>15.89</td>
<td>44.2%</td>
<td>-15</td>
</tr>
<tr>
<td>A1</td>
<td>Bruce</td>
<td>Almighty</td>
<td>45</td>
<td>153.19</td>
<td>44%</td>
<td>+19</td>
</tr>
<tr>
<td>A102</td>
<td>Bruce</td>
<td>Evans</td>
<td>56</td>
<td>153.19</td>
<td>23%</td>
<td>+9</td>
</tr>
</tbody>
</table>
<!-- IMDB top 5 movies (3/2012) -->
<table>
<thead>
<tr>
<th>Rank</th>
<th>Rating</th>
<th class="sorter-ignoreArticles">Title</th>
<th>Votes</th>
</tr>
</thead>
<tbody>
<tr>
<td>1.</td>
<td>9.2</td>
<td><a href="http://www.imdb.com/title/tt0111161/">The Shawshank Redemption</a> (1994)</td>
<td>734,327</td>
</tr>
<tr>
<td>2.</td>
<td>9.2</td>
<td><a href="http://www.imdb.com/title/tt0068646/">The Godfather</a> (1972)</td>
<td>548,857</td>
</tr>
<tr>
<td>3.</td>
<td>9.0</td>
<td><a href="http://www.imdb.com/title/tt0071562/">The Godfather: Part II</a> (1974)</td>
<td>346,072</td>
</tr>
<tr>
<td>4.</td>
<td>8.9</td>
<td><a href="http://www.imdb.com/title/tt0110912/">Pulp Fiction</a> (1994)</td>
<td>577,426</td>
</tr>
<tr>
<td>5.</td>
<td>8.9</td>
<td><a href="http://www.imdb.com/title/tt0060196/">The Good, the Bad and the Ugly</a> (1966)</td>
<td>229,564</td>
</tr>
</tbody>
</table>