View source for Help talk:Sortable tables/Archive 4

{{talkarchivenav}}

== Sorting issue ==

I have a problem sorting column called "ISO performance" at [[Comparison of digital single-lens reflex cameras]]. I tried to put space between the value and ref tag, but that did not help.--[[User:Kozuch|Kozuch]] ([[User talk:Kozuch|talk]]) 20:56, 29 July 2010 (UTC)

== Striping issue ==
Does striping actually work? Is there an additional class you have to define for the table?  I have tr.odd and tr.even styles set up in Mediawiki:Common.css however it doesn't seem to do anything.  Also, I can't seem to find any tables that use striping to look at as an example.  --[[User:Celebane|Celebane]] ([[User talk:Celebane|talk]]) 15:16, 11 August 2010 (UTC)
: I found my problem.  You have to set var ts_alternate_row_colors = true in wikibits.js.  It is false by default. --[[User:Celebane|Celebane]] ([[User talk:Celebane|talk]]) 15:46, 11 August 2010 (UTC)

== Lexical order (Greek) ==

When I sort by the second column (the Greek names) in [[Lefktro#Settlements]], ''Agios Nikonos'' comes before ''Agios Nikolaos'' (but Omicron # Omega). This sorting is strange to me, because ''Άγιος Νικ'''<span style="color:red">ό</span>'''λαος'' should rank <u>before</u> ''Άγιος Νίκ'''<span style="color:red">ω</span>'''νος'' (in the [[Greek alphabet]] '''ο''' Omicron '''<'''  '''ω''' Omega) - or is the Iota's diagraph (ι vs. ί after Ν) responsible for the difference? [[User:Alfie66|<span style="font:600 small-caps Verdana; color:#fff;background-color:#900; padding:0 3px;">Alfie</span>]][[User Talk:Alfie66|<span style="color:#fff;background-color:#009; padding:0 6px;">↑↓</span>]][[Special:Contributions/Alfie66|©]] 16:08, 21 September 2010 (UTC)
:Edit: Copypasted a short example:
{| Class="wikitable sortable"
!English
!Greek
!population
|-
|[[Agios Nikolaos, Messinia|Agios Nikolaos]]
|Άγιος Νικόλαος
| style="text-align:right" |508 
|-
|Agios Nikonos
|Άγιος Νίκωνος
| style="text-align:right" |146 
|-
|[[Kardamyli]]
|Καρδαμύλη (Έδρα)
| style="text-align:right" |447 
|-class="sortbottom"
|'''Total'''
| 
| style="text-align:right" |'''1,101'''
|-
|}[[User:Alfie66|<span style="font:600 small-caps Verdana; color:#fff;background-color:#900; padding:0 3px;">Alfie</span>]][[User Talk:Alfie66|<span style="color:#fff;background-color:#009; padding:0 6px;">↑↓</span>]][[Special:Contributions/Alfie66|©]] 10:44, 22 September 2010 (UTC)
:It is probably the diacritic, and the fact that we don't sort lexically. We sort probably on the unicode index value of characters. —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 14:00, 22 September 2010 (UTC)
::Oh yes. :-( The Iota without the [[Tonos#Unicode|Tonos]] is H0359 (D953) and the one with is H03AF (D943), therefore '''ί''' < '''ι'''. Bad luck. [[User:Alfie66|<span style="font:600 small-caps Verdana; color:#fff;background-color:#900; padding:0 3px;">Alfie</span>]][[User Talk:Alfie66|<span style="color:#fff;background-color:#009; padding:0 6px;">↑↓</span>]][[Special:Contributions/Alfie66|©]] 14:35, 22 September 2010 (UTC)
::Addendum: in the German wiki I found a [http://www.unicode.org/reports/tr10/#Searching hint]. “Special case #3: Case-Folding maps ''iota-subscript'' (U+0345 (ͅ) COMBINING GREEK YPOGEGRAMMENI) to an iota, due to the special behavior of iota-subscript, while the UCA treats ''iota-subscript'' as a regular combining mark (secondary ignorable).”. [[User:Alfie66|<span style="font:600 small-caps Verdana; color:#fff;background-color:#900; padding:0 3px;">Alfie</span>]][[User Talk:Alfie66|<span style="color:#fff;background-color:#009; padding:0 6px;">↑↓</span>]][[Special:Contributions/Alfie66|©]] 15:20, 22 September 2010 (UTC)
:::For the archive: Solved by help of de-WP. Template <nowiki>{{sort}}</nowiki> does the job. [[User:Alfie66|<span style="font:600 small-caps Verdana; color:#fff;background-color:#900; padding:0 3px;">Alfie</span>]][[User Talk:Alfie66|<span style="color:#fff;background-color:#009; padding:0 6px;">↑↓</span>]][[Special:Contributions/Alfie66|©]] 17:44, 22 September 2010 (UTC)
==Client side JAVA?==
Nice that "client side java", but the mentioned Java looks quite mediawiki specific. Just imported the table into another mediawiki site and it works, but probably only because it is in the memory of my computer? Do I have to download that specific java or link to form my mediawiki site to get it work? Thanks, [[Special:Contributions/190.212.246.246|190.212.246.246]] ([[User talk:190.212.246.246|talk]]) 08:46, 27 September 2010 (UTC)
==more sortable data in one cell==
Sometimes I need several data into one field, separated by a comma or so. For example "works with" =>Adrian, Ronald, Jack. Now if I like to sort on "works with", I get it sorted on Adrian, but on Ronald and Jack nothing shows up... Actually I like the row several times here, but only when sorting on a column that can have more options at the same time. [[Special:Contributions/190.212.246.246|190.212.246.246]] ([[User talk:190.212.246.246|talk]]) 08:57, 27 September 2010 (UTC)
==Expandable fields==
Like to have fixed field-width and hoover over -or similar tooltip- to show all text that is in that field. I have no idea if this is possible at present with mediawiki? [[Special:Contributions/190.212.246.246|190.212.246.246]] ([[User talk:190.212.246.246|talk]]) 08:57, 27 September 2010 (UTC)

== Lexical order (Greek) (again) ==

Copied from [[Wikipedia:Help_desk]]
On [[List of fraternities and sororities in the Philippines]], there is a sortable table in the section on General Fraternities and sororities. The first column is Greek Name, which for most of the groups is two, three or four greek letters. If Alphabetized on this column, first come the ones with no Greek Name, then those where the first letter is in fact a Latin Alphabetic Character. After that, it alphabetizes by the Greek Letter itself, Alpha, Beta, Gamma, etc. However even there it is screwy as it alphabetizes in order (at one point): ΑΣ, then ΑΩΒ, then, ΑΦΕ, then ΑΣΕ, and then ΑΦΙΣ. Are there multiple Unicode characters that all look like a single greek letter (say sigma) which could have been copied in to different places that are fouling up the Alphabetical order? I can go through and redo all of them from the character subset area on the edit screen, but I'd like to understand the issue first.[[User:Naraht|Naraht]] ([[User talk:Naraht|talk]]) 15:24, 7 October 2010 (UTC)
:For me it sorts ΑΣ < ΑΣΕ < ΑΦΕ < ΑΦΙΣ < ΑΩΒ, which looks correct. It may be a browser issue.—[[User:EmilJ|Emil]]&nbsp;[[User talk:EmilJ|J.]] 15:42, 7 October 2010 (UTC)
:I switched to IE8 (the first time I was using Chrome) and got the same order that you do on those five. Thank You, Any idea how to make it so that all browsers do it right?[[User:Naraht|Naraht]] ([[User talk:Naraht|talk]]) 17:29, 7 October 2010 (UTC)

== This page is scary ==

I understand sorting pages is a complex subject, but this page scares the hell out of me. This does not seem to be a newbie help page, but an advanced discussion on the topic. Oh, I am still clueless how to properly sort my table numerically. If somebody could look towards improving it I am sure all newbie editors working with tables will be forever gratefull to you. [[User:Yoenit|Yoenit]] ([[User talk:Yoenit|talk]]) 22:06, 17 October 2010 (UTC)

==  Striping ==

This JS is not enabled on en.Wiki, thus it it not useful help. If this is intended to help those on other wikis, then it should be at Meta. There is some discussion on striping at [[MediaWiki talk:Common.css]], but not relevant to the section on the help page. ---'''''—&nbsp;[[User:Gadget850|<span style="color:gray">Gadget850&nbsp;(Ed)</span>]]'''''<span style="color:darkblue">&nbsp;</span><sup>[[User talk:Gadget850|''talk'']]</sup> 22:35, 17 October 2010 (UTC)

==Sortable by Row==
Is it possible to make a table that is sortable by rows instead of columns? I.e. if you click the arrow, the table '''columns''' to be sorted based on the selected '''row''' instead of vice-versa? --[[Special:Contributions/93.141.92.218|93.141.92.218]] ([[User talk:93.141.92.218|talk]]) 09:22, 30 October 2010 (UTC)

== Sorting Problems ==

I had converted this [[2010 CIS football season#Top_10|table]] from a standard table to a sortable table. How can I fix it so that it sorta 1-10 instead of 1, 10, 11, 2, 3 etc.? [[User:Shootmaster 44|Shootmaster 44]] ([[User talk:Shootmaster 44|talk]]) 22:18, 13 November 2010 (UTC)
:The "NR" entries force the columns to be sorted alphabetically. You thus have to fake an alphabetic sort key for the numerical entries, the easy way to do that is to use {{tl|nts}}.—[[User:EmilJ|Emil]]&nbsp;[[User talk:EmilJ|J.]] 12:18, 15 November 2010 (UTC)

== problems with sorting by dates ==

I'm using the sortable table class, but am having problems sorting by date.   I find the instructions a little unclear; is there any format you can apply to the date so it's not linked but still sorts correctly?  Thank you.  --[[User:CutOffTies|CutOffTies]] ([[User talk:CutOffTies|talk]]) 01:56, 30 November 2010 (UTC)
:Try using [[Template:Dtsh]].[[User:Jason Rees|Jason Rees]] ([[User talk:Jason Rees|talk]]) 02:03, 3 December 2010 (UTC)
::Thank you!!  --[[User:CutOffTies|CutOffTies]] ([[User talk:CutOffTies|talk]]) 02:40, 3 December 2010 (UTC)

== Explicit sort modes? ==

Would it be possible to add the ability to override the automatically-selected sort mode?  Perhaps the column heading could be given an attribute like sortMode="numeric" that the Javascript could detect and use instead of the auto-detected mode?  --[[User:Doradus|Doradus]] ([[User talk:Doradus|talk]]) 15:21, 19 December 2010 (UTC)

==Attribute data-sort-value==
It seems to me that the HTML attribute <code>data-sort-value=</code> (see [http://www.mediawiki.org/wiki/Special:Code/MediaWiki/73270 mediawiki implementation]) makes the hidden sort templates {{Tl|hs}} and {{Tl|hid}} obsolete. Many other templates which use <code><nowiki><span style="display:none"> … </span></nowiki></code>, e.g. {{Tl|Sort}}, {{Tl|Sortname}}, {{Tl|dts}} and its many siblings, should be rewritten. If this is not feasible, the use of this attribute should be explained on this help page and in the documentation of those templates, giving guidance in how to avoid the templates in many cases for the benefit of cleaner and faster code. I have successfully used this attribute for the {{Querylink|list of plays by Nestroy|qs=&curid=30955782&diff=415677488&oldid=415662089|list of plays by Nestroy}}. -- [[User:Michael Bednarek|Michael Bednarek]] ([[User talk:Michael Bednarek|talk]]) 12:48, 24 February 2011 (UTC)
:It appears all attributes beginning with "data-*" are currently being stripped by the Wikimedia parser. This means "data-sort-value" does not work here on Wikipedia or any of the other Wikimedia projects. Witness that the example you provided doesn't work, either. - [[User:Vague Rant|Vague]] | [[User talk:Vague Rant|Rant]] 16:51, 1 August 2011 (UTC)

==Reverse order a table permanently==
I'm sure someone has figured out how to do this easily but I'm stumped. Take an article like [[Italian_Open_(tennis)]] and the mens singles table. It starts in the year 2011 but at wiki tennis project we want it to start in 1930. If we don't want it sortable but we want it reversed what's the easiest way to do it? If I make the table sortable and then click on year to reverse the order, that's the way I want it to look all the time. Right now I'm copying the wiki table code into MS Word, reversing it year by year by hand, and then pasting it back into the article. If it's 10 items that's no big deal but when I have tennis tournaments that go from 2011 to 1897 that's a ton of time and effort to do. I wish I could make it sortable on wiki, click the year so that it looks the way I want, and then hit edit and have it keep that new order... but wiki doesn't work that way. Has anyone got a better idea for me. Thanks. [[User:Fyunck(click)|Fyunck(click)]] ([[User talk:Fyunck(click)|talk]]) 09:18, 27 May 2011 (UTC)

[cricobr] The following are a set of steps which could help you achieve what you want. I have not explored the idea fully, or even tested the resulting output, but the steps described below should be enough for you to apply the ideas in your specific case, and for others to apply the ideas in other contexts. I'm certain none of this is new, but it seems useful and powerful enough to be worth a try in yours and other contexts.

The technique involves the intermediate use of a spreadsheet. I used the one in OpenOffice, but I'm pretty certain everything below can be reproduced in Excel as well. I also worked in the Brazilian Portuguese version of OpenOffice, so the function names used in the following formulas will need translating to the English equivalents. Still, that should be pretty obvious, for anyone with the minimum of programming experience, with a little assistance from the help in an English version of OpenOffice or Excel.

The steps:

* go to your table, [[Italian_Open_(tennis)]], in Wikipedia and edit it to make it sortable:
<pre>
=== Men's singles finals ===
{|class="wikitable sortable" style=font-size:90%
</pre>
* sort the table on the year to get the oldest to newest order that you want.
* select all the data text (all the data rows and columns) in the sorted table.
* use CTRL-C to copy.
* open your OpenOffice|Excel Spreadsheet.
* paste in A1 as unformatted text (you will be asked to confirm the interpretation parameters; just accept what is offered).
* you should now find your table pasted neatly into 4 spreadsheet columns.
* now go to the first empty cell on the first row (should be E1), and copy and paste the following as a formula:
<pre>
=CONCATENAR("|-<br>| " ;A1 ; SE(EXATO(ARRUMAR(B1); "Not Held") ;" || bgcolor=#cfcfcf|1936–1949||colspan=3 align=center bgcolor=#cfcfcf|''Not Held"; CONCATENAR(" || {{flagicon|" ;ESQUERDA(ARRUMAR(B1); PESQUISAR(" "; ARRUMAR(B1)) - 1) ;"}} '''[[" ;DIREITA(ARRUMAR(B1); NÚM.CARACT(ARRUMAR(B1)) - PESQUISAR(" "; ARRUMAR(B1))) ;"]] || {{flagicon|" ;ESQUERDA(ARRUMAR(C1); PESQUISAR(" "; ARRUMAR(C1)) - 1) ;"}} [[" ;DIREITA(ARRUMAR(C1); NÚM.CARACT(ARRUMAR(C1)) - PESQUISAR(" "; ARRUMAR(C1))) ;"]] || " ;D1)))
</pre>
* check it produces a valid result; the result for E1 (1930) should be:
<pre>
|-<br>| 1930 || {{flagicon|United}} '''[[States Bill Tilden]] || {{flagicon|Italy}} [[Uberto de Morpurgo]] || 6–1, 6–1, 6–2
</pre>
* select all the cells below 'E1' up to, and including, the row for 1989 (47).
* paste the same formula.
* now repeat for the remaining years using the following formula:
<pre>
=CONCATENAR("|-<br>| [[" ;A48 ;" Internazionali BNL d'Italia – Men's Singles|" ;A48 ;"]] || {{flagicon|" ;ESQUERDA(ARRUMAR(B48); PESQUISAR(" "; ARRUMAR(B48)) - 1) ;"}} '''[[" ;DIREITA(ARRUMAR(B48); NÚM.CARACT(ARRUMAR(B48)) - PESQUISAR(" "; ARRUMAR(B48))) ;"]] || {{flagicon|" ;ESQUERDA(ARRUMAR(C48); PESQUISAR(" "; ARRUMAR(C48)) - 1) ;"}} [[" ;DIREITA(ARRUMAR(C48); NÚM.CARACT(ARRUMAR(C48)) - PESQUISAR(" "; ARRUMAR(C48))) ;"]] || " ;D48)
</pre>
* the result of the above for row 48 (1990) should be:
<pre>
|-<br>| [[1990 Internazionali BNL d'Italia – Men's Singles|1990]] || {{flagicon|Austria}} '''[[Thomas Muster]] || {{flagicon|Soviet}} [[Union Andrei Chesnokov]] || 6–1, 6–3, 6–1
</pre>
* select all the generated cells in column 'E' and copy and paste them into a text editor for final editing (such as replacing the country names with flagicon codes, and fixing the entries for countries with two part names).
* back in Wikipedia delete all the data rows of your table.
* back in your text editor select and copy the finalised wikitext.
* back in Wikipedia paste the new data row wikitext into your wikitext table.
* preview your newly formatted, reordered, table.

It would be possible to write formulas which generate EXACTLY the wikitext that you want, but, as that would be pretty tiresome for a one-off case, it is probably easier to fix the final details using the search and replace facilities in a normal text editor.

Hints for translating the Portuguese formula functions:
<pre>
CONCATENAR = CONCATENATE
SE         = IF
EXATO      = EXACTLY
ESQUERDA   = LEFT
ARRUMAR    = TIDY or TRIM
PESQUISAR  = SEARCH
DIREITA    = RIGHT
NÚM.CARACT = NUM.CHARS
</pre>

[[User:Cricobr|Cricobr]] ([[User talk:Cricobr|talk]]) 02:54, 9 June 2011 (UTC)

:There seems to be an easier way,using the website http://excel2wiki.net/wikipedia.php (which is mentioned at [[Wikipedia:Tools#Importing (converting) content to Wikipedia (MediaWiki) format]]).
:*After sorting the table (<code>class="wikitable sortable"</code>) as desired and copying the result into a spreadsheet program, copy and paste the table from that spreadsheet program into the converter Excel2Wiki and copy/paste its result back into the Wikipedia article's table. Note that sortable tables must not contain row spans. -- [[User:Michael Bednarek|Michael Bednarek]] ([[User talk:Michael Bednarek|talk]]) 05:45, 9 June 2011 (UTC)
:::I had tried copying it into a spreadsheet and the excell2wiki but the result looses all it flags nomenclature. It sorts it but strips it also. I'll poke around at Cricobr's fix but it looks more complicated than doing it by hand on Microsoft Word. Man... I was hoping wiki had some nice and easy fix for me. Thanks. [[User:Fyunck(click)|Fyunck(click)]] ([[User talk:Fyunck(click)|talk]]) 06:28, 9 June 2011 (UTC)
::::Type your data into an Excel spreadsheet and then when your finished use this [http://excel2wiki.net/ excel to Wiki language converter] to add all the wiki language in. This may not be a good way of doing it but its worth a shot.[[User:Jason Rees|Jason Rees]] ([[User talk:Jason Rees|talk]]) 16:44, 9 June 2011 (UTC)

== Sorting ordinals in table ==

Sometimes editors use [[ordinal number]]s in table columns. To make such a column always sort in the expected order, it is tempting to try {{tl|sort}}, e.g. <nowiki>{{sort|1|1st}}, {{sort|2|2nd}}, {{sort|10|10th}}, {{sort|1000|1000th}}</nowiki>, but this didn't work when I tried it.  I look at [[:Category:Sorting templates]] and didn't see any obvious alternatives.  Any suggestions?  [[Special:Contributions/67.101.6.146|67.101.6.146]] ([[User talk:67.101.6.146|talk]]) 02:47, 23 June 2011 (UTC)  P.S. Here's a test case, with the last being the ordinal column:

{| class="wikitable sortable"
|-
! Juror # !! Character !! 1954 actor !! 1957 actor !! 1997 actor !! 2004–2005 actor !! 2006–2007 actor !! Votes 'not&nbsp;guilty'
|-
| 1 || The jury foreman|| [[Norman Fell]] || [[Martin Balsam]] || [[Courtney B. Vance]] || [[Mark Blum]] || [[George Wendt]] || {{sort|9|9th}}
|-
| 2 || An unpretentious bank clerk || [[John Beal (actor)|John Beal]] || [[John Fiedler]] || [[Ossie Davis]] || Kevin Greer || Todd Cerveris || {{sort|5|5th}}
|-
| 3 || A businessman and distraught father; the [[antagonist]] || [[Franchot Tone]] || [[Lee J. Cobb]] || [[George C. Scott]] || [[Philip Bosco]]  || [[Randle Mell]] ||{{sort|12|12th}}
|-
| 4 || A [[stockbroker]], unflappable and self-assured, strong and analytical || [[Walter Abel]] || [[E. G. Marshall]] || [[Armin Mueller-Stahl]] || [[James Rebhorn]] || Jeffrey Hayenga || {{sort|11|11th}}
|-
| 5 || A young man from a violent [[slum]], a [[Baltimore Orioles]] fan || Lee Phillips || [[Jack Klugman]] || [[Dorian Harewood]] || Michael Mastro || Jim Saltouros || {{sort|3|3rd}}
|-
| 6 || A house painter, tough, [[principle]]d, and respectful || Bart Burns || [[Edward Binns]] || [[James Gandolfini]] || [[Robert Clohessy]] || [[Charles Borland]] || {{sort|6|6th}}
|-
| 7 || A salesman, sports fan, indifferent to the deliberations || [[Paul Hartman]] || [[Jack Warden]] || [[Tony Danza]] || [[John Pankow]] || [[Mark Morettini]] || {{sort|7|7th}}
|-
| 8 || An architect, the first dissenter; the [[protagonist]] || [[Robert Cummings]] || [[Henry Fonda]] || [[Jack Lemmon]] || [[Boyd Gaines]] || [[Richard Thomas (actor)|Richard Thomas]] || {{sort|1|1st}}
|-
| 9 || A wise and observant [[old age|elderly]] man|| [[Joseph Sweeney (actor)|Joseph Sweeney]] || Joseph Sweeney || [[Hume Cronyn]] || [[Tom Aldredge]] || Alan Mandell || {{sort|2|2nd}}
|-
| 10 || A garage owner and [[bigotry|bigot]] || [[Edward Arnold (actor)|Edward Arnold]] || [[Ed Begley]] || [[Mykelti Williamson]] || [[Peter Friedman]] || Julian Gamble || {{sort|10|10th}}
|-
| 11 || A [[watchmaker]] and naturalized American citizen || [[Jiří Voskovec|George Voskovec]] || George Voskovec || [[Edward James Olmos]] || [[Larry Bryggman]]|| David Lively || {{sort|4|4th}}
|-
| 12 || A wisecracking, [[advertising]] [[corporate title|executive]] || William West || [[Robert Webber]] || [[William Petersen]] || Adam Trese || Craig Wroe || {{sort|8|8th}}
|}
::P.S. Soon after I posted the question I tried <nowiki>{{sort|01|1st}}, {{sort|02|2nd}}, {{sort|10|10th}}, {{sort|1000|1000th}}</nowiki>, which worked.  Unless there's a template that is explicitly for ordinal numbers I guess that solution is fine.  [[Special:Contributions/67.101.6.146|67.101.6.146]] ([[User talk:67.101.6.146|talk]]) 02:56, 23 June 2011 (UTC)

== Including items in a 'wiki linked' column without the automatic wiki link ==

Sorry if the subject is confusing! I'm working on a page [[List of Doncaster Rovers F.C. players]] where the item entry is like this:<br />
|-
|align=left|{{sortname|Tommy|Cavanagh}}||[[Inside forward|IF]] ||1956–1959 ||119||16||124||18||
|-
<br />
The problem I have is with players who don't yet have a page. I would like their names to appear in plain unlinked text so if someone does create a page with the same name but not the same person, the link won't turn blue. I can make it eg:<br />
|-
|align=left|{{sortname|Tommy|Cavanagh|Tommy Cananagh (footballer born xxxx}}||[[Inside forward|IF]] ||1956–1959 ||119||16||124||18||
|-
<br />
This would guard against this but is there any way of just keeping names as they are but in unlinked text?<br />
Thanks! [[User:Cjwilky|Cjwilky]] ([[User talk:Cjwilky|talk]]) 16:17, 25 June 2011 (UTC)

:Have you tried using the parameter {{Para|nolink|1}} with {{Tl|Sortname}}? -- [[User:Michael Bednarek|Michael Bednarek]] ([[User talk:Michael Bednarek|talk]]) 05:24, 26 June 2011 (UTC)

== [[List of trials of peers in the House of Lords]] ==

I tried to make this list sortable but when it didn't work properly. Can someone help me?--[[Special:Contributions/77.49.154.248|77.49.154.248]] ([[User talk:77.49.154.248|talk]]) 19:24, 14 August 2011 (UTC)
:Rows in sortable tables using <code>colspan=</code> need special treatment; see [[Help:Table#Excluding rows from sorting]] and [[Help:Table#Colspan workaround]]. It's probably simpler to place the text in those last two rows into one row and mark it as <code>class="sortbottom"</code> or even have all that text outside and below the table. -- [[User:Michael Bednarek|Michael Bednarek]] ([[User talk:Michael Bednarek|talk]]) 04:58, 15 August 2011 (UTC)

== Sortable table alterations? ==

Something has happened to the sortable table columns.  They have become much wider, leading the table at [[Snooker world ranking points 2011/2012]] to go off the side of the page.  In Firefox this isn't so bad because you can at least scroll along.  However, in Internet Explorer 8 it is impossible to even scroll along meaning we lose half the table.  I'm sure our table isn't the only one affected on Wikipedia if the columns have been widened (which I didn't think was necessary to be honest because the chart looked better when it was fully on the page), but by not being able to scroll along in IE it has become virtually useless. It would be great if someone could address the IE issue. [[User:Betty Logan|Betty Logan]] ([[User talk:Betty Logan|talk]]) 17:04, 6 October 2011 (UTC)
:Could be related to the update to 1.18 Mediawiki software.  Feel free to publish an error report at the Village Pump (technical).  [[User:The Rambling Man|The Rambling Man]] ([[User talk:The Rambling Man|talk]]) 17:07, 6 October 2011 (UTC)
::OK, thanks I will do that. [[User:Betty Logan|Betty Logan]] ([[User talk:Betty Logan|talk]]) 17:09, 6 October 2011 (UTC)
:I just noticed this too. For me the issue is that columns with short headers are suddenly twice as wide as before, which wastes space and looks bad:
:{|class="wikitable sortable"
!Age
|-
| 50
|-
| 12
|}
:It appears that during the 1.18 release the developers switched the underlying sortable table implementation to http://tablesorter.com, which I guess has a better sorting algorithm but a worse layout. I filed a complaint at Village Pump (technical) [http://en.wikipedia.org/w/index.php?title=Wikipedia:Village_pump_(technical)#Related:_Sort_arrows_make_columns_too_wide]. - [[User:Morinao|Morinao]] ([[User talk:Morinao|talk]]) 20:39, 22 October 2011 (UTC)
::Well, I tried. If anyone else cares, this is where I'm leaving it: [http://en.wikipedia.org/w/index.php?title=Wikipedia:Village_pump_(technical)&oldid=456896515#Related:_Sort_arrows_make_columns_too_wide]. - [[User:Morinao|Morinao]] ([[User talk:Morinao|talk]]) 22:38, 22 October 2011 (UTC)

== "Numeric sort for BC/AD years" section's sorting not working correctly ==

When I try to sort the table in the "Numeric sort for BC/AD years" section on this help page by year, the ascending sort order goes like this:

*ca.200 BC
*c. 400 BC
*ca.400 BC
*ca. 500 BC
*ca.700 BC
*1652
*1822
*1865
*c. 8th century
*c.900

(The descending order is the reverse of that). Seems that it's sorting by the hidden sort key, but using an alphabetical instead of numeric sort. I am using Firefox 3.6. [[Special:Contributions/69.91.29.178|69.91.29.178]] ([[User talk:69.91.29.178|talk]]) 00:58, 8 October 2011 (UTC)

== Not Sortable Anymore ==

All the sortable tables I have created will not sort anymore. Seems to have happened in the last day or two. What has happened and how can I fix it? See [[Fasliyev]] for example. [[User:Tigerboy1966|Tigerboy1966]] ([[User talk:Tigerboy1966|talk]]) 09:34, 8 October 2011 (UTC)

:You have to define the header cells with !, not |. I don't have my head in the new sorter, so take this to [[WP:VPT]]. ---'''''—&nbsp;[[User:Gadget850|<span style="color:gray">Gadget850&nbsp;(Ed)</span>]]'''''<span style="color:darkblue">&nbsp;</span><sup>[[User talk:Gadget850|''talk'']]</sup> 11:00, 8 October 2011 (UTC)
::Thank you for your prompt response Gadget [[User:Tigerboy1966|Tigerboy1966]] ([[User talk:Tigerboy1966|talk]]) 11:05, 8 October 2011 (UTC)

== how do we sort numerically? ==

I'm confused. At [[List of natural satellites]] I placed a copy of all data in the ''Mean radius'' column in exponential form within {{tl|Hs}}, yet it still sorts alphanumerically. I tried {{tl|sort}}, which we use in another article, and still no go. What am I doing wrong? — [[User:Kwamikagami|kwami]] ([[User talk:Kwamikagami|talk]]) 13:25, 8 October 2011 (UTC)

:See [[:meta:Help:Sorting]] for the new sorting features. ---'''''—&nbsp;[[User:Gadget850|<span style="color:gray">Gadget850&nbsp;(Ed)</span>]]'''''<span style="color:darkblue">&nbsp;</span><sup>[[User talk:Gadget850|''talk'']]</sup> 02:08, 10 October 2011 (UTC)

::Thanks. Actually, I found a work-around with the old system: just add lots of zeros in front. Took me long enough to see it! — [[User:Kwamikagami|kwami]] ([[User talk:Kwamikagami|talk]]) 06:31, 10 October 2011 (UTC)

== Styles in headers break sorting? ==

I notice, trying the examples, that adding <code>style="background:#cfcfcf;"</code> to a header cell causes sorting to be disabled for that column.  
{|class="wikitable sortable"
!style="background:#cfcfcf;"  align="center" |Name!!Surname!!Height
|-
|John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|-class="sortbottom"
|||Average:||1.82
|}
although styling of cells still permits sorting
{|class="wikitable sortable"
!Name!!Surname!!Height
|-
|style="background:#cfcfcf;"  align="center" |John||Smith||1.85
|-
|Ron||Ray||1.89
|-
|Mario||Bianchi||1.72
|-class="sortbottom"
|||Average:||1.82
|}
Is there a workaround for this, or are sortable table headers doomed to be plain? --[[User:Lexein|Lexein]] ([[User talk:Lexein|talk]]) 04:25, 16 October 2011 (UTC)
:I reported it as a bug at bugzilla --[[User:Lexein|Lexein]] ([[User talk:Lexein|talk]]) 23:40, 19 October 2011 (UTC)
:'''Update''': The dev-suggested workaround is to use '''<code>style="background-color:#cfcfcf"</code>''' instead of <code>"backgound"</code> --[[User:Lexein|Lexein]] ([[User talk:Lexein|talk]]) 01:12, 18 December 2011 (UTC)

== Sorting tables with multiple numbers of digits ==

I want to fix a table which, when sorted, sorts by the FIRST number, rather than the full number. For instance, from low to high, the table would sort as:

*1,000
*15
*2,000
*25
etc. I want it to sort by the value of the numbers instead. I am guessing that I use (ntsh), correct? [[User:Littlebum2002|littlebum2002]] 19:15, 19 October 2011 (UTC)

:EDIT: Never mind, I am totally lost. Why does the table under [[Long-distance trails in the Republic of Ireland]] sort properly, but the table under [[List of NCAA football bowl records]] sorts in the way described earlier? I can't figure out the difference.  <small><span class="autosigned">— Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[User:Littlebum2002|Littlebum2002]] ([[User talk:Littlebum2002|talk]] • [[Special:Contributions/Littlebum2002|contribs]]) 19:21, 19 October 2011 (UTC)</span></small><!-- Template:Unsigned --> <!--Autosigned by SineBot-->

::The problem is related to the footnotes.  The table correctly sorts the ''Losses'' column, but the ''Wins'' column is lexically sorted.  Same is true with the ''Ties'' (correctly sorted) and ''Bowl Games'' (lexical).  The distinguishing feature in both cases is that the correctly sorting columns do not have footnotes.  This article uses a mechanism I have not seen on wiki before:  an HTML-based linkage <code><nowiki><sup id="inlined" class="reference">[[#noted|[d]]]</sup></nowiki></code>.  Try replacing that with the standard wiki footnote markup using <code><nowiki><ref>...,</ref></nowiki></code> or <code><nowiki><ref name=.../></nowiki></code> and see if that fixes it.  If not, then an explicit sort key mechanism using one of the {{tl|sort}} templates should work, though it is a bit harder to initially write.  —[[user:EncMstr|EncMstr]] ([[user talk:EncMstr|talk]]) 19:36, 19 October 2011 (UTC)

::: Thanks, I just realized the different columns in the same article sorted differently, and was coming to comment on it when I saw your response. I had a feeling it was an error: I would see no reason why Wikipedia would default to lexical sorting on something which should obviously sort by value. let me try the reference switch and see if it works [[User:Littlebum2002|littlebum2002]] 19:49, 19 October 2011 (UTC)

::: I fixed the footnotes issue, but the table still sorts lexically on those columns. This seems odd: could it be that any footnotes in a table stops it from sorting by value? This seems like a bug of some sort. [[User:Littlebum2002|littlebum2002]] 21:10, 19 October 2011 (UTC)

::::It's working as designed. The sort mechanism bases its sorting method on the data; a value of {{Hilite|<code><nowiki>123<ref group=a name=y /></nowiki></code>}} is not recognised as a numeric value. You have to use one of the [[:Category:Sorting templates|sorting templates]] which create hidden sort keys. -- [[User:Michael Bednarek|Michael Bednarek]] ([[User talk:Michael Bednarek|talk]]) 03:39, 20 October 2011 (UTC)

:::::I instead moved the notes to another column, but I have seen other pages which have this same problem that I will try to fix using the hidden keys. It makes sense that the software sees the reference tags as text behind the numbers, thus converting the table to sort lexically. It just seems that reference tags would be an exception. So it is not a bug, but IMO it is something that could and should be fixed. I don;t think every table in the encyclopedia that uses references should have to put hidden tags everywhere. I wrote a bug report, but I think I will change it into a modification request instead. [[User:Littlebum2002|littlebum2002]] 12:08, 20 October 2011 (UTC)

== Template:Static column begin. Problem with multi-row headers ==

This is about '''keeping the rows aligned''' between the fixed row number column and the table to its right. Please see the top table on this page:
*'''[[List of U.S. states and territories by incarceration and correctional supervision rate]].''' For example; see '''[https://en.wikipedia.org/w/index.php?title=List_of_U.S._states_and_territories_by_incarceration_and_correctional_supervision_rate&oldid=927855427 this specific revision].'''

'''{{tl|Static column begin}}''' works easiest when there is a '''header column that spans all the header rows.''' Then I can make the header-height parameter value match up with the main table wikitext for the height of the header that spans all the rows. The '''header height''' is set high enough (270px in this case) to allow readers to '''expand the text size to around 133%''' and '''not break row alignment.''' It is easier to see this in the example and wikitext below. '''{{tl|Rank}}''' redirects to '''{{tl|Static column begin}}.'''

<pre>
{{Rank| rows=2| header-text=Row| header-height=270px| text-align=right| caption=Incarceration rates by state.}}
{|class="wikitable nowrap sortable mw-datatable" border=1 style=text-align:right; 
|-valign=bottom
 !Jurisdiction
 !Yearend<br>2016. In<br>prison<br>or jail
 !2016<br>rate per<br>100,000<br>adults
 !2016<br>rate per<br>100,000<br>of all ages
 !rowspan=4 class=unsortable height=270px|<!--Header column is needed for {{Rank}} template.-->
|-
</pre>
<syntaxhighlight lang=moin>
{{Rank| rows=2| header-text=Row| header-height=270px| text-align=right| caption=Incarceration rates by state.}}
{|class="wikitable nowrap sortable mw-datatable" border=1 style=text-align:right; 
|-valign=bottom
 !Jurisdiction
 !Yearend<br>2016. In<br>prison<br>or jail
 !2016<br>rate per<br>100,000<br>adults
 !2016<br>rate per<br>100,000<br>of all ages
 !rowspan=4 class=unsortable height=270px|<!--Header column is needed for {{Rank}} template.-->
|-
 !US total
 !2,131,000
 !850
 !660
|-
 !Federal
 !188,400
 !80
 !60
|-
 !States, and<br>[[District of Columbia]]
 !1,942,600
 !780
 !600
|-
| style=text-align:left; |{{Flag|Alabama}}||40,900||1,080||840
|-
| style=text-align:left; |{{Flag|Alaska}}||4,400||800||600
|}
{{End}}
</syntaxhighlight>
Problem is that this table has 4 header rows. I had to add a blank column on the right in order to have a header column that spanned (via rowspan) the 4 header rows. '''Can I make that column narrower, or even invisible?'''

Is there another way to get the static row column to perfectly align with the table rows? '''Can a template editor fix this in the template itself?''' -- [[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 12:08, 25 November 2019 (UTC)
:This makes it narrow: <code><nowiki>style="padding-left:0;padding-right:0;"</nowiki></code>. It gets no space between the left and right border so it looks like one thick border. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 00:43, 26 November 2019 (UTC)

::Thanks! Here is the table with that styling added to the spanning header cell: 
<syntaxhighlight lang=moin>{{Rank| rows=2| header-text=Row| header-height=270px| text-align=right| caption=Incarceration rates by state.}}
{|class="wikitable nowrap sortable mw-datatable" border=1 style=text-align:right; 
|-valign=bottom
 !Jurisdiction
 !Yearend<br>2016. In<br>prison<br>or jail
 !2016<br>rate per<br>100,000<br>adults
 !2016<br>rate per<br>100,000<br>of all ages
 !rowspan=4 class=unsortable height=270px style="padding-left:0;padding-right:0;"|<!--The spanning header cell height is needed for {{Rank}} row alignment.-->
|-
 !US total
 !2,131,000
 !850
 !660
|-
 !Federal
 !188,400
 !80
 !60
|-
 !States, and<br>[[District of Columbia]]
 !1,942,600
 !780
 !600
|-
| style=text-align:left; |{{Flag|Alabama}}||40,900||1,080||840
|-
| style=text-align:left; |{{Flag|Alaska}}||4,400||800||600
|}
{{End}}
</syntaxhighlight>
I explained all this in the documentation: 
*'''[[Template:Static column begin/doc]]'''
-- [[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 02:42, 26 November 2019 (UTC)

::Here is a version of the table below using '''[[em units]]''' for the '''height parameters.''' It is '''more compact because there is no white space at the top of the headers,''' and because the text alone can be zoomed to very high levels without losing row alignment. See the updated documentation. 
<syntaxhighlight lang=moin>
{{Rank| rows=2| header-text=Row| header-height=14.19em| text-align=right| caption=Incarceration rates by state.}}
{|class="wikitable nowrap sortable mw-datatable" border=1 style=text-align:right; 
|-valign=bottom
 !Jurisdiction
 !Yearend<br>2016. In<br>prison<br>or jail
 !2016<br>rate per<br>100,000<br>adults
 !2016<br>rate per<br>100,000<br>of all ages
 !height=14.19em rowspan=4 class=unsortable style="padding-left:0;padding-right:0;"|<!--The spanning header cell height is needed for {{Rank}} row alignment.-->
|-
 !US total
 !2,131,000
 !850
 !660
|-
 !Federal
 !188,400
 !80
 !60
|-
 !States, and<br>[[District of Columbia]]
 !1,942,600
 !780
 !600
|-
| style=text-align:left; |{{Flag|Alabama}}||40,900||1,080||840
|-
| style=text-align:left; |{{Flag|Alaska}}||4,400||800||600
|}
{{End}}
</syntaxhighlight>
Even better is this method using '''header-lines=10''' parameter:

Here is how that empty spanning header is formatted so that <code><nowiki>header-lines=10</nowiki></code> works:<br>
<code><nowiki>!rowspan=4 class=unsortable style="padding-left:0;padding-right:0;"|<br><br><br><br><br><br><br><br><br><br></nowiki></code>
<syntaxhighlight lang=moin>
{{Rank| rows=2| header-text=Row| header-lines=10| text-align=right| caption=Incarceration rates by state.}}
{|class="wikitable nowrap sortable mw-datatable" border=1 style=text-align:right; 
|-valign=bottom
 !Jurisdiction
 !Yearend<br>2016. In<br>prison<br>or jail
 !2016<br>rate per<br>100,000<br>adults
 !2016<br>rate per<br>100,000<br>of all ages
 !rowspan=4 class=unsortable style="padding-left:0;padding-right:0;"|<br><br><br><br><br><br><br><br><br><br><!--The spanning header cell is needed for {{Rank}} row alignment.-->
|-
 !US total
 !2,131,000
 !850
 !660
|-
 !Federal
 !188,400
 !80
 !60
|-
 !States, and<br>[[District of Columbia]]
 !1,942,600
 !780
 !600
|-
| style=text-align:left; |{{Flag|Alabama}}||40,900||1,080||840
|-
| style=text-align:left; |{{Flag|Alaska}}||4,400||800||600
|}
{{End}}</syntaxhighlight>
-- [[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 03:38, 7 December 2019 (UTC)

== Default sorting on page load? ==

How can I define a default sort when page loads? And if there isn't any method how can one be added, I'm not asking this question for Wikipedia only
Someone asked this as example: https://stackoverflow.com/questions/16140758/default-sort-column-in-wikipedia-table

[[User:Karl-police|Karl-police]] ([[User talk:Karl-police|talk]]) 11:55, 6 December 2019 (UTC)
:{{u|Karl-police}}, you cannot, you have to sort it yourself. This is for performance reasons. Doing it serverside is difficult to implement, doing it client side would cause the table to dynamically change during page load, which is undesirable. —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 13:39, 6 December 2019 (UTC)

::Maybe, but at the end all it should do is like the client cliks with the mouse on the header, just run that function? But that isn't possible then? [[User:Karl-police|Karl-police]] ([[User talk:Karl-police|talk]]) 15:48, 6 December 2019 (UTC)
:::It would also mean the initial table is different for users without JavaScript, or in print, in PDF conversions, when saved to disk, and so on. I think it would be too confusing. If another initial sort order is important then editors should implement it for everybody in the source. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 21:36, 7 December 2019 (UTC)
:::{{u|Karl-police}} and {{u|PrimeHunter}}: See also: '''[[Wikipedia:Village pump (technical)#Initial table sort]]''' - Check the archives once it moves there. See also:  '''[[Phab:T240114]]:''' "Enhance the VisualEditor table editor to allow sorting and saving sorted content." -- [[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 01:42, 9 December 2019 (UTC)
::::Hm? [[User:Karl-police|Karl-police]] ([[User talk:Karl-police|talk]]) 16:33, 14 December 2019 (UTC)
:::::The original poster in the Village Pump discussion had the same basic question as you. The phabricator task is seeking to make the VisualEditor capable of sorting tables in the wikitext. Alphabetically or by rank. So that the initial sort is changed more easily. -- [[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 22:10, 14 December 2019 (UTC)

== Incorrect BC/AD date sorting? ==
I came to this page to look up how to properly sort BC/AD dates.  I followed the example exactly and my dates didn't sort properly, at which point I realized that the dates on this page don't sort properly either.  Anybody know what's up? [[User:Yuliyag|Yuliya]] ([[User talk:Yuliyag|talk]]) 19:57, 2 January 2020 (UTC)
:{{reply to|Yuliyag}} Which table are you talking about? For me works both the two tables in [[Help:Sorting#Before year 100. Any date format|#Before year 100. Any date format]] and the second and fourth in [[Help:Sorting#Year, month, day. Using numbers. ISO date|#Year, month, day. Using numbers. ISO date]] (the other two are said to be broken, so I haven’t tried them), in Firefox (68.3) as well as in Chromium (v73). —[[User:Tacsipacsi|Tacsipacsi]] ([[User talk:Tacsipacsi|talk]]) 23:08, 2 January 2020 (UTC)
:{{reply to|Tacsipacsi}}I'm using Chrome.  The section I am looking at is called "Numeric sort for BC/AD years".  Instead of sorting large BC -> small BC -> small AD -> large AD, it seems to sort small BC -> large BC -> small AD -> large AD. [[User:Yuliyag|Yuliya]] ([[User talk:Yuliyag|talk]]) 18:06, 3 January 2020 (UTC)
::<s>{{re|Yuliyag}} I put a slightly modified version of the table in [[User:Johnuniq/sandbox2|my sandbox]] ([[Special:PermanentLink/933989101|permalink]]). Do you see a different result when sorting? The issue might be related to the fact that the wikitext has a non-breaking space (U+00A0) in the {{tl|Hs}} for 500 BC. [[User:Johnuniq|Johnuniq]] ([[User talk:Johnuniq|talk]]) 03:07, 4 January 2020 (UTC)</s>
:::<s>Ignore that. There is a problem which I'm scratching my head over. Unfortunately when I simplify the table the problem goes away. [[User:Johnuniq|Johnuniq]] ([[User talk:Johnuniq|talk]]) 04:20, 4 January 2020 (UTC)</s>

I fixed the example in [[User:Johnuniq/sandbox2|my sandbox]] ([[Special:PermanentLink/934007863|permalink]]). It shows that the trick to force numeric sorting of the date column does not work. Perhaps it once did, but it does not now. Sorting the Number and Date columns should give the same order. In the first table (using Help:Sorting), it fails. The second table shows the approved method using <code>data-sort-type="number"</code>. @[[User:WOSlinker|WOSlinker]]: You understand this stuff much more than me. Do you agree that my sandbox shows the information in the current Help:Sorting is wrong and should be updated per my sandbox? [[User:Johnuniq|Johnuniq]] ([[User talk:Johnuniq|talk]]) 06:08, 4 January 2020 (UTC)
:Yes, your sandbox looks correct.  There is also [[Template:Date table sorting]] which can be used to generate the sort keys. -- [[User:WOSlinker|WOSlinker]] ([[User talk:WOSlinker|talk]]) 09:25, 4 January 2020 (UTC)
{{ping|Timeshifter}} Do you agree that the "example in my sandbox" linked just above shows that [[Help:Sorting#Numeric sort for BC/AD years]] is incorrect? You have done most recent editing to the page. Do you want to fix it? [[User:Johnuniq|Johnuniq]] ([[User talk:Johnuniq|talk]]) 05:54, 5 January 2020 (UTC)

:As far as I can remember I didn't create or edit the section of [[Help:Sorting]] in question. I tried looking at it and your sandbox, but I haven't spent the time to figure out everything. I am working on other things right now, and it may be a long time before I have time for this. -- [[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 08:28, 5 January 2020 (UTC)
::OK, no problem. I might fix it but likewise that could take some time. [[User:Johnuniq|Johnuniq]] ([[User talk:Johnuniq|talk]]) 09:07, 5 January 2020 (UTC)

Since I started all this, I could edit.  I don't do much of it, but I think I understand what is to be done. The organization of that particular section does not make sense to me, it should be folded into the rest of the dates and they already cover how to do this.  Also, the table used as an example is already fixed in the article it was taken from, so I think it would be sufficient to list it as an additional example in the dates section.  [[User:Yuliyag|Yuliya]] ([[User talk:Yuliyag|talk]]) 20:28, 6 January 2020 (UTC)

== Date sorting problems ==

[[File:Sorting_issue.png|thumb|right]]According to the "Month, Day and Year" and "Day, Month and Year" subsections of the "Date sorting problems" this help page, all the tables shown there should sort properly. In reality they don't. The first two tables of both subsections actually sort alphabetically on the name of the month when using the sort button. I've included a screen shot to illustrate this.[[User:Tvx1|T]][[User Talk:Tvx1|v]][[Special:Contributions/Tvx1|x]]1 22:22, 11 February 2020 (UTC)
:{{u|Tvx1}}, it works for me. What browser do you use, and what are your languages settings ? —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 22:40, 11 February 2020 (UTC)
::i'm pretty sure your interface language isn't set to english, and then it will use non-english names of the month to attempt the matching with. This is a known problem. —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 23:00, 11 February 2020 (UTC)
:::{{ping|TheDJ}} Do you mean the Internationalisation Language setting at [[Special:Preferences]]? Mine is set to en - English and the sorting does not work for me. I was about to post an example showing that using the crazy date format at [[meta:Help:Sorting#Forcing the sort mode for a column]] works but I'll leave that for now until the language issue is clarified. [[User:Johnuniq|Johnuniq]] ([[User talk:Johnuniq|talk]]) 02:56, 12 February 2020 (UTC)
::::Sorting works for me with [//en.wikipedia.org/wiki/Help:Sorting?uselang=en#Month,_day,_and_year en] but not with other languages like [//en.wikipedia.org/wiki/Help:Sorting?uselang=fr#Month,_day,_and_year fr]. Does the en link sort wrong for you after you have clicked the column heading? [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 03:25, 12 February 2020 (UTC)
:::::I clicked the column heading to sort the columns and I did that for each table at [[Help:Sorting#Month, day, and year]]. However, I must have had a brain failure because it is working now. Without your <code>uselang</code> links, and with your [//en.wikipedia.org/wiki/Help:Sorting?uselang=en#Month,_day,_and_year en] link, when the column heading on the last table shows ▲ I see the following which is in correct ascending order by date:
::::::January 7, 1999
::::::December 5, 1999
::::::May 14, 2004
::::::August 4, 2004
:::::Actually, all four of the tables sort correctly. I knew that I had to enable scripting for the sorting to work but maybe some glitch occurred with that, or maybe I'm nuts:( [[User:Johnuniq|Johnuniq]] ([[User talk:Johnuniq|talk]]) 04:12, 12 February 2020 (UTC)
:::{{ping|TheDJ}}, you're right. My interface language is set to my native Dutch. When I switch to English the sorting works fine.[[User:Tvx1|T]][[User Talk:Tvx1|v]][[Special:Contributions/Tvx1|x]]1 18:58, 12 February 2020 (UTC)
::::It seems worth a mention so I have added [[Help:Sorting#Month names]] with:
:::::All sorting involving month names may fail for registered users who have changed the default language setting "en - English" at [[Special:Preferences]]. It affects relatively few users and can be ignored.
::::There are possible fixes like using month numbers or sort keys but I don't think we should bother with that. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 19:58, 12 February 2020 (UTC)

== # query ==

Hi all, a quick question if that's OK.  In a text column, what should the entry '''#6''' sort as?  As if it were "number six"?  Just "six"?  Or something else entirely?

Thanks in advance! -- [[User:ChrisTheDude|ChrisTheDude]] ([[User talk:ChrisTheDude|talk]]) 09:49, 27 March 2020 (UTC)
:I would sort it as "6". I guess this is about #7 at [[List of Top Country Albums number ones of 1986#Chart history]]. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 14:16, 27 March 2020 (UTC)
::Yeah that's the one.  Don't know why I typed #6 above - brain fart, clearly ;-) -- [[User:ChrisTheDude|ChrisTheDude]] ([[User talk:ChrisTheDude|talk]]) 14:32, 27 March 2020 (UTC)

== Mobile Sorting ==

Sortable tables work on my desktop computer, but when I view them with the Wikipedia app, I'm unable to sort. Is this something that Wiki-markup teams are working on, or am I not using the correct Wiki-markup for my sortable tables?[[User:Comm260 ncu|Comm260 ncu]] ([[User talk:Comm260 ncu|talk]]) 22:03, 29 June 2020 (UTC)
:Same here. I think it is just a limitation of the app. [[phab:T181452]] seems rather old.&nbsp;&mdash; [[User:GhostInTheMachine|GhostInTheMachine]] <sup>[[User talk:GhostInTheMachine|talk to me]]</sup> 23:00, 29 June 2020 (UTC)

== [[List of stars for navigation]] ==

The main sortable table in this article seems to have been bolloxed for something like 10 years. I've tried to figure it out, but couldn't find a simple fix. Could someone with more experience with these sortable tables please help sort it out? [[User:Skyerise|Skyerise]] ([[User talk:Skyerise|talk]]) 22:00, 5 September 2020 (UTC)

== parameters and auto-sorting tables ==

What do the 'create', 'order', 'numeric', and 'ascending'/'descending' parameters and more mean, how do they function, and how do I use 'colspan' and 'rowspan', and use multiple headers or place headers in different locations on [[Module:AutosortTable]], and how do I auto-sort tables and use the 'create', 'order', 'numeric', and 'ascending'/'descending' and the other parameters on tables? -- [[User:PK2|PK2]] ([[User talk:PK2|talk]]) 22:07, 21 August 2020 (UTC)
:{{u|PK2}}, I don't think [[Module:AutosortTable]] is really being used much, if at all. See: "What links here":
:[[Special:WhatLinksHere/Module:AutosortTable]]
:--[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 03:53, 23 August 2020 (UTC)
::{{u|PK2}}. There is more discussion at '''[[Help talk:Table]].''' --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 06:43, 6 September 2020 (UTC)

== Trouble with currency sorting ==

I can't get [[Lists of institutions of higher education by endowment size#All others over US$ 1 billion]] to function. I'm not the best at tables/sorting; could someone help? <span style="color:#AAA"><small>&#123;{u&#124;</small><span style="border-radius:9em;padding:0 5px;background:#088">[[User:Sdkb|<span style="color:#FFF">'''Sdkb'''</span>]]</span><small>}&#125;</small></span> <sup>[[User talk:Sdkb|'''talk''']]</sup> 21:07, 21 September 2020 (UTC)

== Sorting doesn't work on a specific table ==

Hello, I recently created some tables for an article, [[United States nickel mintage figures]]. most of them work fine, but the table labeled, "post-war compositions, 1946-2003" does not sort. any idea why? Thanks.[[User:Skeletonwizard8|Skeletonwizard8]] ([[User talk:Skeletonwizard8|talk]]) 21:58, 20 January 2021 (UTC)
: {{u|Skeletonwizard8}} changed rowspan="5" in the final row to rowspan="3". It was upset by the missing 2 rows — [[User:GhostInTheMachine|GhostInTheMachine]] <sup>[[User talk:GhostInTheMachine|talk to me]]</sup> 22:59, 20 January 2021 (UTC)
:: Thanks[[User:Skeletonwizard8|Skeletonwizard8]] ([[User talk:Skeletonwizard8|talk]]) 17:36, 21 January 2021 (UTC)

== did something happen to break data-sort-values? ==

I'm seeing {{tlc|sortname}} work but setting data-sort-values not work (for example in tables in [[Tatiana Maslany]]). Has there been a recent change that has screwed up data-sort-value? —[[User:Joeyconnick|Joeyconnick]] ([[User talk:Joeyconnick|talk]]) 02:52, 25 March 2021 (UTC)
:{{ping|Joeyconnick}} You wrote <code>data-source-value</code> in the article. Fixed in [https://en.wikipedia.org/w/index.php?title=Tatiana_Maslany&diff=1014134850&oldid=1014086995]. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 11:10, 25 March 2021 (UTC)
::Oh my gosh... sorry! That would explain things. *sigh* —[[User:Joeyconnick|Joeyconnick]] ([[User talk:Joeyconnick|talk]]) 18:47, 25 March 2021 (UTC)

== Sorting years and months ==
Hi, I recently added a column "Duration of record" to this table. https://en.wikipedia.org/wiki/Triple_jump_world_record_progression The problem is that that column doesn't sort properly. Can anyone help? Thanks [[User:BrightOrion|<span style="color:#0080ff;font-family:consolas;">Bright</span>'''Orion''']] | [[User talk:BrightOrion|<span style="color:#336699;font-family:Calibri;">talk</span>]] 10:53, 6 August 2021 (UTC)
: The sort is based on the '''text''' being displayed by the templates. So ''11 months ...'', ''20 days'', ''25 years ...'' is correct for text. You can force a numeric sort by adding a {{tl|hidden sort key}} in front of the displayed text. Sort by the {{tl|age in days}} should work. I have added sort keys like this {{code|<nowiki>{{Hidden sort key|{{age in days|1995|8|7}}}}{{age in years and months |1995|8|7}}</nowiki>}}, but please '''check''' that I copied the dates correctly — [[User:GhostInTheMachine|GhostInTheMachine]] <sup>[[User talk:GhostInTheMachine|talk to me]]</sup> 14:17, 6 August 2021 (UTC)
:: Thank you so much! The data seems to be correct. There's just one record that still doesn't sort properly.  Adhemar da Silva (BRA)	23 July 1952--Helsinki, Finland--11 months and 26 days. This is coming up as the third longest record, when it shouldn't be. Any ideas?  [[User:BrightOrion|<span style="color:#0080ff;font-family:consolas;">Bright</span>'''Orion''']] | [[User talk:BrightOrion|<span style="color:#336699;font-family:Calibri;">talk</span>]] 14:45, 6 August 2021 (UTC)
::: {{smiley|sad}} The value is 361 days but is being sorted '''as text''' between 3532 (9 years ...) and 3681 (10 years ...). Moving the sort values to be attributes of the table cells seems to be safer.<br>{{code|<nowiki>... ||data-sort-value="{{age in days|1952|7|23|1953|7|19}}" | {{Age in years, months and days|1952|7|23|1953|7|19}}</nowiki>}} etc.15:29, 6 August 2021 (UTC) — [[User:GhostInTheMachine|GhostInTheMachine]] <sup>[[User talk:GhostInTheMachine|talk to me]]</sup>
::::Perfect! The table seems to be OK now. Thanks! [[User:BrightOrion|<span style="color:#0080ff;font-family:consolas;">Bright</span>'''Orion''']] | [[User talk:BrightOrion|<span style="color:#336699;font-family:Calibri;">talk</span>]] 16:35, 6 August 2021 (UTC)

==Applying sorting to the top row of headings, not lower ones==
Hello. I regularly see sortable tables like [[1977_Dutch_general_election#By_province|this]] where the sorting arrows appear in the compressed colours row and aren't visible. Is there any way to get the sorting to apply to the top row of headers instead? Cheers, [[User:Number 57|<span style="color: orange;">Number</span>]] [[User talk:Number 57|<span style="color: green;">5</span>]][[Special:Contributions/Number 57|<span style="color: blue;">7</span>]] 18:32, 24 October 2021 (UTC)

:See: '''[[Help:Sorting#Background colors in sortable headers]]'''
:You can add a break in the row of colors (as below), and thus make the row taller. But there are still no sorting icons due to the problem described in the above section of Help:Sorting. 
:So I changed to '''<nowiki>style="background-color:...</nowiki>''' and this put the sorting icons back in the bottom header row. That is where Mediawiki software always puts the sorting icon. I don't know how to force them to be in another header row. 
:You could put the row of colors above the other header row. See farther down. I also removed the width settings in the second table. They are not helpful. Table naturally seeks least width that allows one line per row without laddering if possible.
:It is better to use the row of colors for the sorting icons. This makes the table narrower. 
:
:{| class="wikitable sortable" style="text-align:center;font-size:90%;line-height:14px"
|- style="height:40px;"
! rowspan="2"| [[Provinces of the Netherlands|Province]]
! style="width:40px;"| [[Labour Party (Netherlands)|PvdA]]
! style="width:40px;"| [[Christian Democratic Appeal|CDA]]
! style="width:40px;"| [[People's Party for Freedom and Democracy|VVD]]
! style="width:40px;"| [[Democrats 66|D'66]]
! style="width:40px;"| [[Reformed Political Party|SGP]]
! style="width:40px;"| [[Communist Party of the Netherlands|CPN]]
! style="width:40px;"| [[Political Party of Radicals|PPR]]
! style="width:40px;"| [[Reformed Political League|GPV]]
! style="width:40px;"| [[Pacifist Socialist Party|PSP]]
! style="width:40px;"| [[Farmers' Party (Netherlands)|BP]]
! style="width:40px;"| [[Democratic Socialists '70|DS'70]]
! style="width:40px;" rowspan="2"| Others
|-
! style="background-color:{{party color|Labour Party (Netherlands)}};"|<br>
! style="background-color:{{party color|Christian Democratic Appeal}};"|
! style="background-color:{{party color|People's Party for Freedom and Democracy}};"|
! style="background-color:{{party color|Democrats 66}};"|
! style="background-color:{{party color|Reformed Political Party}};"|
! style="background-color:{{party color|Communist Party of the Netherlands}};"|
! style="background-color:{{party color|Political Party of Radicals}};"|
! style="background-color:{{party color|Reformed Political League}};"|
! style="background-color:{{party color|Pacifist Socialist Party}};"|
! style="background-color:{{party color|Farmers' Party (Netherlands)}};"|
! style="background-color:{{party color|Democratic Socialists '70}};"|
|-
| align="left"| {{flag|Drenthe}}
| style="background-color:#F6C5C1;"|'''41.5'''
| 27.1
| 18.2
| 4.4
| 0.4
| 1.2
| 1.4
| 1.8
| 0.6
| 1.3
| 0.6
| 1.5
|-
| align="left"| {{flag|Friesland}}
| 37.3
| style="background-color:#BADBD3;"| '''37.4'''
| 12.3
| 4.4
| 0.9
| 1.5
| 1.3
| 1.6
| 0.8
| 0.6
| 0.6
| 1.3
|-
| align="left"| {{flag|Gelderland}}
| 30.8
| style="background-color:#BADBD3;"| '''35.5'''
| 17.2
| 4.8
| 3.7
| 0.6
| 1.7
| 0.7
| 0.9
| 1.4
| 0.5
| 2.2
|-
| align="left"| {{flag|Groningen}}
| style="background-color:#F6C5C1;"|'''42.4'''
| 24.3
| 14.4
| 4.4
| 0.3
| 4.3
| 1.9
| 4.0
| 1.3
| 0.7
| 0.6
| 1.4
|-
| align="left"| {{flag|Limburg (Netherlands)|name=Limburg}}
| 30.1
| style="background-color:#BADBD3;"| '''44.6'''
| 14.7
| 3.3
| 0.1
| 1.1
| 1.9
| 0.1
| 0.7
| 1.0
| 0.4
| 2.0
|-
| align="left"| {{flag|North Brabant}}
| 28.8
| style="background-color:#BADBD3;"| '''43.7'''
| 15.7
| 5.0
| 0.5
| 0.6
| 1.6
| 0.2
| 0.8
| 1.1
| 0.5
| 1.5
|-
| align="left"| {{flag|North Holland}}
| style="background-color:#F6C5C1;"|'''35.4'''
| 22.9
| 21.7
| 7.3
| 0.5
| 4.5
| 2.1
| 0.4
| 1.5
| 0.6
| 1.2
| 1.9
|-
| align="left"| {{flag|Overijssel}}
| 31.0
| style="background-color:#BADBD3;"| '''39.5'''
| 13.2
| 4.2
| 2.9
| 1.1
| 1.3
| 2.2
| 0.5
| 1.2
| 0.4
| 2.5
|-
| align="left"| {{flag|South Holland}}
| style="background-color:#F6C5C1;"|'''37.9'''
| 24.6
| 19.9
| 6.1
| 3.8
| 1.3
| 1.5
| 0.8
| 0.8
| 0.4
| 0.9
| 2.0
|-
| align="left"| {{flag|Flevoland|name=''Southern IJsselmeer Polders''}}
| style="background-color:#F6C5C1;"|'''33.1'''
| 29.0
| 18.9
| 6.7
| 1.0
| 2.9
| 2.8
| 1.3
| 0.6
| 0.6
| 0.7
| 2.4
|-
| align="left"| {{flag|Utrecht}}
| 28.2
| style="background-color:#BADBD3;"| '''30.5'''
| 22.1
| 6.6
| 3.2
| 0.9
| 1.9
| 1.6
| 1.3
| 0.7
| 0.7
| 2.3
|-
| align="left"| {{flag|Zeeland}}
| style="background-color:#F6C5C1;"|'''32.6'''
| 29.8
| 17.3
| 4.4
| 8.4
| 0.4
| 1.5
| 1.6
| 0.5
| 1.0
| 0.6
| 1.9
|}
:
:----
:
:{| class="wikitable sortable" style="text-align:center;font-size:90%;line-height:14px;"
|-
! rowspan="2"| [[Provinces of the Netherlands|Province]]
! style="background-color:{{party color|Labour Party (Netherlands)}};" |<br>
! style="background-color:{{party color|Christian Democratic Appeal}};" |
! style="background-color:{{party color|People's Party for Freedom and Democracy}};" |
! style="background-color:{{party color|Democrats 66}};" |
! style="background-color:{{party color|Reformed Political Party}};" |
! style="background-color:{{party color|Communist Party of the Netherlands}};" |
! style="background-color:{{party color|Political Party of Radicals}};" |
! style="background-color:{{party color|Reformed Political League}};" |
! style="background-color:{{party color|Pacifist Socialist Party}};" |
! style="background-color:{{party color|Farmers' Party (Netherlands)}};" |
! style="background-color:{{party color|Democratic Socialists '70}};" |
! rowspan="2"| Others
|- 
! [[Labour Party (Netherlands)|PvdA]]
! [[Christian Democratic Appeal|CDA]]
! [[People's Party for Freedom and Democracy|VVD]]
! [[Democrats 66|D'66]]
! [[Reformed Political Party|SGP]]
! [[Communist Party of the Netherlands|CPN]]
! [[Political Party of Radicals|PPR]]
! [[Reformed Political League|GPV]]
! [[Pacifist Socialist Party|PSP]]
! [[Farmers' Party (Netherlands)|BP]]
! [[Democratic Socialists '70|DS'70]]
|-
| align="left"| {{flag|Drenthe}}
| style="background-color:#F6C5C1;"|'''41.5'''
| 27.1
| 18.2
| 4.4
| 0.4
| 1.2
| 1.4
| 1.8
| 0.6
| 1.3
| 0.6
| 1.5
|-
| align="left"| {{flag|Friesland}}
| 37.3
| style="background-color:#BADBD3;"| '''37.4'''
| 12.3
| 4.4
| 0.9
| 1.5
| 1.3
| 1.6
| 0.8
| 0.6
| 0.6
| 1.3
|-
| align="left"| {{flag|Gelderland}}
| 30.8
| style="background-color:#BADBD3;"| '''35.5'''
| 17.2
| 4.8
| 3.7
| 0.6
| 1.7
| 0.7
| 0.9
| 1.4
| 0.5
| 2.2
|-
| align="left"| {{flag|Groningen}}
| style="background-color:#F6C5C1;"|'''42.4'''
| 24.3
| 14.4
| 4.4
| 0.3
| 4.3
| 1.9
| 4.0
| 1.3
| 0.7
| 0.6
| 1.4
|-
| align="left"| {{flag|Limburg (Netherlands)|name=Limburg}}
| 30.1
| style="background-color:#BADBD3;"| '''44.6'''
| 14.7
| 3.3
| 0.1
| 1.1
| 1.9
| 0.1
| 0.7
| 1.0
| 0.4
| 2.0
|-
| align="left"| {{flag|North Brabant}}
| 28.8
| style="background-color:#BADBD3;"| '''43.7'''
| 15.7
| 5.0
| 0.5
| 0.6
| 1.6
| 0.2
| 0.8
| 1.1
| 0.5
| 1.5
|-
| align="left"| {{flag|North Holland}}
| style="background-color:#F6C5C1;"|'''35.4'''
| 22.9
| 21.7
| 7.3
| 0.5
| 4.5
| 2.1
| 0.4
| 1.5
| 0.6
| 1.2
| 1.9
|-
| align="left"| {{flag|Overijssel}}
| 31.0
| style="background-color:#BADBD3;"| '''39.5'''
| 13.2
| 4.2
| 2.9
| 1.1
| 1.3
| 2.2
| 0.5
| 1.2
| 0.4
| 2.5
|-
| align="left"| {{flag|South Holland}}
| style="background-color:#F6C5C1;"|'''37.9'''
| 24.6
| 19.9
| 6.1
| 3.8
| 1.3
| 1.5
| 0.8
| 0.8
| 0.4
| 0.9
| 2.0
|-
| align="left"| {{flag|Flevoland|name=''Southern IJsselmeer Polders''}}
| style="background-color:#F6C5C1;"|'''33.1'''
| 29.0
| 18.9
| 6.7
| 1.0
| 2.9
| 2.8
| 1.3
| 0.6
| 0.6
| 0.7
| 2.4
|-
| align="left"| {{flag|Utrecht}}
| 28.2
| style="background-color:#BADBD3;"| '''30.5'''
| 22.1
| 6.6
| 3.2
| 0.9
| 1.9
| 1.6
| 1.3
| 0.7
| 0.7
| 2.3
|-
| align="left"| {{flag|Zeeland}}
| style="background-color:#F6C5C1;"|'''32.6'''
| 29.8
| 17.3
| 4.4
| 8.4
| 0.4
| 1.5
| 1.6
| 0.5
| 1.0
| 0.6
| 1.9
|}
:--[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 00:06, 25 October 2021 (UTC)
:You can make it a non-header row with <code>class="sorttop"</code> to keep it at the top during sorting. I don't think you can combine header and non-header cells in the same row so I removed  rowspan=2 from "Province" and "Others" in the below table, and added empty cells in the color row. It might look better with background color similar to the header cells and no visible border. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 00:11, 25 October 2021 (UTC)
:{| class="wikitable sortable" style="text-align:center;font-size:90%;line-height:14px"
|- style="height:40px;"
! [[Provinces of the Netherlands|Province]]
! [[Labour Party (Netherlands)|PvdA]]
! [[Christian Democratic Appeal|CDA]]
! [[People's Party for Freedom and Democracy|VVD]]
! [[Democrats 66|D'66]]
! [[Reformed Political Party|SGP]]
! [[Communist Party of the Netherlands|CPN]]
! [[Political Party of Radicals|PPR]]
! [[Reformed Political League|GPV]]
! [[Pacifist Socialist Party|PSP]]
! [[Farmers' Party (Netherlands)|BP]]
! [[Democratic Socialists '70|DS'70]]
! Others
|- class="sorttop"
|
| style="background:{{party color|Labour Party (Netherlands)}};"|
| style="background:{{party color|Christian Democratic Appeal}};"|
| style="background:{{party color|People's Party for Freedom and Democracy}};"|
| style="background:{{party color|Democrats 66}};"|
| style="background:{{party color|Reformed Political Party}};"|
| style="background:{{party color|Communist Party of the Netherlands}};"|
| style="background:{{party color|Political Party of Radicals}};"|
| style="background:{{party color|Reformed Political League}};"|
| style="background:{{party color|Pacifist Socialist Party}};"|
| style="background:{{party color|Farmers' Party (Netherlands)}};"|
| style="background:{{party color|Democratic Socialists '70}};"|
|
|-
| align="left"| {{flag|Drenthe}}
| style="background:#F6C5C1;"|'''41.5'''
| 27.1
| 18.2
| 4.4
| 0.4
| 1.2
| 1.4
| 1.8
| 0.6
| 1.3
| 0.6
| 1.5
|-
| align="left"| {{flag|Friesland}}
| 37.3
| style="background:#BADBD3;"| '''37.4'''
| 12.3
| 4.4
| 0.9
| 1.5
| 1.3
| 1.6
| 0.8
| 0.6
| 0.6
| 1.3
|-
| align="left"| {{flag|Gelderland}}
| 30.8
| style="background:#BADBD3;"| '''35.5'''
| 17.2
| 4.8
| 3.7
| 0.6
| 1.7
| 0.7
| 0.9
| 1.4
| 0.5
| 2.2
|-
| align="left"| {{flag|Groningen}}
| style="background:#F6C5C1;"|'''42.4'''
| 24.3
| 14.4
| 4.4
| 0.3
| 4.3
| 1.9
| 4.0
| 1.3
| 0.7
| 0.6
| 1.4
|-
| align="left"| {{flag|Limburg (Netherlands)|name=Limburg}}
| 30.1
| style="background:#BADBD3;"| '''44.6'''
| 14.7
| 3.3
| 0.1
| 1.1
| 1.9
| 0.1
| 0.7
| 1.0
| 0.4
| 2.0
|-
| align="left"| {{flag|North Brabant}}
| 28.8
| style="background:#BADBD3;"| '''43.7'''
| 15.7
| 5.0
| 0.5
| 0.6
| 1.6
| 0.2
| 0.8
| 1.1
| 0.5
| 1.5
|-
| align="left"| {{flag|North Holland}}
| style="background:#F6C5C1;"|'''35.4'''
| 22.9
| 21.7
| 7.3
| 0.5
| 4.5
| 2.1
| 0.4
| 1.5
| 0.6
| 1.2
| 1.9
|-
| align="left"| {{flag|Overijssel}}
| 31.0
| style="background:#BADBD3;"| '''39.5'''
| 13.2
| 4.2
| 2.9
| 1.1
| 1.3
| 2.2
| 0.5
| 1.2
| 0.4
| 2.5
|-
| align="left"| {{flag|South Holland}}
| style="background:#F6C5C1;"|'''37.9'''
| 24.6
| 19.9
| 6.1
| 3.8
| 1.3
| 1.5
| 0.8
| 0.8
| 0.4
| 0.9
| 2.0
|-
| align="left"| {{flag|Flevoland|name=''Southern IJsselmeer Polders''}}
| style="background:#F6C5C1;"|'''33.1'''
| 29.0
| 18.9
| 6.7
| 1.0
| 2.9
| 2.8
| 1.3
| 0.6
| 0.6
| 0.7
| 2.4
|-
| align="left"| {{flag|Utrecht}}
| 28.2
| style="background:#BADBD3;"| '''30.5'''
| 22.1
| 6.6
| 3.2
| 0.9
| 1.9
| 1.6
| 1.3
| 0.7
| 0.7
| 2.3
|-
| align="left"| {{flag|Zeeland}}
| style="background:#F6C5C1;"|'''32.6'''
| 29.8
| 17.3
| 4.4
| 8.4
| 0.4
| 1.5
| 1.6
| 0.5
| 1.0
| 0.6
| 1.9
|}
:[[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 00:11, 25 October 2021 (UTC)
::Another advantage of putting the sorting icons in the row of colors is that there are no links in those color cells. The link in a cell makes it difficult to quickly click the sorting cell without clicking the link. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 00:37, 25 October 2021 (UTC)
:I don't really see why the colors are there to begin with. They aren't accessible for screen readers and don't seem to portray any info. Given it isn't coloring data but a blank cell, it is either unnecessary or portrays info only through color. [[MOS:COLOR]]: "Ensure that color is not the only method used to communicate important information." Also, it can be argued that hiding the sortable links/arrows (e.g. [[1977 Dutch general election#By province]]) goes against "Links should clearly be identifiable as a link to our readers." and probably [[MOS:EGG]], which the arrows indicate sorting links when present as well as the sort order once clicked (ascending, descending or both [unsorted] arrows). [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 06:18, 12 February 2022 (UTC)
::After a second glance, I see the colors are supposed to represent the different parties. There are so many colors that I would never use them to try and find related data in another table. I would just use the header text. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 06:31, 12 February 2022 (UTC)

== Possible locale-dependent sort bug ==

As reported by {{u|Emanuele676}} in {{section link|Talk:2022 monkeypox outbreak|Changes made to the table}}, there seems to be a locale-dependent bug when trying to sort dates with month names in English with the user's Wikipedia language set to Italian. I cannot reproduce the problem myself. What is the best place to report this bug with the little information we have for further investigation? --[[User:Ftrebien|Fernando Trebien]] ([[User talk:Ftrebien|talk]]) 02:14, 3 June 2022 (UTC)
:It's mentioned at [[Help:Sorting#Month names]] and [[phab:T126744]]. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 11:47, 3 June 2022 (UTC)
::Thank you! --[[User:Ftrebien|Fernando Trebien]] ([[User talk:Ftrebien|talk]]) 16:07, 3 June 2022 (UTC)
::{{ping|PrimeHunter}} Wrapping the dates with {{tl|dts}} seems to work around the issue while increasing editing complexity. Maybe we could mention this in {{section link|Help:Sorting|Month names}}? --[[User:Ftrebien|Fernando Trebien]] ([[User talk:Ftrebien|talk]]) 18:50, 3 June 2022 (UTC)
:::I guess more than 99.9% of page views are from unregistered users or users with the default English, or British or Canadian English which also works. I don't think we should add complications. [[User:PrimeHunter|PrimeHunter]] ([[User talk:PrimeHunter|talk]]) 19:24, 3 June 2022 (UTC)

== Template to request sorting of a list? ==

Wondering if there is a template that can go in a list article saying something like "This list needs to be sorted" (alphabetically, alphabetically by surname and first name, by date (oldest first or newest first), etc.)? There seems to be a lot of articles that could use this, e.g. [[WP:Requested articles/Social sciences#Sociology people]]. Thanks! [[User:Facts707|Facts707]] ([[User talk:Facts707|talk]]) 13:31, 14 April 2022 (UTC)

:Responding late, but better late than never. @[[User:Facts707|Facts707]], {{tlx|unsorted list}} is the template you are looking for. [[User:Qwerty284651|Qwerty284651]] ([[User talk:Qwerty284651|talk]]) 05:07, 30 October 2022 (UTC)
::Thanks qwerty! I have added an MOS section [[MOS:LISTSORT]] and a couple links to make list sorting a little easier to find.
::Cheers, [[User:Facts707|Facts707]] ([[User talk:Facts707|talk]]) 05:54, 30 October 2022 (UTC)
:::Good thinking with adding a MOS section and shortcuts to it. Didn't know one can just add a MOS guideline just like that. Also, good choice for the shortcut names. Best, [[User:Qwerty284651|Qwerty284651]] ([[User talk:Qwerty284651|talk]]) 22:07, 30 October 2022 (UTC)

== Problem w table ==

At [[List_of_possible_dwarf_planets#Largest_measured_candidates]], I'm having trouble getting the density value of Dysnomia (1.8–2.4) to sort properly. I'd like it to sort at its midpoint (2.1) as other data do. [[User:Kwamikagami|— kwami]] ([[User talk:Kwamikagami|talk]]) 07:54, 29 November 2022 (UTC)
:{{re|Kwamikagami}} Looks like you had Dysnomia's "data-sort-value" set to <code>&amp;#123;&amp;#123;val&#124;2.1</code>. I changed it to <code><nowiki>{{val|2.1}}</nowiki></code>, which sorts properly now. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 13:21, 29 November 2022 (UTC)
::Ah, so we need the closing braces. That's where I went wrong. I thought that if I used the html codes, they wouldn't be treated as code. (That's what our help page claims.) Strange that we need to use proper template syntax for a string that is not treated as template syntax. [[User:Kwamikagami|— kwami]] ([[User talk:Kwamikagami|talk]]) 16:20, 29 November 2022 (UTC)
:{{re|Kwamikagami}} Also, I suggest changing the format of the value to match the others for consistency sake from {{highlight|1.8–2.4}} to {{highlight|2.1±0.3}}. By doing this, you won't need to specify a "data-sort-value" like the others. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 13:28, 29 November 2022 (UTC)

== Moved ==

I [https://en.wikipedia.org/w/index.php?title=Help:Sortable_tables&diff=prev&oldid=1139179226 moved] this from [[Help:Sorting]] to [[Help:Sortable tables]]. The entire page is about sortable tables, not about sorting data in general ([[MOS:LISTSORT|sorting lists]], [[WP:STUBSORT|sorting stubs]], etc.). Cheers, <span style="font-variant:small-caps;">[[User:Manifestation|Manifestation]] <small>([[User talk:Manifestation|talk]])</small></span> 20:22, 13 February 2023 (UTC)

== Shortcuts discussion at [[Template talk:Wikipedia how-to]] ==

{{u|Chompy Ace}} and others. Please do not revert this diff:
*https://en.wikipedia.org/w/index.php?title=Help%3ASortable_tables&diff=1142601037&oldid=1142587424

Wait until there is a solution at '''[[Template talk:Wikipedia how-to]].''' If the template editors allow the text to wrap around the shortcuts box, then the revision can be reverted. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 09:55, 3 March 2023 (UTC)

: Unless you are proposing to modify all pages using this template until it is fixed for mobile, I can't see the reason for modifying for this specific page [[User:GiovanniSidwell|GiovanniSidwell]] ([[User talk:GiovanniSidwell|talk]]) 16:54, 6 March 2023 (UTC)
::I am proposing that the template be modified. That fixes the problem for all pages. Can you modify the template? I don't know enough to fix the template, or I would do it. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 05:23, 7 March 2023 (UTC)

== Scopes ==

Scopes are not needed on simple tables.

More info:
*'''[[Wikipedia talk:Manual of Style/Accessibility/Data tables tutorial/Archive 2#Are scope=row and scope=column needed nowadays on basic wikitables using class=wikitable?]].'''
*'''[[Wikipedia talk:Manual of Style/Accessibility/Data tables tutorial#Row headers when table contains only two columns]].'''

But if people want to add the scopes to simple tables that is up to them, and what they do with their time. 

Some of the Wikipedia info is out of date, going back to a time when scopes mattered on simple tables. Screen readers are much better now. 

I believe '''[[MOS:SIMPLIFY]]''' applies and the '''[[KISS Principle]].''' Why make things more difficult for the average Wikipedia editor? 

There are accessibility guidelines that actually make a difference. Like getting rid of nested tables. I removed most of them from '''[[Help:Table]]''' and '''[[Help:Sortable tables]].''' That took a lot of time. There may be some remaining. I don't have as much health and time as I used to. So others may have to finish the job. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 17:29, 13 March 2023 (UTC)

:You'd have more time if you didn't work so hard to revert every change to one of "[[WP:OWN|your]]" pages. You could also '''save time''' by reducing the unnecessary '''bolding''' of your text. It's like you '''don't want''' us to read it, or something. <i>&mdash;&nbsp;[[User:JohnFromPinckney|JohnFromPinckney]] ([[User talk:JohnFromPinckney|talk]] / [[Special:Contributions/JohnFromPinckney|edits]])</i> 15:05, 16 March 2023 (UTC)
::Average editors in general would have more time if they weren't burdened with incorrect information about using '''out-of-date scope rules.'''
::Bolding helps focus on the main points, and the links. This saves most people time. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 16:55, 16 March 2023 (UTC)
:::{{tq|This saves most people time.}}{{Citation needed|date=March 2023}} I remain '''unconvinced''', until you point to some empirical data.
:::And there would be more time saved in the aggregate, if our examples used correct mark-up. This Help page should provide a good model, and when you refuse to use even <code><nowiki><th></nowiki></code> markup (via&nbsp;<code>!</code>), you do all interested editors a disservice. <i>&mdash;&nbsp;[[User:JohnFromPinckney|JohnFromPinckney]] ([[User talk:JohnFromPinckney|talk]] / [[Special:Contributions/JohnFromPinckney|edits]])</i> 13:12, 17 March 2023 (UTC)
::::Asking people to add unnecessary scopes to simple tables takes more time. You don't need a double-blind study to see that. Making things unnecessarily complicated goes against the spirit of '''[[MOS:SIMPLIFY]].''' It discourages editors too. 
::::Making the first column a header column when it is obviously not a header column is illogical. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 16:42, 17 March 2023 (UTC)
:I agree that scope on simple tables where only the first row and/or only the first column consists of heading cells, is not required for screenreaders and generally is just not useful to specify.
:There is one note of interest however, and that is that we have a [[MediaWiki:Common.css#L-369|plainrowheaders class]] which undos some of the table heading styling, which relies on scope having been specified (because there is no other way to reliably find the 'first' cell when you using row and colspans to taget them with CSS).
:Additionally when multi row or column headings are used, especially when combined with row or column spanning, they theoretically might be useful as well (though I'm not entirely sure if there is any screenreader which actually does anything with this information. —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 22:06, 17 March 2023 (UTC)
::{{u|TheDJ}}. Your last paragraph is what I am curious about. As I said previously, I spent hours removing nested tables from help pages because I knew it actually mattered for '''[[screen readers]].''' 
::[[Help:Table#Scope]] has some info concerning complex tables: Tables with multi row or column headings, and row or column spanning. But it is not backed up by references outside Wikipedia. Nor backed up by info from people using current screen readers. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 04:00, 18 March 2023 (UTC)

== <code>data-sort-type=text</code> doesn't seem to work properly ==

When the example table for data-sort-type=text is sorted ascending, it comes out like this:

<blockquote>Album<br/>
19<br/>
19<br/>
21<br/>
21<br/>
21<br/>
21<br/>
193<br/>
215<br/>
Everything Is New<br/>
Love & War<br/>
Matinée<br/>
</blockquote> 
But if it is sorting lexically, shouldn't 193 come before 21? Since the character '1' comes lexically before '2'. [[User:KeithTyler|Keith D. Tyler]] [[User_talk:KeithTyler|&para;]] 08:55, 16 March 2023 (UTC)

:{{u|KeithTyler}}. Concerning: 
:[[Help:Sortable tables#Forcing a column to have a particular data type]]
:The only thing I could find doing Google searches is this:
:'''[[Natural sort order]]'''
:Need someone with knowledge of how the MediaWiki software is sorting alphabetically.
:Could ask at '''[[Wikipedia:Village pump (technical)]].'''
:--[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 12:20, 16 March 2023 (UTC)
::I asked at [[Wikipedia:Village pump (technical)]]. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 12:27, 16 March 2023 (UTC)
::It uses locale specific collation, with number preservation enabled. https://github.com/wikimedia/mediawiki/blob/master/resources/src/jquery.tablesorter/jquery.tablesorter.js#L772 —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 13:42, 16 March 2023 (UTC)
:::{{u|TheDJ}}. Is "number preservation" what [[natural sort order]] uses? --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 13:55, 16 March 2023 (UTC)
::::More the other way around the collator's option to preserve numeric order, implies that it is using a natural sort order. —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 14:01, 16 March 2023 (UTC)
:::::{{u|TheDJ}}. I am confused by all the terminology. So '''data-sort-type=text''' is using alphabetical sorting of text, but numbers are sorted numerically within that alphabetical sorting? --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 14:21, 16 March 2023 (UTC)
::::::Correct. —[[User:TheDJ|Th<span style="color: green">e</span>DJ]] ([[User talk:TheDJ|talk]] • [[Special:Contributions/TheDJ|contribs]]) 22:08, 17 March 2023 (UTC)
:::::::{{User:TheDJ}} This raises two big questions. One, why is it "data-sort-type=text" if it does not actually do text-based sorting? (It ought to be data-sort-type-natural since that is what it does.) And further, how does one get ''true'' lexical sort on a column, including for numbers? [[User:KeithTyler|Keith D. Tyler]] [[User_talk:KeithTyler|&para;]] 18:16, 5 April 2023 (UTC)
:::::::It's interesting, too, that such a behavior-changing code change was implemented so silently -- and with no documentation updates. - [[User:KeithTyler|Keith D. Tyler]] [[User_talk:KeithTyler|&para;]] 18:28, 5 April 2023 (UTC)
{{unindent}} {{u|KeithTyler}} and {{u|TheDJ}}. Per our discussion I updated the info here (and the following section):
*[[Help:Sortable tables#Forcing a column to have a particular data type]]
--[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 02:01, 18 March 2023 (UTC)

== Sorting a singular name into a list ==

How would you sort a singular name - say Bruma, into a group of names (with a first and last name) that is sorted by their surname? The only way I can think to do it leaves a space before the name like: ' Bruma' instead of simply 'Bruma'. I'm using the [[Template:Sortname|sortname template]]. [[User:MessiIsMyBezzie|MessiIsMyBezzie]] ([[User talk:MessiIsMyBezzie|talk]]) 21:58, 26 April 2023 (UTC)

:oh no - ignore me, when I preview the page the space isn't there so it should be all good. [[User:MessiIsMyBezzie|MessiIsMyBezzie]] ([[User talk:MessiIsMyBezzie|talk]]) 22:04, 26 April 2023 (UTC)

== Quotes are not needed unless there is a space in the value ==

See discussion at [[Help talk:Table]]. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 00:34, 4 May 2023 (UTC)

== data-sort-value with numbers ==

The article only talks about using data-sort-value with text. It should give examples with numbers. Main questions I had were

- do I need to surround it with quotes  data-sort-value="22" or  data-sort-value=22

- do I need to (or does it help) to also manually specify the data-type [[User:Akeosnhaoe|Akeosnhaoe]] ([[User talk:Akeosnhaoe|talk]]) 15:29, 24 July 2023 (UTC)
:See: <s>[[Help:Sortable table#Before year 100. Any date format]]</s> ''(no longer works).''
:Can you provide some examples below of what you are trying to sort? A small table, for example. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 16:37, 24 July 2023 (UTC)
::[[Visa requirements for Canadian citizens]]
::As far as I can tell after doing more research, the answer to my questions were "you need to put it in quotes" and "yes", but I'm not too sure on the latter. [[User:Akeosnhaoe|Akeosnhaoe]] ([[User talk:Akeosnhaoe|talk]]) 16:49, 24 July 2023 (UTC)
:::'''data-sort-type=number''' is a good idea in that table because some people may forget to add the '''data-sort-value''' in some cases. This could mess up sorting in some very particular cases. Too long to explain. See the fine print here: '''[[Help:Sortable tables#Examples of datatype auto detection. First 5 cells in a column]].''' And: '''[[Help:Sortable tables#Numerical sorting problems]].''' --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 17:22, 24 July 2023 (UTC)

== Caption bug? ==

I observed a problem in instances of {{tl|AchievementTable}} which contain a custom caption. The template includes a series of sortable columns, so upon transclusion, any custom caption added after the template will follow the columns. On standard wikitables, there is no difference if the caption is listed before or after the columns in the table design. However, in sortable wikitables, the addition of a caption after the columns causes the sorting functionality to break and the column and row dividers are missing too.

Can the code for sortable wikitables be updated to handle for caption after the columns, disregarding them from the sort? [[User talk:Sillyfolkboy|SFB]] 20:48, 23 August 2023 (UTC)

;Standard wikitable, caption before columns
{| class="wikitable" style=" text-align:center; font-size:90%;"
|-
|+ 1 2 3
|-
!1
!2
!3
|-
|a || b || c
|}

;Standard wikitable, caption after columns
{| class="wikitable" style=" text-align:center; font-size:90%;"
|-
!1
!2
!3
|-
|+ 1 2 3
|-
|a || b || c
|}
;Sortable wikitable, caption before columns
{| class="wikitable sortable" style=" text-align:center; font-size:90%;"
|-
|+ 1 2 3
|-
!1
!2
!3
|-
|a || b || c
|-
|d || e || f
|}
;Sortable wikitable, caption after columns
{| class="wikitable sortable" style=" text-align:center; font-size:90%;"
|-
!1
!2
!3
|-
|+ 1 2 3
|-
|a || b || c
|-
|d || e || f
|} [[User talk:Sillyfolkboy|SFB]] 20:48, 23 August 2023 (UTC)

: I would just follow the examples on [[Help:Table]] where the table caption is placed before the headers. {{tq|Only between table start and first table row.}} [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 21:59, 23 August 2023 (UTC)

:{{u|Sillyfolkboy}}. Could you give examples using {{tl|AchievementTable}}? --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 02:15, 24 August 2023 (UTC)
::{{u|Timeshifter}} See previous example on [[Mo Farah]] [https://en.wikipedia.org/w/index.php?title=Mo_Farah&oldid=1169918105#International_competitions here]. This template contains parameters for defining both the table and the column, so users cannot apply a custom caption in wikitext when this template is used. I've found various cases, particularly with British athletes who naturally represent multiple nations, so I assume there are numerous instances of this in articles, but they are not easily identifiable without a manual search. I've updated the template to allow for multiple nations in the caption so the use case is covered and can be fixed by adding detail to the template parameters, but thought I'd raise this as the behaviour differs between sortable and regular wikitable. [[User talk:Sillyfolkboy|SFB]] 10:56, 24 August 2023 (UTC)
:::{{re|Sillyfolkboy}} Sounds like this discussion should be moved to that template page. To clarify, what you are referring to is a table caption, which is not the same as headers in a table; otherwise it will get confusing. From the template and your recent edit, it displays a table caption of 1-2 flags/countries or, if doesn't have flag for the "nation" value, the text along with "Representing". As previously stated, the table caption has to be above all other rows including the column headers. I did a search for the code usage and found a lot where the table caption was moved to a "colspan" row of column headers, which doesn't mess up sorting. [https://en.wikipedia.org/w/index.php?search=insource%3AAchievementTable+insource%3Acolspan+insource%3ARepresenting&title=Special:Search&profile=advanced&fulltext=1&ns0=1 Search results]. On the [[Christian Coleman]] page, there are two such tables like this: [[Christian_Coleman#International_competitions|International competitions]] and [[Christian_Coleman#National_championships|National championships]]. Note that the "National championships" table doesn't show countries or flags. This improvised row of column headers would be more properly displayed as a table caption and would help with accessibility (screen readers), which is something that would need to be fixed on that template or those tables. A solution would be to add what they want displayed in the table caption along with any flags and links to the "nation" parameter, which would allow for multiple in one parameter. It would be better to discuss other solutions on that template page. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 22:01, 24 August 2023 (UTC)
::::{{re|Jroberson108}} Thanks for the correction! The nation parameter of that template already has a check so if something other than a nation is added (e.g. a team or club) then this will display in plain text. I'll have a think about how to best allow a "team" or "caption" option here... [[User talk:Sillyfolkboy|SFB]] 17:46, 25 August 2023 (UTC)
:::::{{re|Sillyfolkboy}} IMHO, I think users might be confused on the name of the parameter of "nation" ("caption" might have been better?), so doc clarity about its use in the table caption and recommended format ("the", which flag template, "&" for multiple, etc.) for consistency might help alleviate that issue. The "nation2" parameter could also be reverted if the doc is clear. This would also alleviate the need of adding additional parameters like "team" or "club" so it stays simple. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 18:48, 25 August 2023 (UTC)
::::::{{re|Jroberson108}} The "nation" parameter has been there for nearly a decade and using it to show one national team accounts for 95%+ of usages. I've added the caption aspect this week purely because of this difference in table behaviour. It is very rarely used for non-national captions with this template. I'll add a caption parameter as an alt of nation and document that, as it already doubles for that usage anyway through the link check. [[User talk:Sillyfolkboy|SFB]] 20:37, 25 August 2023 (UTC)
:::::::{{re|Sillyfolkboy}} I wasn't suggesting changing the "nation" parameter or the template logic around it, only documenting that it can be used for non-nations and even multiples where you would have to manually add any nation flags yourself. Adding a "caption" parameter would be clear, although the "nation" parameter also affects the table caption, so maybe specify they use one or the other. Might be good to discuss on that template's talk page with those involved? [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 22:25, 25 August 2023 (UTC)
:::::::I just looked and saw you are the original creator of the template, so I guess discuss there if needed. Looks like you already added the "caption" parameter. Glad you found a solution. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 22:44, 25 August 2023 (UTC)
{{unindent}}{{u|Sillyfolkboy}}. It is good to bring such problems to both here and the template page. I have seen some '''buggy interactions between templates and sortable tables.''' For example:
*[[Help:Sortable tables#Sorting row template]] - see note at top about sorting problem. 
*[[Template:Static row numbers header#Static data rows]]. Another sorting problem.
*[https://phabricator.wikimedia.org/T344562 T344562. Row moving over one cell. Table bug using certain templates].
And '''between colspan and a template:'''
*[[Template talk:Flagg#Does not work with colspan]]
So one has to find a workaround. Go with whatever works until better solutions are found. It looks like templates used at or near the top of sortable tables can be a problem. You may need to do without the template in some specific circumstances. Or the use of specific parameters may be required. Both should be listed in the template documentation. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 05:26, 25 August 2023 (UTC)
:{{re|Timeshifter}} Thanks for including the context :) I've implemented support for two nations/captions in the affected template, plus inclusion of the team as column data rather than a caption. Alongside Jroberson108's other solution I think we've got enough functionality to handle all the use cases in some way! [[User talk:Sillyfolkboy|SFB]] 17:46, 25 August 2023 (UTC)

== List of historical earthquakes ==

Can someone knowledgeable can lend a hand here, please: [[Talk:List_of_historical_earthquakes#Date_Ordering]]. Thanks! [[User:Fgnievinski|fgnievinski]] ([[User talk:Fgnievinski|talk]]) 00:44, 6 September 2023 (UTC)
: Fixed. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 01:50, 6 September 2023 (UTC)

==Discussion at [[:Wikipedia:User scripts/Requests#Sortkeys in lists|Wikipedia:User scripts/Requests §&nbsp;Sortkeys in lists]]==
[[File:Symbol watching blue lashes high contrast.svg|25px|link=|alt=]]&nbsp;You are invited to join the discussion at [[:Wikipedia:User scripts/Requests#Sortkeys in lists|Wikipedia:User scripts/Requests §&nbsp;Sortkeys in lists]].  <span style="color:#AAA"><small>&#123;{u&#124;</small><span style="border-radius:9em;padding:0 5px;background:#088">[[User:Sdkb|<span style="color:#FFF">'''Sdkb'''</span>]]</span><small>}&#125;</small></span> <sup>[[User talk:Sdkb|'''talk''']]</sup> 15:40, 12 January 2024 (UTC)<!-- [[Template:Please see]] -->

== Sort under template ==
{{resolved}}
I created the {{tl|sort under}} template to reposition the sorting arrows under the text without the issues that come with adding [[Help:Sortable tables#Sorting buttons in a separate row|sorting buttons in a separate row]]. Please review and mention any issues on its talk page. [[User:Jroberson108|Jroberson108]] ([[User talk:Jroberson108|talk]]) 20:25, 28 January 2024 (UTC)

'''Comments are requested there''' specifically concerning whether the default '''class=sort-under''' should be centered sorting icons or right-aligned sorting icons. Or even left-aligned ones. --[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 21:46, 28 January 2024 (UTC)

:For those who are interested. Someone at the technical Village Pump suggested going to this MOS discussion page since it is a style discussion, and not a technical problem. See:
:'''[[Wikipedia talk:Manual of Style/Tables#Template:Sort under]]'''
:--[[User:Timeshifter|'''Timeshifter''']] ([[User talk:Timeshifter|talk]]) 14:11, 4 February 2024 (UTC)