NOTE!
- This functionality is new as of version 2.0.10 (not part of the original plugin).
- When a column is sorted numerically (
sorter:"digit") any text in that column will, by default, be given a zero value. Sort the last column (#9) to see the problem with this method. - Overall
stringTooption added in version 2.1.16. - String options changed in version 2.1.16; setting the value to:
"max"will treat any text in that column as a value greater than the max (more positive) value. Renamed from "max+"."min"will treat any text in that column as a value greater than the min (more negative) value. Renamed from "max-"."top"will always sort the text to the top of the column."bottom"will always sort the text to the bottom of the column."none"or"zero"will treat the text as if it has a value of zero.
- Individual columns can be modified by adding the following (they all do the same thing), set in order of priority:
- jQuery data
data-string="top". - metadata
class="{ string: 'top'}". This requires the metadata plugin. - headers option
headers : { 0 : { string : 'top' } }. - header class name
class="string-top". - Overall
stringTooption.
- jQuery data
- Sort columns three through eight to see how the sort has changed. Note that the text is sorted separately from the numeric values.
- The
emptyTooption defaults to bottom, so all empty cells will sort at the bottom of the table, except for the second column.
Demo
Account # |
Difference |
3: Ratings (max) |
4: Ratings (min) |
5: Change (max) |
6: Change (min) |
7: Change (top) |
8: Change (bottom) |
9: Change (zero) |
|---|---|---|---|---|---|---|---|---|
| A43 | -35 | 01 | 01 | -.1 | -.1 | -.1 | -.1 | -.1 |
| A255 | 33 | 02 | 02 | N/A #1 | N/A #1 | N/A #1 | N/A #1 | N/A #1 |
| A33 | 2 | 03 | 03 | N/A #2 | N/A #2 | N/A #2 | N/A #2 | N/A #2 |
| A1 | -5 | 04 | 04 | -8.4 | -8.4 | -8.4 | -8.4 | -8.4 |
| A102 | 99 | 05 | 05 | -2.2 | -2.2 | -2.2 | -2.2 | -2.2 |
| A10 | -1 | 06 | 06 | 97.4 | 97.4 | 97.4 | 97.4 | 97.4 |
| A02 | 0 | 07 | 07 | 23.6 | 23.6 | 23.6 | 23.6 | 23.6 |
| A55 | 44 | 11.4 | 11.4 | 11.4 | 11.4 | 11.4 | ||
| A87 | 04 | NR | NR | 5.2 | 5.2 | 5.2 | 5.2 | 5.2 |
| A012 | NR | NR |
Javascript
$(function() { // call the tablesorter plugin $("table").tablesorter({ theme : 'blue', // default strings setting stringTo: "max", // columns 2 & 3 (zero-based index) set using headers option // columns 4+ set using header class name: "string-max", "string-min", "string-top", "string-bottom" and "string-none" headers: { 1: { sorter: "digit", empty : "top" }, // sort empty cells to the top 2: { sorter: "digit", string: "max" }, // non-numeric content is treated as a MAX value 3: { sorter: "digit", string: "min" } // non-numeric content is treated as a MIN value } }); });
HTML
<table> <thead> <tr> <th>Account #</th> <th>Difference</th> <th>3: Ratings (max)</th> <th>4: Ratings (min)</th> <th class="string-max">5: Change (max)</th> <th class="string-min">6: Change (min)</th> <th class="string-top">7: Change (top)</th> <th class="string-bottom">8: Change (bottom)</th> <th class="string-none">9: Change (zero)</th> </tr> </thead> <tbody> <tr> <td>A43</td> <td>-35</td> <td>01</td> <td>01</td> <td>-.1</td> <td>-.1</td> <td>-.1</td> <td>-.1</td> <td>-.1</td> </tr> <tr> <td>A255</td> <td>33</td> <td>02</td> <td>02</td> <td>N/A #1</td> <td>N/A #1</td> <td>N/A #1</td> <td>N/A #1</td> <td>N/A #1</td> </tr> <tr> <td>A33</td> <td>2</td> <td>03</td> <td>03</td> <td>N/A #2</td> <td>N/A #2</td> <td>N/A #2</td> <td>N/A #2</td> <td>N/A #2</td> </tr> <tr> <td>A1</td> <td>-5</td> <td>04</td> <td>04</td> <td>-8.4</td> <td>-8.4</td> <td>-8.4</td> <td>-8.4</td> <td>-8.4</td> </tr> <tr> <td>A102</td> <td>99</td> <td>05</td> <td>05</td> <td>-2.2</td> <td>-2.2</td> <td>-2.2</td> <td>-2.2</td> <td>-2.2</td> </tr> <tr> <td>A10</td> <td>-1</td> <td>06</td> <td>06</td> <td>97.4</td> <td>97.4</td> <td>97.4</td> <td>97.4</td> <td>97.4</td> </tr> <tr> <td>A02</td> <td>0</td> <td>07</td> <td>07</td> <td>23.6</td> <td>23.6</td> <td>23.6</td> <td>23.6</td> <td>23.6</td> </tr> <tr> <td>A55</td> <td>44</td> <td></td> <td></td> <td>11.4</td> <td>11.4</td> <td>11.4</td> <td>11.4</td> <td>11.4</td> </tr> <tr> <td>A87</td> <td>04</td> <td>NR</td> <td>NR</td> <td>5.2</td> <td>5.2</td> <td>5.2</td> <td>5.2</td> <td>5.2</td> </tr> <tr> <td>A012</td> <td></td> <td>NR</td> <td>NR</td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> </tbody> </table>