Demo
Tablesorter & Filter: Hide Filter Row:
Filter any column:Filter (this works even if tablesorter & filter are disabled)
Rank |
First Name |
Last Name |
Age |
Total (filter disabled) |
Discount (sort disabled) |
Date |
|---|---|---|---|---|---|---|
| 1 | Philip Aaron Wong | Johnson Sr Esq | 25 | $5.95 | 22% | Jun 26, 2004 7:22 AM |
| 11 | Aaron | Hibert | 12 | $2.99 | 5% | Aug 21, 2009 12:21 PM |
| 12 | Brandon Clark | Henry Jr | 51 | $42.29 | 18% | Oct 13, 2000 1:15 PM |
| 111 | Peter | Parker | 28 | $9.99 | 20% | Jul 6, 2006 8:14 AM |
| 21 | John | Hood | 33 | $19.99 | 25% | Dec 10, 2002 5:14 AM |
| 013 | Clark | Kent Sr. | 18 | $15.89 | 44% | Jan 12, 2003 11:14 AM |
| 005 | Bruce | Almighty Esq | 45 | $153.19 | 44% | Jan 18, 2021 9:12 AM |
| 10 | Alex | Dumass | 13 | $5.29 | 4% | Jan 8, 2012 5:11 PM |
| 16 | Jim | Franco | 24 | $14.19 | 14% | Jan 14, 2004 11:23 AM |
| 166 | Bruce Lee | Evans | 22 | $13.19 | 11% | Jan 18, 2007 9:12 AM |
| 100 | Brenda Dexter | McMasters | 18 | $55.20 | 15% | Feb 12, 2010 7:23 PM |
| 55 | Dennis | Bronson | 65 | $123.00 | 32% | Jan 20, 2001 1:12 PM |
| 9 | Martha | delFuego | 25 | $22.09 | 17% | Jun 11, 2011 10:55 AM |
Javascript
$( function() {
var $table = $( '#table' ),
isEnabled = true, // tablesorter enabled
hideFilterRow = false, // hide filter row setting
// used by headerTitles widget
updateTooltips = function( $cell, txt ) {
if ( $cell.is( ':hover' ) ) {
$cell
.attr({ title : txt, 'original-title' : txt })
// hide, then show the tooltip to force updating & realignment
.tipsy( 'hide' )
.tipsy( 'show' );
}
return txt;
};
$table.tablesorter({
theme : 'blue',
widthFixed : true,
widgets : [ 'zebra', 'filter', 'headerTitles', 'toggle-ts' ],
widgetOptions : {
filter_reset : '.reset',
filter_external : '.search',
filter_columnFilters : true,
headerTitle_useAria : true,
headerTitle_tooltip : 'tooltip',
headerTitle_callback : updateTooltips,
// toggle-ts widget
toggleTS_hideFilterRow : hideFilterRow,
toggleTS_callback : function( c, isEnabled ) {
// update tooltips
c.$table.trigger( 'refreshHeaderTitle' );
}
}
});
// enable/disable tablesorter button
$( '.toggle' ).click( function() {
isEnabled = !isEnabled;
$( this ).text( isEnabled ? 'Disable' : 'Enable' );
$table.trigger( isEnabled ? 'enable' : 'disable' );
// If using the pager:
// $table.trigger( ( isEnabled ? 'enable' : 'disable' ) + 'Pager' );
// To reset sort or filter, include the following
// if ( !isEnabled ) {
// $table.trigger( 'sortReset' ).trigger( 'filterReset' );
// }
});
// demo: toggle filter row option
$( '.filterRow' ).click( function() {
hideFilterRow = !hideFilterRow;
$table[ 0 ].config.widgetOptions.toggleTS_hideFilterRow = hideFilterRow;
$( this ).text( '' + hideFilterRow );
});
// add tooltip
$( '.tooltip' ).tipsy({ gravity: 's' });
});
HTML
<p>
Tablesorter & Filter: <button type="button" class="toggle">Disable</button>
Hide Filter Row: <button type="button" class="filterRow">false</button>
</p>
Filter any column: <input class="search" type="search" data-column="any">
<p>Filter <button type="button" class="reset">Reset</button> (this works even if tablesorter & filter are disabled)</p>
<table id="table" class="tablesorter">
<thead>
<tr>
<th>Rank</th>
<th data-value="e">First Name</th>
<th>Last Name</th>
<th>Age</th>
<th class="filter-false">Total (filter disabled)</th>
<th class="sorter-false">Discount (sort disabled)</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<tr><td>1</td><td>Philip Aaron Wong</td><td>Johnson Sr Esq</td><td>25</td><td>$5.95</td><td>22%</td><td>Jun 26, 2004 7:22 AM</td></tr>
<tr><td>11</td><td>Aaron</td><td>Hibert</td><td>12</td><td>$2.99</td><td>5%</td><td>Aug 21, 2009 12:21 PM</td></tr>
<tr><td>12</td><td>Brandon Clark</td><td>Henry Jr</td><td>51</td><td>$42.29</td><td>18%</td><td>Oct 13, 2000 1:15 PM</td></tr>
<tr><td>111</td><td>Peter</td><td>Parker</td><td>28</td><td>$9.99</td><td>20%</td><td>Jul 6, 2006 8:14 AM</td></tr>
<tr><td>21</td><td>John</td><td>Hood</td><td>33</td><td>$19.99</td><td>25%</td><td>Dec 10, 2002 5:14 AM</td></tr>
<tr><td>013</td><td>Clark</td><td>Kent Sr.</td><td>18</td><td>$15.89</td><td>44%</td><td>Jan 12, 2003 11:14 AM</td></tr>
<tr><td>005</td><td>Bruce</td><td>Almighty Esq</td><td>45</td><td>$153.19</td><td>44%</td><td>Jan 18, 2021 9:12 AM</td></tr>
<tr><td>10</td><td>Alex</td><td>Dumass</td><td>13</td><td>$5.29</td><td>4%</td><td>Jan 8, 2012 5:11 PM</td></tr>
<tr><td>16</td><td>Jim</td><td>Franco</td><td>24</td><td>$14.19</td><td>14%</td><td>Jan 14, 2004 11:23 AM</td></tr>
<tr><td>166</td><td>Bruce Lee</td><td>Evans</td><td>22</td><td>$13.19</td><td>11%</td><td>Jan 18, 2007 9:12 AM</td></tr>
<tr><td>100</td><td>Brenda Dexter</td><td>McMasters</td><td>18</td><td>$55.20</td><td>15%</td><td>Feb 12, 2010 7:23 PM</td></tr>
<tr><td>55</td><td>Dennis</td><td>Bronson</td><td>65</td><td>$123.00</td><td>32%</td><td>Jan 20, 2001 1:12 PM</td></tr>
<tr><td>9</td><td>Martha</td><td>delFuego</td><td>25</td><td>$22.09</td><td>17%</td><td>Jun 11, 2011 10:55 AM</td></tr>
</tbody>
</table>