NOTE!
- In tablesorter v2.18.1, you can now target a column by the class name of an element inside of a header; note that the span has the targeted class name in the first name column.
- In tablesorter v2.0.5 and older, only the metadata and headers options methods were available.
- In versions 2.3+, columns can be disabled using any of the following methods (they all do the same thing), in order of priority:
- jQuery data
data-sorter="false"
(see the Javascript block below on how to set it directly). - metadata
class="{ sorter: false }"
. This requires the metadata plugin. - headers option
headers : { 0 : { sorter: false } }
. - header class name
class="sorter-false"
.
- jQuery data
Demo
First Name |
Last Name |
Age |
Total |
Discount |
Date |
---|---|---|---|---|---|
Peter | Parker | 28 | $9.99 | 20% | Jul 6, 2006 8:14 AM |
John | Hood | 33 | $19.99 | 25% | Dec 10, 2002 5:14 AM |
Clark | Kent | 18 | $15.89 | 44% | Jan 12, 2003 11:14 AM |
Bruce | Almighty | 45 | $153.19 | 44% | Jan 18, 2001 9:12 AM |
Bruce | Evans | 22 | $13.19 | 11% | Jan 18, 2007 9:12 AM |
Javascript
$(function(){
// BONUS TIP: disable a column using jQuery data directly
// but do it before the table initializes
// this code disables the sort on the "Date" column
$("table thead th:eq(5)").data("sorter", false);
$("table").tablesorter({
theme : 'blue',
headers: {
// disable sorting of the first & second column - before we would have to had made two entries
// note that "first-name" is a class on the span INSIDE the first column th cell
'.first-name, .last-name' : {
// disable it by setting the property sorter to false
sorter: false
}
}
});
});
HTML
<table class="tablesorter">
<thead>
<tr>
<th><span class="first-name">First Name</span></th>
<th class="last-name">Last Name</th>
<th data-sorter="false">Age</th>
<th>Total</th>
<th class="sorter-false">Discount</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<tr>
<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>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>Clark</td>
<td>Kent</td>
<td>18</td>
<td>$15.89</td>
<td>44%</td>
<td>Jan 12, 2003 11:14 AM</td>
</tr>
<tr>
<td>Bruce</td>
<td>Almighty</td>
<td>45</td>
<td>$153.19</td>
<td>44%</td>
<td>Jan 18, 2001 9:12 AM</td>
</tr>
<tr>
<td>Bruce</td>
<td>Evans</td>
<td>22</td>
<td>$13.19</td>
<td>11%</td>
<td>Jan 18, 2007 9:12 AM</td>
</tr>
</tbody>
</table>