NOTE!
- This widget can be applied to the original plugin. The code is in the "jquery.tablesorter.widgets.js" file.
- 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. New! 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="http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.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 }); });
HTML
<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>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>