Help talk:Sortable tables/Archive 4

This is an archive of past discussions about Help:Sortable tables. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page.

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.--Kozuch (talk) 20:56, 29 July 2010 (UTC)

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. --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. --Celebane (talk) 15:46, 11 August 2010 (UTC)

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 Άγιος Νικόλαος should rank before Άγιος Νίκωνος (in the Greek alphabet ο Omicron < ω Omega) - or is the Iota's diagraph (ι vs. ί after Ν) responsible for the difference? Alfie↑↓© 16:08, 21 September 2010 (UTC)

Edit: Copypasted a short example:

Alfie↑↓© 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. —TheDJ (talk • contribs) 14:00, 22 September 2010 (UTC)

Oh yes. :-( The Iota without the Tonos is H0359 (D953) and the one with is H03AF (D943), therefore ί < ι. Bad luck. Alfie↑↓© 14:35, 22 September 2010 (UTC)

Addendum: in the German wiki I found a 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).”. Alfie↑↓© 15:20, 22 September 2010 (UTC)

For the archive: Solved by help of de-WP. Template {{sort}} does the job. Alfie↑↓© 17:44, 22 September 2010 (UTC)

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, 190.212.246.246 (talk) 08:46, 27 September 2010 (UTC)

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. 190.212.246.246 (talk) 08:57, 27 September 2010 (UTC)

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? 190.212.246.246 (talk) 08:57, 27 September 2010 (UTC)

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.Naraht (talk) 15:24, 7 October 2010 (UTC)

For me it sorts ΑΣ < ΑΣΕ < ΑΦΕ < ΑΦΙΣ < ΑΩΒ, which looks correct. It may be a browser issue.—Emil 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?Naraht (talk) 17:29, 7 October 2010 (UTC)

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. Yoenit (talk) 22:06, 17 October 2010 (UTC)

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. ---— Gadget850 (Ed) ^talk 22:35, 17 October 2010 (UTC)

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? --93.141.92.218 (talk) 09:22, 30 October 2010 (UTC)

I had converted this 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.? 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 {{nts}}.—Emil J. 12:18, 15 November 2010 (UTC)

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. --CutOffTies (talk) 01:56, 30 November 2010 (UTC)

Try using Template:Dtsh.Jason Rees (talk) 02:03, 3 December 2010 (UTC)

Thank you!! --CutOffTies (talk) 02:40, 3 December 2010 (UTC)

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? --Doradus (talk) 15:21, 19 December 2010 (UTC)

It seems to me that the HTML attribute data-sort-value= (see mediawiki implementation) makes the hidden sort templates {{hs}} and {{hid}} obsolete. Many other templates which use <span style="display:none"> … </span>, e.g. {{Sort}}, {{Sortname}}, {{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 list of plays by Nestroy. -- 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. - Vague | Rant 16:51, 1 August 2011 (UTC)

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. 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:

=== Men's singles finals ===
{|class="wikitable sortable" style=font-size:90%

• 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:

=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)))

• check it produces a valid result; the result for E1 (1930) should be:

|-<br>| 1930 || {{flagicon|United}} '''[[States Bill Tilden]] || {{flagicon|Italy}} [[Uberto de Morpurgo]] || 6–1, 6–1, 6–2

• 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:

=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)

• the result of the above for row 48 (1990) should be:

|-<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

• 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:

CONCATENAR = CONCATENATE
SE         = IF
EXATO      = EXACTLY
ESQUERDA   = LEFT
ARRUMAR    = TIDY or TRIM
PESQUISAR  = SEARCH
DIREITA    = RIGHT
NÚM.CARACT = NUM.CHARS

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 (class="wikitable sortable") 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. -- 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. Fyunck(click) (talk) 06:28, 9 June 2011 (UTC)

Type your data into an Excel spreadsheet and then when your finished use this 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.Jason Rees (talk) 16:44, 9 June 2011 (UTC)

Sometimes editors use ordinal numbers in table columns. To make such a column always sort in the expected order, it is tempting to try {{sort}}, e.g. {{sort|1|1st}}, {{sort|2|2nd}}, {{sort|10|10th}}, {{sort|1000|1000th}}, but this didn't work when I tried it. I look at Category:Sorting templates and didn't see any obvious alternatives. Any suggestions? 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:

P.S. Soon after I posted the question I tried {{sort|01|1st}}, {{sort|02|2nd}}, {{sort|10|10th}}, {{sort|1000|1000th}}, which worked. Unless there's a template that is explicitly for ordinal numbers I guess that solution is fine. 67.101.6.146 (talk) 02:56, 23 June 2011 (UTC)

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:
|- |align=left|Tommy Cavanagh||IF ||1956–1959 ||119||16||124||18|| |-
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:
|- |align=left|Tommy Cavanagh||IF ||1956–1959 ||119||16||124||18|| |-
This would guard against this but is there any way of just keeping names as they are but in unlinked text?
Thanks! Cjwilky (talk) 16:17, 25 June 2011 (UTC)

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

I tried to make this list sortable but when it didn't work properly. Can someone help me?--77.49.154.248 (talk) 19:24, 14 August 2011 (UTC)

Rows in sortable tables using colspan= 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 class="sortbottom" or even have all that text outside and below the table. -- Michael Bednarek (talk) 04:58, 15 August 2011 (UTC)

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. 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). The Rambling Man (talk) 17:07, 6 October 2011 (UTC)

OK, thanks I will do that. 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:

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) [1]. - Morinao (talk) 20:39, 22 October 2011 (UTC)

Well, I tried. If anyone else cares, this is where I'm leaving it: [2]. - Morinao (talk) 22:38, 22 October 2011 (UTC)

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. 69.91.29.178 (talk) 00:58, 8 October 2011 (UTC)

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. 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. ---— Gadget850 (Ed) ^talk 11:00, 8 October 2011 (UTC)

Thank you for your prompt response Gadget Tigerboy1966 (talk) 11:05, 8 October 2011 (UTC)

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

See meta:Help:Sorting for the new sorting features. ---— Gadget850 (Ed) ^talk 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! — kwami (talk) 06:31, 10 October 2011 (UTC)

I notice, trying the examples, that adding style="background:#cfcfcf;" to a header cell causes sorting to be disabled for that column.

although styling of cells still permits sorting

Is there a workaround for this, or are sortable table headers doomed to be plain? --Lexein (talk) 04:25, 16 October 2011 (UTC)

I reported it as a bug at bugzilla --Lexein (talk) 23:40, 19 October 2011 (UTC)

Update: The dev-suggested workaround is to use style="background-color:#cfcfcf" instead of "backgound" --Lexein (talk) 01:12, 18 December 2011 (UTC)

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? 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. — Preceding unsigned comment added by Littlebum2002 (talk • contribs) 19:21, 19 October 2011 (UTC)

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 <sup id="inlined" class="reference">[[#noted|[d]]]</sup>. Try replacing that with the standard wiki footnote markup using <ref>...,</ref> or <ref name=.../> and see if that fixes it. If not, then an explicit sort key mechanism using one of the {{sort}} templates should work, though it is a bit harder to initially write. —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 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. 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 123<ref group=a name=y /> is not recognised as a numeric value. You have to use one of the sorting templates which create hidden sort keys. -- 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. littlebum2002 12:08, 20 October 2011 (UTC)

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 this specific revision.

{{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. {{Rank}} redirects to {{Static column begin}}.

{{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.-->
|-

{{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}}

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? -- Timeshifter (talk) 12:08, 25 November 2019 (UTC)

This makes it narrow: style="padding-left:0;padding-right:0;". It gets no space between the left and right border so it looks like one thick border. PrimeHunter (talk) 00:43, 26 November 2019 (UTC)

Thanks! Here is the table with that styling added to the spanning header cell:

{{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}}

I explained all this in the documentation:

• Template:Static column begin/doc

-- 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.

{{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}}

Even better is this method using header-lines=10 parameter:

Here is how that empty spanning header is formatted so that header-lines=10 works:
!rowspan=4 class=unsortable style="padding-left:0;padding-right:0;"|<br><br><br><br><br><br><br><br><br><br>

{{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}}

-- Timeshifter (talk) 03:38, 7 December 2019 (UTC)

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

Karl-police (talk) 11:55, 6 December 2019 (UTC)

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. —TheDJ (talk • 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? 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. PrimeHunter (talk) 21:36, 7 December 2019 (UTC)

Karl-police and 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." -- Timeshifter (talk) 01:42, 9 December 2019 (UTC)

Hm? 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. -- Timeshifter (talk) 22:10, 14 December 2019 (UTC)

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? Yuliya (talk) 19:57, 2 January 2020 (UTC)

@Yuliyag: Which table are you talking about? For me works both the two tables in #Before year 100. Any date format and the second and fourth in #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). —Tacsipacsi (talk) 23:08, 2 January 2020 (UTC)

@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. Yuliya (talk) 18:06, 3 January 2020 (UTC)

@Yuliyag: I put a slightly modified version of the table in my sandbox (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 {{Hs}} for 500 BC. Johnuniq (talk) 03:07, 4 January 2020 (UTC)

Ignore that. There is a problem which I'm scratching my head over. Unfortunately when I simplify the table the problem goes away. Johnuniq (talk) 04:20, 4 January 2020 (UTC)

I fixed the example in my sandbox (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 data-sort-type="number". @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? 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. -- WOSlinker (talk) 09:25, 4 January 2020 (UTC)

@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? 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. -- Timeshifter (talk) 08:28, 5 January 2020 (UTC)

OK, no problem. I might fix it but likewise that could take some time. 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. Yuliya (talk) 20:28, 6 January 2020 (UTC)

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.Tvx1 22:22, 11 February 2020 (UTC)

Tvx1, it works for me. What browser do you use, and what are your languages settings ? —TheDJ (talk • 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. —TheDJ (talk • contribs) 23:00, 11 February 2020 (UTC)

@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. Johnuniq (talk) 02:56, 12 February 2020 (UTC)

Sorting works for me with en but not with other languages like fr. Does the en link sort wrong for you after you have clicked the column heading? 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 uselang links, and with your 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:( Johnuniq (talk) 04:12, 12 February 2020 (UTC)

@TheDJ:, you're right. My interface language is set to my native Dutch. When I switch to English the sorting works fine.Tvx1 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. PrimeHunter (talk) 19:58, 12 February 2020 (UTC)

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! -- 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. PrimeHunter (talk) 14:16, 27 March 2020 (UTC)

Yeah that's the one. Don't know why I typed #6 above - brain fart, clearly ;-) -- ChrisTheDude (talk) 14:32, 27 March 2020 (UTC)

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?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. — GhostInTheMachine ^{talk to me} 23:00, 29 June 2020 (UTC)

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? Skyerise (talk) 22:00, 5 September 2020 (UTC)

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? -- PK2 (talk) 22:07, 21 August 2020 (UTC)

PK2, I don't think Module:AutosortTable is really being used much, if at all. See: "What links here":

Special:WhatLinksHere/Module:AutosortTable

--Timeshifter (talk) 03:53, 23 August 2020 (UTC)

PK2. There is more discussion at Help talk:Table. --Timeshifter (talk) 06:43, 6 September 2020 (UTC)

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? {{u|Sdkb}} ^talk 21:07, 21 September 2020 (UTC)

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.Skeletonwizard8 (talk) 21:58, 20 January 2021 (UTC)

Skeletonwizard8 changed rowspan="5" in the final row to rowspan="3". It was upset by the missing 2 rows — GhostInTheMachine ^{talk to me} 22:59, 20 January 2021 (UTC)

ThanksSkeletonwizard8 (talk) 17:36, 21 January 2021 (UTC)

I'm seeing {{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? —Joeyconnick (talk) 02:52, 25 March 2021 (UTC)

@Joeyconnick: You wrote data-source-value in the article. Fixed in [3]. PrimeHunter (talk) 11:10, 25 March 2021 (UTC)

Oh my gosh... sorry! That would explain things. *sigh* —Joeyconnick (talk) 18:47, 25 March 2021 (UTC)

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 BrightOrion | talk 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 {{hidden sort key}} in front of the displayed text. Sort by the {{age in days}} should work. I have added sort keys like this {{Hidden sort key|{{age in days|1995|8|7}}}}{{age in years and months |1995|8|7}}, but please check that I copied the dates correctly — GhostInTheMachine ^{talk to me} 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? BrightOrion | talk 14:45, 6 August 2021 (UTC)

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.
... ||data-sort-value="{{age in days|1952|7|23|1953|7|19}}" | {{Age in years, months and days|1952|7|23|1953|7|19}} etc.15:29, 6 August 2021 (UTC) — GhostInTheMachine ^{talk to me}

Perfect! The table seems to be OK now. Thanks! BrightOrion | talk 16:35, 6 August 2021 (UTC)

Hello. I regularly see sortable tables like 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, Number 57 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 style="background-color:... 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.

Province	PvdA	CDA	VVD	D'66	SGP	CPN	PPR	GPV	PSP	BP	DS'70	Others
Drenthe	41.5	27.1	18.2	4.4	0.4	1.2	1.4	1.8	0.6	1.3	0.6	1.5
Friesland	37.3	37.4	12.3	4.4	0.9	1.5	1.3	1.6	0.8	0.6	0.6	1.3
Gelderland	30.8	35.5	17.2	4.8	3.7	0.6	1.7	0.7	0.9	1.4	0.5	2.2
Groningen	42.4	24.3	14.4	4.4	0.3	4.3	1.9	4.0	1.3	0.7	0.6	1.4
Limburg	30.1	44.6	14.7	3.3	0.1	1.1	1.9	0.1	0.7	1.0	0.4	2.0
North Brabant	28.8	43.7	15.7	5.0	0.5	0.6	1.6	0.2	0.8	1.1	0.5	1.5
North Holland	35.4	22.9	21.7	7.3	0.5	4.5	2.1	0.4	1.5	0.6	1.2	1.9
Overijssel	31.0	39.5	13.2	4.2	2.9	1.1	1.3	2.2	0.5	1.2	0.4	2.5
South Holland	37.9	24.6	19.9	6.1	3.8	1.3	1.5	0.8	0.8	0.4	0.9	2.0
Southern IJsselmeer Polders	33.1	29.0	18.9	6.7	1.0	2.9	2.8	1.3	0.6	0.6	0.7	2.4
Utrecht	28.2	30.5	22.1	6.6	3.2	0.9	1.9	1.6	1.3	0.7	0.7	2.3
Zeeland	32.6	29.8	17.3	4.4	8.4	0.4	1.5	1.6	0.5	1.0	0.6	1.9

----

Province												Others
	PvdA	CDA	VVD	D'66	SGP	CPN	PPR	GPV	PSP	BP	DS'70
Drenthe	41.5	27.1	18.2	4.4	0.4	1.2	1.4	1.8	0.6	1.3	0.6	1.5
Friesland	37.3	37.4	12.3	4.4	0.9	1.5	1.3	1.6	0.8	0.6	0.6	1.3
Gelderland	30.8	35.5	17.2	4.8	3.7	0.6	1.7	0.7	0.9	1.4	0.5	2.2
Groningen	42.4	24.3	14.4	4.4	0.3	4.3	1.9	4.0	1.3	0.7	0.6	1.4
Limburg	30.1	44.6	14.7	3.3	0.1	1.1	1.9	0.1	0.7	1.0	0.4	2.0
North Brabant	28.8	43.7	15.7	5.0	0.5	0.6	1.6	0.2	0.8	1.1	0.5	1.5
North Holland	35.4	22.9	21.7	7.3	0.5	4.5	2.1	0.4	1.5	0.6	1.2	1.9
Overijssel	31.0	39.5	13.2	4.2	2.9	1.1	1.3	2.2	0.5	1.2	0.4	2.5
South Holland	37.9	24.6	19.9	6.1	3.8	1.3	1.5	0.8	0.8	0.4	0.9	2.0
Southern IJsselmeer Polders	33.1	29.0	18.9	6.7	1.0	2.9	2.8	1.3	0.6	0.6	0.7	2.4
Utrecht	28.2	30.5	22.1	6.6	3.2	0.9	1.9	1.6	1.3	0.7	0.7	2.3
Zeeland	32.6	29.8	17.3	4.4	8.4	0.4	1.5	1.6	0.5	1.0	0.6	1.9

--Timeshifter (talk) 00:06, 25 October 2021 (UTC)

You can make it a non-header row with class="sorttop" 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. PrimeHunter (talk) 00:11, 25 October 2021 (UTC)

Province	PvdA	CDA	VVD	D'66	SGP	CPN	PPR	GPV	PSP	BP	DS'70	Others
Drenthe	41.5	27.1	18.2	4.4	0.4	1.2	1.4	1.8	0.6	1.3	0.6	1.5
Friesland	37.3	37.4	12.3	4.4	0.9	1.5	1.3	1.6	0.8	0.6	0.6	1.3
Gelderland	30.8	35.5	17.2	4.8	3.7	0.6	1.7	0.7	0.9	1.4	0.5	2.2
Groningen	42.4	24.3	14.4	4.4	0.3	4.3	1.9	4.0	1.3	0.7	0.6	1.4
Limburg	30.1	44.6	14.7	3.3	0.1	1.1	1.9	0.1	0.7	1.0	0.4	2.0
North Brabant	28.8	43.7	15.7	5.0	0.5	0.6	1.6	0.2	0.8	1.1	0.5	1.5
North Holland	35.4	22.9	21.7	7.3	0.5	4.5	2.1	0.4	1.5	0.6	1.2	1.9
Overijssel	31.0	39.5	13.2	4.2	2.9	1.1	1.3	2.2	0.5	1.2	0.4	2.5
South Holland	37.9	24.6	19.9	6.1	3.8	1.3	1.5	0.8	0.8	0.4	0.9	2.0
Southern IJsselmeer Polders	33.1	29.0	18.9	6.7	1.0	2.9	2.8	1.3	0.6	0.6	0.7	2.4
Utrecht	28.2	30.5	22.1	6.6	3.2	0.9	1.9	1.6	1.3	0.7	0.7	2.3
Zeeland	32.6	29.8	17.3	4.4	8.4	0.4	1.5	1.6	0.5	1.0	0.6	1.9

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. --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). 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. Jroberson108 (talk) 06:31, 12 February 2022 (UTC)

As reported by Emanuele676 in 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? --Fernando Trebien (talk) 02:14, 3 June 2022 (UTC)

It's mentioned at Help:Sorting#Month names and phab:T126744. PrimeHunter (talk) 11:47, 3 June 2022 (UTC)

Thank you! --Fernando Trebien (talk) 16:07, 3 June 2022 (UTC)

@PrimeHunter: Wrapping the dates with {{dts}} seems to work around the issue while increasing editing complexity. Maybe we could mention this in Help:Sorting § Month names? --Fernando Trebien (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. PrimeHunter (talk) 19:24, 3 June 2022 (UTC)

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! Facts707 (talk) 13:31, 14 April 2022 (UTC)

Responding late, but better late than never. @Facts707, {{unsorted list}} is the template you are looking for. 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, 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, Qwerty284651 (talk) 22:07, 30 October 2022 (UTC)

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. — kwami (talk) 07:54, 29 November 2022 (UTC)

@Kwamikagami: Looks like you had Dysnomia's "data-sort-value" set to {{val|2.1. I changed it to {{val|2.1}}, which sorts properly now. 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. — kwami (talk) 16:20, 29 November 2022 (UTC)

@Kwamikagami: Also, I suggest changing the format of the value to match the others for consistency sake from 1.8–2.4 to 2.1±0.3. By doing this, you won't need to specify a "data-sort-value" like the others. Jroberson108 (talk) 13:28, 29 November 2022 (UTC)

I moved this from Help:Sorting to Help:Sortable tables. The entire page is about sortable tables, not about sorting data in general (sorting lists, sorting stubs, etc.). Cheers, Manifestation (talk) 20:22, 13 February 2023 (UTC)

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. --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 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. --Timeshifter (talk) 05:23, 7 March 2023 (UTC)

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. --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 "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. — JohnFromPinckney (talk / edits) 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. --Timeshifter (talk) 16:55, 16 March 2023 (UTC)

This saves most people time.^{[citation needed]} 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 <th> markup (via !), you do all interested editors a disservice. — JohnFromPinckney (talk / edits) 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. --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 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. —TheDJ (talk • contribs) 22:06, 17 March 2023 (UTC)

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. --Timeshifter (talk) 04:00, 18 March 2023 (UTC)

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

Album

19
19
21
21
21
21
193
215
Everything Is New
Love & War
Matinée

But if it is sorting lexically, shouldn't 193 come before 21? Since the character '1' comes lexically before '2'. Keith D. Tyler ¶ 08:55, 16 March 2023 (UTC)

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).

--Timeshifter (talk) 12:20, 16 March 2023 (UTC)

I asked at Wikipedia:Village pump (technical). --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 —TheDJ (talk • contribs) 13:42, 16 March 2023 (UTC)

TheDJ. Is "number preservation" what natural sort order uses? --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. —TheDJ (talk • contribs) 14:01, 16 March 2023 (UTC)

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? --Timeshifter (talk) 14:21, 16 March 2023 (UTC)

Correct. —TheDJ (talk • 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? Keith D. Tyler ¶ 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. - Keith D. Tyler ¶ 18:28, 5 April 2023 (UTC)

KeithTyler and 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

--Timeshifter (talk) 02:01, 18 March 2023 (UTC)

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 sortname template. 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. MessiIsMyBezzie (talk) 22:04, 26 April 2023 (UTC)

See discussion at Help talk:Table. --Timeshifter (talk) 00:34, 4 May 2023 (UTC)

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 Akeosnhaoe (talk) 15:29, 24 July 2023 (UTC)

See: Help:Sortable table#Before year 100. Any date format (no longer works).

Can you provide some examples below of what you are trying to sort? A small table, for example. --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. 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. --Timeshifter (talk) 17:22, 24 July 2023 (UTC)

I observed a problem in instances of {{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? SFB 20:48, 23 August 2023 (UTC)

Standard wikitable, caption before columns

Standard wikitable, caption after columns

Sortable wikitable, caption before columns

Sortable wikitable, caption after columns

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. Only between table start and first table row. Jroberson108 (talk) 21:59, 23 August 2023 (UTC)

Sillyfolkboy. Could you give examples using {{AchievementTable}}? --Timeshifter (talk) 02:15, 24 August 2023 (UTC)

Timeshifter See previous example on Mo Farah 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. SFB 10:56, 24 August 2023 (UTC)

@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. Search results. On the Christian Coleman page, there are two such tables like this: International competitions and 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. Jroberson108 (talk) 22:01, 24 August 2023 (UTC)

@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... SFB 17:46, 25 August 2023 (UTC)

@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. Jroberson108 (talk) 18:48, 25 August 2023 (UTC)

@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. SFB 20:37, 25 August 2023 (UTC)

@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? 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. Jroberson108 (talk) 22:44, 25 August 2023 (UTC)

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.
• 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. --Timeshifter (talk) 05:26, 25 August 2023 (UTC)

@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! SFB 17:46, 25 August 2023 (UTC)

Can someone knowledgeable can lend a hand here, please: Talk:List_of_historical_earthquakes#Date_Ordering. Thanks! fgnievinski (talk) 00:44, 6 September 2023 (UTC)

Fixed. Jroberson108 (talk) 01:50, 6 September 2023 (UTC)

 You are invited to join the discussion at Wikipedia:User scripts/Requests § Sortkeys in lists. {{u|Sdkb}} ^talk 15:40, 12 January 2024 (UTC)

Resolved

I created the {{sort under}} template to reposition the sorting arrows under the text without the issues that come with adding sorting buttons in a separate row. Please review and mention any issues on its talk page. 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. --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

--Timeshifter (talk) 14:11, 4 February 2024 (UTC)

see Help:Sortable tables#Forcing a column to have a particular data type: data-sort-type=text uses alphabetical sorting of text, but numbers are sorted numerically within that alphabetical sorting.
Isn't there any possibility to get a column sorted strictly alphabetically instead of Natural sort order, so 0R11 before 0R9 ?
Many thanks, Aspiriniks (talk) 11:38, 17 April 2024 (UTC)
P.S. I see there was a related discussion one year ago at Help_talk:Sortable_tables/Archive_4#data-sort-type=text_doesn't_seem_to_work_properly - any news since then? -- Aspiriniks (talk) 11:56, 17 April 2024 (UTC)

@Aspiriniks: You might want to ask at WP:VPT or WP:Phabricator. --Timeshifter (talk) 14:44, 18 April 2024 (UTC)

@Aspiriniks: You'll need to adjust the cell's sort value to get the desired order. For "0R9", change it to | data-sort-value=0R90 | 0R9 to sort as: 0R11, 0R12, 0R9. A similar sort value would be needed for any other cell values that aren't four characters long. Jroberson108 (talk) 04:52, 19 April 2024 (UTC)

Hello, regarding List of cult films: K, it seems like the listings The Killer and The Killing, both which neighbor listings that have longer titles starting with Killer or Killing, wind up at the bottom of each respective group when sorting alphabetically, when they should come first, having nothing after that keyword. Am I doing something wrong? Is there a way to fix it? Erik (talk | contrib) ^{(ping me)} 14:24, 23 May 2024 (UTC)

I guess I fixed it by adding two spaces after each title, but this feels like too much of a hack. Is there a proper way to do this? Erik (talk | contrib) ^{(ping me)} 14:26, 23 May 2024 (UTC)

No idea. Maybe ask at {{sortname}} too. --Timeshifter (talk) 14:50, 23 May 2024 (UTC)

I considered that, but it redirects to Template talk:Sort, which does not seem very active. Other suggestions for places to ask would be great. Erik (talk | contrib) ^{(ping me)} 14:52, 23 May 2024 (UTC)

Maybe WP:VPT. --Timeshifter (talk) 15:47, 23 May 2024 (UTC)

Sorting the following table with class=sortbottom for the bottom 2 rows removes the blank rows, displaying thusly. Qwerty284651 (talk) 21:13, 1 July 2024 (UTC)

The rowspan number was wrong. I temporarily added {{static row numbers}} to see that. Also, I added dashes in the blank spots in the bottom 2 rows. Both changes were needed to fix the problem. See diff.

An easier solution is to eliminate the blank columns. And list those years above the table. It would also make the table narrower. --Timeshifter (talk) 06:53, 2 July 2024 (UTC)

Yeah, that's the alternative I had with removing the years and adding a note above the table about the skipped years. Btw, why does static row display blank without bgcolor? Qwerty284651 (talk) 12:56, 2 July 2024 (UTC)

I just created Template:Year in date-sorted table as the inverse of Template:Date table sorting. I welcome input if there are better solutions to achieve the same goal, additional features that would be useful, and or suggestions for a more descriptive template name. Daask (talk) 20:24, 16 July 2024 (UTC)

You might get more discussion at Help talk:Table or WP:VPT. I am not really into this now. --Timeshifter (talk) 00:27, 18 July 2024 (UTC)