Other languages:

Tables can be made sortable via client-side JavaScript with class="sortable" (in combination with the usual formatting: class="wikitable sortable"). This works in MediaWiki 1.9 and above, which is installed in all Wikimedia projects.

A table that is sortable is identified by arrows to the right of the header in a header cell. A sortable table may be sortable by one or more columns in the table. Clicking an arrow sorts the table rows based on the selected column. Repeated clicking of an arrow changes the sort state in this sequence: Ascending, Descending, Unsorted.

Shift-clicking the arrows of other columns will trigger a secondary sort based on the most recent column on which the shift-click occurred. NB: Shift-clicking capability extends to tertiary and beyond.

Links and other wiki-markup are not possible in headers.

JavaScript edit

The JavaScript code jquery.tablesorter.js (source) of the tablesorter is loaded by the ResourceLoader. Some sites may have a page MediaWiki:Common.js which adds and overrides some code. Browsers need to support JavaScript and it needs to be enabled for sorting to work.

Sort modes edit

The way items are sorted depends on the data type of the first rows. To determine the data type, the first 5 non-blank rows below the header are tested after loading the page and the most appropriate format is chosen. Mismatches are possible. The sort order of a column can be forced. See the relevant section farther down.

Tags such as span or sup are ignored when determining data type, but reference numbers and additional visible comments are not ignored today.

Dates edit

Various date formats are supported, including those with localized month names. On the German Wikipedia, "16. März 2010" is correctly sorted as 2010-03-16

Most other numerical formats are supported as well, including those with different separators (such as . , ' or / ); On English Wikipedias dates are treated as US-Dates (eg. month-day-year) per default.

Numbers edit

The script can recognize numbers with different decimal separators (. and ,) as well as e/E numbers. However, numbers will be sorted alphanumerically (with 9 sorted after 10) unless this default behaviour is overridden. (See below.)

Text edit

Text is compared at client-side JavaScript since July 2019 (Commit) with Intl.Collator. This sort accented characters depend on PageContentLanguage correctly. But sort of special characters is depend on Browser implementation. Example for Intl.Collator(de):

Firefox52.9: _-—,;:!?.'"()[]{}§@*/\&#%^+±<=>|~∞¢$£¥€0…9²³aä…eé…ö…ß…ü…z
IE11:      '-—!"#$%&()*,./:;?@[\]^_{|}~¢£¥€+<=>±≤≥§♠0²³9∞aä…eé…ö…ß…ü…z

Only Android systems use the old sort mode with UTF-16 coded characters. Any accented/special characters follow after the basic latin alphabet. This can be changed site wide by posting code like the following inside the MediaWiki:Common.js:

mw.config.set('tableSorterCollation', {'ä':'a', 'ß':'ss', 'þ':'th', 'aa':'å'});

Afterwards, all 'Ä' and 'ä' will be sorted as if they were an 'a' etc. Partial list showing the default order:
! " # $ % & ' ( ) * + , - . / 0 9 : ; < = > ? @ [ \ ] ^ _ ` A Z a z { | } ~ É é —

Forcing the sort mode for a column edit

The sort mode can be manually specified by putting data-sort-type="…" inside the header of the respective row. This functionality is based on tablesorter.com (webarchive). The following (case-insensitive) values are valid for data-sort-type:

  • text
  • number
  • IPAddress
  • currency
  • url
  • isoDate
  • usLongDate
  • date
  • time

Example:

{|class="wikitable sortable"
!data-sort-type="date"|Date!!Name!!Height!!data-sort-type="number"|Salary
|-
|01.10.1977||Smith||1.85||1,000.000
|-
|11.6.1972||Ray||1.89||900.000
|-
|1.9.1992||Bianchi||1.72||2,000.50
|}
Date Name Height Salary
01.10.1977 Smith 1.85 1,000.000
11.6.1972 Ray 1.89 900.000
1.9.1992 Bianchi 1.72 2,000.50

Specifying a sort key edit

Sometimes the value of a cell is not correctly parsed or one wants to sort the row in a special way. (e.g. a cell containing 'John Smith' should actually be sorted as 'Smith' and not as 'John') This can be easily achieved by setting the data-sort-value attribute.

Wiki markup:

{|class="wikitable sortable"
!Name and Surname!!Height
|-
|data-sort-value="Smith, John"|John Smith||1.85
|-
|data-sort-value="Ray, Ian"|Ian Ray||1.89
|-
|data-sort-value="Bianchi, Zachary"|Zachary Bianchi||1.72
|}

This gives:

Name and Surname Height
John Smith 1.85
Ian Ray 1.89
Zachary Bianchi 1.72

Note, however, that this makes use of a new feature in HTML5, which is enabled by default in MediaWiki (including WMF wikis since September 2012 cfr. bugzilla:27478). The old version was to set hidden sort key with w:Template:Sort. See also mediawiki.org.

Controlling sorting and display edit

If some Text undesired for sorting but needed for display, force the sort mode with data-sort-type="…" and write text after values (e.g. "200 approx", or reference tags "100[1]"). Empty cell is treated as "-Infinity" when sorting numerically.

In the case of a cell containing a range of dates or numbers (e.g. from 2 to 5), specify a data-sort-value="…".

Examples edit

The first column demonstrates how plain numbers are detected and sorted as numbers. The second column shows that with data-sort-type="number" in table header more content detected as numbers. The fourth column shows that with data-sort-value="…" a numeric sortvalue is defined, independent of the cell content.

numbers data-sort-type="number" data-sort-type="number"
-8e3 -8 e3 -8 e3
-3e-3 -3 e-3 -3 e-3
2.000 2-5 km² data-sort-value="3.5" 2-5 km²
3.99 3.99 km² 3.99 km²
4 4 km² 4 km²
90 % 90 Percent data-sort-value="90" about 90 Percent
1E2 100[1] 100[1]
1,000,000.0 1 000 000.0 data-sort-value="1e6" one Million

The thousand separator(,) and digits separator(.) depends on language specific configuration of the Mediawiki software. Currency symbols before or after numbers or the %-symbol will be sorted numerical.

currencies
$ 9
$ 80
$ 70
$ 600
currencies
9 €
80 €
70 €
600 €
currencies
£ 9
£ 80
£ 70
£ 600
currencies
¥ 9
¥ 80
¥ 70
¥ 600
percent
9 %
80 %
70 %
600 %
numbers
−7e270
-1.4285714285714E-13
999e9
7e270

Secondary sort key edit

It is possible to sort by column A (primary sort key), while for equal values in column A, sort by column B (secondary sort key): first sort by A by clicking the sort button of column A once or twice, then, while holding the shift-key, click the sort button of column B once or twice.

Example:

First click on column Text and then, while holding the shift-key, on Numbers, you'll see that the ordering is on Text (1), Numbers (2).

Numbers Text Dates Currency More text
4 a 01.Jan.2005 4.20 row 1
5 a 05/12/2006 7.15 row 2
1 b 02-02-2004 5.00 row 3
1 a 02-02-2004 5.00 row 4
2 x 13-apr-2005 row 5
2 a 13-apr-2005 row 6
3 a 17.aug.2006 6.50 row 7
3 z 25.aug.2006 2.30 row 8
3 z 28.aug.2006 5.50 row 9
3 z 31.aug.2006 3.77 row 10
3 z 01.sep.2006 1.50 row 11
Bottom

Additional features edit

Excluding the last row from sorting edit

Sometimes it is helpful to exclude the last row of a table from the sorting process. This can be achieved by setting class="sortbottom" on the last row. Declaring the last row as a footer (with !) will also exclude it from sorting.

Wiki markup:

{|class="wikitable sortable"
!Name!!Surname!!Height
|-
|John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|- class="sortbottom"
! !!Average:||1.82
|}

What it looks like in your browser:

Name Surname Height
John Smith 1.85
Ron Ray 1.89
Mario Bianchi 1.72
Average: 1.82

Excluding the first row from sorting edit

The same can be applied for first rows as well, by setting class="sorttop".

Wiki markup:

{|class="wikitable sortable"
!Name!!Surname!!Height
|- class="sorttop"
! !!Average:||1.82
|-
|John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|}
Name Surname Height
Average: 1.82
John Smith 1.85
Ron Ray 1.89
Mario Bianchi 1.72

Making a column unsortable edit

If you want a specific column not to be sortable, specify class="unsortable" in the attributes of its header cell.

Wiki markup:

{|class="wikitable sortable"
!Numbers!!Alphabet!!Dates!!Currency!!class="unsortable"|Unsortable
|-
|1||Z||02-02-2004||5.00||This
|-
|2||y||13-apr-2005||||Column
|-
|3||X||17.aug.2006||6.50||Is
|-
|4||w||01.Jan.2005||4.20||Unsortable
|-
|5||V||05/12/2006||7.15||See?
|-
!Total: 15!!!!!!Total: 29.55!!
|-
|}

What it looks like in your browser:

Numbers Alphabet Dates Currency Unsortable
1 Z 02-02-2004 5.00 This
2 y 13-apr-2005 Column
3 X 17.aug.2006 6.50 Is
4 w 01.Jan.2005 4.20 Unsortable
5 V 05/12/2006 7.15 See?
Total: 15 Total: 29.55 Original example

Keeping some rows together edit

If you want that a row will always be below the row just above it and will follow it around, no matter how the sorting is applied, specify class="expand-child" in the attribute of this row.

Wiki markup:

{| class="wikitable sortable"
! style="width:9em"| Country !!data-sort-type="number"| Area
|-
| France
| 674 843 km²
|- class="expand-child" style="font-size:85%; line-height:1.2; color:gray"
| colspan="2" | In Paris is the Eiffel Tower.
|-
| U.K.
| 242 495 km²
|- class="expand-child" style="font-size:85%; line-height:1.2; color:gray"
| colspan="2" | In the U.K. you cannot pay with euros.
|- class="expand-child" style="font-size:85%; line-height:1.2; color:gray"
| colspan="2" | And you drive on the left side of the road.
|-
| Germany
| 357 168 km² 
|- class="expand-child" style="font-size:85%; line-height:1.2; color:gray"
| colspan="2" | Germany includes the former DDR.
|}

What it looks like in your browser:

Country Area
France 674 843 km²
In Paris is the Eiffel Tower.
U.K. 242 495 km²
In the U.K. you cannot pay with euros.
And you drive on the left side of the road.
Germany 357 168 km²
Germany includes the former DDR.

If you put in data-sort-value the same content as above row, keep this rows also together. The original mutual order of these rows is preserved. A better way for this is class expand-child, see above #Keeping some rows together.

Example where data-sort-value is used is the case for the rows about the Netherlands:

{|class="wikitable sortable"
!Country/province!!Capital
|-
|France||Paris
|-
|Netherlands||Amsterdam
|-
|data-sort-value=Netherlands|South Holland||data-sort-value=Amsterdam|The Hague
|-
|U.K.||London
|}
Country/province Capital
France Paris
Netherlands Amsterdam
South Holland The Hague
U.K. London

Special dates edit

For years BC we can use, for example, !9937-09-23 for -0062-09-23 (subtract the year number BC from 10000, or the absolute value of the astronomical year from 9999).

If a table column contains any or all incomplete dates, this will not cause sorting problems. If only a year and month are given, that incomplete date is positioned alphabetically before the first day of the month in question. Likewise, if only a year is given, the date is positioned before the first month or day given for that year.

Use of #time edit

Using parser function #time we can put <span style="display:none">&{{#expr:3e11+{{#time:U|..}}}}</span> in front of the displayed date. This works in the range 1 Jan 111, 00:00:00 through 31 Dec 9999, 23:59:59 for the proleptic Gregorian calendar. The added value makes all values positive and the same length (if scientific format would show up an additional step is needed to prevent this). The "&" forces string sort mode.

Dates and times can be entered in any php date/time format. Note that when we have just a year, a month (typically Jan) must be added in the hidden part.

Example using Help:Sorting/date:

input date text date and time as interpreted, with hidden sort key input with visible sort key input with hidden sort key Unix time
010203 &301710810123 19 Mar 2024 01:02:03 &301710810123 010203 &301710810123 010203 1710810123
1/2 &301704153600 02 Jan 2024 00:00:00 &301704153600 1/2 &301704153600 1/2 1704153600
1/2/3 &301041465600 02 Jan 2003 00:00:00 &301041465600 1/2/3 &301041465600 1/2/3 1041465600
1-2-2003 &301044057600 01 Feb 2003 00:00:00 &301044057600 1-2-2003 &301044057600 1-2-2003 1044057600
1-2-3 &300981158400 03 Feb 2001 00:00:00 &300981158400 1-2-3 &300981158400 1-2-3 981158400
2007 &301167609600 01 Jan 2007 00:00:00 &301167609600 2007 &301167609600 2007 1167609600
1 Jan 111, 00:00:00 &241335609600 01 Jan 0111 00:00:00 &241335609600 1 Jan 111, 00:00:00 &241335609600 1 Jan 111, 00:00:00 -58664390400
31 Dec 9999, 23:59:59 &553402300799 31 Dec 9999 23:59:59 &553402300799 31 Dec 9999, 23:59:59 &553402300799 31 Dec 9999, 23:59:59 253402300799
Sep 1970 &300020995200 01 Sep 1970 00:00:00 &300020995200 Sep 1970 &300020995200 Sep 1970 20995200
1970 &300000000000 01 Jan 1970 00:00:00 &300000000000 1970 &300000000000 1970 0
Jun 2007 or later &301180656000 01 Jun 2007 00:00:00 or later &301180656000 Jun 2007 or later &301180656000 Jun 2007 or later 1180656000 or later
Jun 2007 perhaps earlier &301180656000 01 Jun 2007 00:00:00 perhaps earlier &301180656000 Jun 2007 perhaps earlier &301180656000 Jun 2007 perhaps earlier 1180656000 perhaps earlier
2007-6 &301180656000 01 Jun 2007 00:00:00 &301180656000 2007-6 &301180656000 2007-6 1180656000
Jun 2007 &301180656000 01 Jun 2007 00:00:00 &301180656000 Jun 2007 &301180656000 Jun 2007 1180656000
4 Jun 2007 &301180915200 04 Jun 2007 00:00:00 &301180915200 4 Jun 2007 &301180915200 4 Jun 2007 1180915200
3 Jul 2007 &301183420800 03 Jul 2007 00:00:00 &301183420800 3 Jul 2007 &301183420800 3 Jul 2007 1183420800
12 Aug 2006 &301155340800 12 Aug 2006 00:00:00 &301155340800 12 Aug 2006 &301155340800 12 Aug 2006 1155340800
1 Mar 2006 -1day &301141084800 28 Feb 2006 00:00:00 &301141084800 1 Mar 2006 -1day &301141084800 1 Mar 2006 -1day 1141084800
1 Mar 2008 -1day &301204243200 29 Feb 2008 00:00:00 &301204243200 1 Mar 2008 -1day &301204243200 1 Mar 2008 -1day 1204243200
1 Mar 2010 -1day &301267315200 28 Feb 2010 00:00:00 &301267315200 1 Mar 2010 -1day &301267315200 1 Mar 2010 -1day 1267315200
1 Mar 1900 -1day &297796022400 28 Feb 1900 00:00:00 &297796022400 1 Mar 1900 -1day &297796022400 1 Mar 1900 -1day -2203977600
1 Mar 1600 -1day &288329001600 29 Feb 1600 00:00:00 &288329001600 1 Mar 1600 -1day &288329001600 1 Mar 1600 -1day -11670998400
Jun 1607 &288557875200 01 Jun 1607 00:00:00 &288557875200 Jun 1607 &288557875200 Jun 1607 -11442124800
20240319092309 &301710840189 19 Mar 2024 09:23:09 &301710840189 20240319092309 &301710840189 20240319092309 1710840189
yesterday &301710720000 18 Mar 2024 00:00:00 &301710720000 yesterday &301710720000 yesterday 1710720000
today &301710806400 19 Mar 2024 00:00:00 &301710806400 today &301710806400 today 1710806400
tomorrow &301710892800 20 Mar 2024 00:00:00 &301710892800 tomorrow &301710892800 tomorrow 1710892800
1week &301711444990 26 Mar 2024 09:23:10 &301711444990 1week &301711444990 1week 1711444990
-1week &301710235390 12 Mar 2024 09:23:10 &301710235390 -1week &301710235390 -1week 1710235390
1day &301710926590 20 Mar 2024 09:23:10 &301710926590 1day &301710926590 1day 1710926590
-1day &301710753790 18 Mar 2024 09:23:10 &301710753790 -1day &301710753790 -1day 1710753790
1month &301713518590 19 Apr 2024 09:23:10 &301713518590 1month &301713518590 1month 1713518590
-1month &301708334590 19 Feb 2024 09:23:10 &301708334590 -1month &301708334590 -1month 1708334590
1year &301742376190 19 Mar 2025 09:23:10 &301742376190 1year &301742376190 1year 1742376190
-1year &301679217790 19 Mar 2023 09:23:10 &301679217790 -1year &301679217790 -1year 1679217790
1000year &333267748990 19 Mar 3024 09:23:10 &333267748990 1000year &333267748990 1000year 33267748990
10000month &328008321790 19 Jul 2857 09:23:10 &328008321790 10000month &328008321790 10000month 28008321790
1000000day &388110840190 14 Feb 4762 09:23:10 &388110840190 1000000day &388110840190 1000000day 88110840190
10000000hour &337710840190 04 Jan 3165 01:23:10 &337710840190 10000000hour &337710840190 10000000hour 37710840190
1000000000minute &361710840190 16 Jul 3925 20:03:10 &361710840190 1000000000minute &361710840190 1000000000minute 61710840190
100000000000second &401710840190 01 Feb 5193 19:09:50 &401710840190 100000000000second &401710840190 100000000000second 101710840190
7980year &Expression error: Unexpected < operator. Error: #time only supports years up to 9999. &Expression error: Unexpected < operator. 7980year &Expression error: Unexpected < operator. 7980year Error: #time only supports years up to 9999.
-1890year &242068142590 19 Mar 0134 09:23:10 &242068142590 -1890year &242068142590 -1890year -57931857410
Mon &301711324800 25 Mar 2024 00:00:00 &301711324800 Mon &301711324800 Mon 1711324800
Tue &301710806400 19 Mar 2024 00:00:00 &301710806400 Tue &301710806400 Tue 1710806400
Wed &301710892800 20 Mar 2024 00:00:00 &301710892800 Wed &301710892800 Wed 1710892800
Thu &301710979200 21 Mar 2024 00:00:00 &301710979200 Thu &301710979200 Thu 1710979200
Fri &301711065600 22 Mar 2024 00:00:00 &301711065600 Fri &301711065600 Fri 1711065600
Sat &301711152000 23 Mar 2024 00:00:00 &301711152000 Sat &301711152000 Sat 1711152000
Sun &301711238400 24 Mar 2024 00:00:00 &301711238400 Sun &301711238400 Sun 1711238400
&Expression error: Unexpected < operator. Error: Invalid time. &Expression error: Unexpected < operator. &Expression error: Unexpected < operator. Error: Invalid time.
unknown &Expression error: Unexpected < operator. Error: Invalid time. &Expression error: Unexpected < operator. unknown &Expression error: Unexpected < operator. unknown Error: Invalid time.

To use dates before the year 111, add a multiple of 400, e.g. 6000, to all years, this effectively shifts the range to 1 Jan -5889, 00:00:00 through 31 Dec 3999, 23:59:59, without changing the calendar.

See also:

  • w:Template:Dts - sorting a table by a date column
  • Template:Sd - shows weekday in a separate column before date, and link all dates

Cell spanning multiple rows/cells edit

A cell which spans more than one row or column is treated as if it were multiple cells with the same value.

rowspan
Date Name Height
01.10.1977 Smith 1.85
11.06.1972 Adams
01.09.1992 Bianchi 1.72
colspan
A B C
A 2 1
B 1 3
C 2

As of MediaWiki Version 1.26 wmf23 (Sept. 2015), sorting of colspanned cells works correctly. Also, missing cells at the end of a row will change after first sort into cells with empty content.

Colspanned cells edit

The auto-detection of sort mode is done for colspanned cells for each column separately. Defining the sort mode by putting data-sort-type inside the header will specify this sort mode for all colspanned columns.

To use separate sort keys for each column in a colspanned cell, use the CSS hack described here: To allow sorting, the formal number of cells in each row should be equal (If not, all columns become sortable. This should apply at least for the number of cells up to and including the last sortable column.) However, with a CSS hack the number of cells shown in a row can differ from the formal number of cells. For example, two formal cells can be shown as one by specifying a width for the first column, shifting the contents of the second cell to the left, increasing its width by the same amount, and hiding the cell border that would normally be visible. Hidden sort keys can be used to control the sort order of particular rows with respect to each column.

Example:

Country Capital
France Paris
Z M
Sorting with respect to the first column this row sorts like Z, with respect to the second column like M
U.K. London

Static column edit

A static column, e.g. with row numbers, can be obtained with two side-by-side tables with for each row the same height set in both tables:

Number
1
2
Country Capital
The Netherlands Amsterdam (although The Hague is the seat of government)
France Paris

The style can be adjusted to make it appear as a single table. If for some row the height of that row is too small for the text in a cell on one of the sides, the browser increases it, and there is no longer a match.

Default order edit

It is not possible to make a table appear sorted by a certain column without the user clicking on it. By default, the rows of a table always appear in the same order as in the wikitext. If you want a table to appear sorted by a certain column, you must sort the wikitext itself in that order; see the next section for one way to do this.

Sorting the wikitext of a table edit

Sorting the wikitext itself, thus creating a new default sort order, can be done semi-automatically as follows. Take the wikitext of the table without top and bottom lines. Use "find and replace" to replace the cell separators with special code not containing "|". If there are pipes in the table cells, replace all pipes by some code, and replace that code with a newline in front of it (originating from the code for the start of a new row) back. Apply mw:Module:Sort (see mw:Module talk:Sort) at mw:Special:ExpandTemplates by putting: {{#invoke:Sort|f|{{!}}-
{{!}} (with the newline) before, and }} after the wikitext, to sort the items between the pipes, with the desired separator in the result. Discard the items at the start containing "-" and a newline. Restore the cell separators and the pipes in the cells by replacing the temporary codes for them. Readd the top and bottom lines.

This method sorts by the wikitext of the rows, so in principal by the first column (and the second as secondary key), although wikitext codes in the cells of the first column before the content can affect the order.

See Help:Sorting#Maintaining tables sorted by rank for sorting tables by a different column.

Using JavaScript to trigger client-side table sorting edit

An addition to MediaWiki:Common.js can be used to "re-sort" a table automatically on the client side when the page loads (as if the user had clicked the header.) The example below sorts all the tables on a set of pages by the first column (see the Tablesorter documentation for syntax.)

Note : This appears to break sorting by clicking on headers. It sorts ascending on the clicked on header, but won't sort the other way when clicked on again

function isSortedTablePage() {
    return ( wgPageName == "Page_To_Sort"  || wgPageName == "Other_Page_To_Sort" );
}

jQuery( document ).ready( function( $ ) {
    // wrapped in "mw.loader.using" so this doesn't execute until Tablesorter has loaded
    mw.loader.using( 'jquery.tablesorter', function() {
        if( isSortedTablePage() ) $('table.sortable').tablesorter( {sortList: [ { 0: 'asc'} ]} )
        // or look for tables with an ID attribute of "sortMe" on any page
        // $( '#sortMe' ).tablesorter( {sortList: [ { 0: 'asc'} ]} )
    } );
} );

Basic alphabetic sorting order edit

demo
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
9
:
;
<
=
>
?
@
[
\
]
^
_
`
A
Z
a
z
A1
Z1
a1
z1
{
|
}
~
É
é
É1
é1

The two-character entries such as A1 demonstrate that A and a are at the same position.

This is not a fully alphabetic sort order: letter case is first folded to lowercase using a basic 1-to-1 conversion table (limited to the Basic Multilingual Plane of Unicode, and whose coverage and completeness still depends on browser versions and on their current implementation of the versioned Unicode Character Database), but letters with diacritics (and all other digits, symbols or special whitespaces or format control characters) will still sort according to the binary encoding of the casefolded letter, using the binary order of the UTF-16 code units (exposed and seen in Javascript through the parsed HTML DOM), but not the binary order of UTF-8 code units in the HTML page, and not of codepoints as one could also expect for encoded characters in supplementary planes).

In addition, no normalization of the Unicode text is being performed (so canonically equivalent strings, that should compare equal or with only very minor binary difference, may sometimes compare very far away, with completely different strings interleaved between them). For this reason, MediaWiki pages should always be encoded with their text in the Normalized Form C (preComposed), as recommended in the HTML standards.

As of today, an UCA-based sort is still not implemented in the client-side Javascript code, but some wikis are implementing a limited form of multilevel collation using custom basic replacement rules tuned for specific languages.

Server issue edit

It has been observed that the MediaWiki code on the server replaces a regular space before "!" by a non-breaking space &#160;, affecting the sorting order. To avoid this, this blank space can be coded as &#32;, or the exclamation mark may be surrounded by <nowiki> and </nowiki> tags. This is to comply with French typographic rules, where exclamation marks (and a few other punctuations) must be preceded (or sometimes followed) by a space (preferably narrow) which must still be unbreakable when it is effectively needed and present, the substitution being performed as an convenient editing facility of the Wiki code for cases that are very frequent within many texts.

Persistent sort states using cookies edit

Adding this snippet to your MediaWiki:Common.js page will make the sortable tables remember their columns sort states in a cookie so they look the same next time the page is visited. Each sortable table must have a unique id attribute for its state to be stored in the cookie.

addOnloadHook( function() {
    jQuery('.sortable').each( function() {
        var id = jQuery(this).attr('id');
        document.shCookie = getCookie('sortheader-'+id);
        document.sortheaderId = 0;
        jQuery('#'+id+' a.sortheader').each( function() {
            var id = jQuery(this).parent().parent().parent().parent().attr('id');
            var sh = document.sortheaderId++;
            if( sh+100 == document.shCookie ) { ts_resortTable(this); ts_resortTable(this); }
            if( sh == document.shCookie ) { ts_resortTable(this); sh += 100; }
            jQuery(this).bind('click', {id: id, sh: sh}, function(e) {
                setCookie('sortheader-'+e.data.id, e.data.sh, 1);
                e.data.sh += e.data.sh < 100 ? 100 : -100;
            });
        });
    });
});

function setCookie(c_name,value,exdays) {
    var exdate=new Date();
    exdate.setDate(exdate.getDate() + exdays);
    var c_value=escape(value) + ((exdays==null) ? "" : "; expires="+exdate.toUTCString());
    document.cookie=c_name + "=" + c_value;
}

function getCookie(c_name) {
    var i,x,y,ARRcookies=document.cookie.split(";");
    for (i=0;i<ARRcookies.length;i++) {
        x=ARRcookies[i].substr(0,ARRcookies[i].indexOf("="));
        y=ARRcookies[i].substr(ARRcookies[i].indexOf("=")+1);
        x=x.replace(/^\s+|\s+$/g,"");
        if (x==c_name) return unescape(y);
    }
}

See also edit

Examples elsewhere:


Links to other help pages

Help contents
Meta · Wikinews · Wikipedia · Wikiquote · Wiktionary · Commons: · Wikidata · MediaWiki · Wikibooks · Wikisource · MediaWiki: Manual · Google
Versions of this help page (for other languages see further)
What links here on Meta or from Meta · Wikipedia · MediaWiki
Reading
Go · Search · Namespace · Page name · Section · Backlinks · Redirect · Category · Image page · Special pages · Printable version
Tracking changes
Recent changes (enhanced) | Related changes · Watching pages · Diff · Page history · Edit summary · User contributions · Minor edit · Patrolled edit
Logging in and preferences
Logging in · Preferences
Editing
Starting a new page · Advanced editing · Editing FAQ · Export · Import · Shortcuts · Edit conflict · Page size
Referencing
Links · URL · Piped links · Interwiki linking · Footnotes
Style and formatting
Wikitext examples · CSS · Reference card · HTML in wikitext · Formula · Lists · Table · Sorting · Colors · Images and file uploads
Fixing mistakes
Show preview · Reverting edits
Advanced functioning
Expansion · Template · Advanced templates · Parser function · Parameter default · Magic words · System message · Substitution · Array · Calculation · Transclusion
Others
Special characters · Renaming (moving) a page · Preparing a page for translation · Talk page · Signatures · Sandbox · Legal issues for editors
Other languages: