![]() | This is an archive of past discussions. 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. |
Archive 1 | Archive 2 | Archive 3 | Archive 4 |
How do I reverse order sort based on the order of the items in the list? I want to reverse the order of the items irrespective of date, currency, numeric, or string, but only by how the items first appear on the list. XP1 ( talk) 23:54, 12 April 2009 (UTC)
wikibits.js can be improved to include more date formats and trim leading/trailing spaces from dates. I've taken a stab at a couple of improvements outlined below
if (/^\d\d[\/. -][a-zA-Z]{3}[\/. -]\d\d\d\d$/.test(itm)) {
to
if (/^\d\d[\/. -]?[a-zA-Z]{3}[\/. -]?\d\d\d\d$/.test(itm)) {
Add the following before the first line of "ts_dateToSortKey"
date= date.replace(/^\s\s*/, ).replace(/\s\s*$/, ); if (date.length ==9){ date = date.substr(0,2)+" " + date.substr(2,3)+" "+ date.substr(5); }
-- Bala ( talk) 19:30, 20 March 2009 (UTC)
I saw that {{ Dts}} was copied from m:Template:Dts. Help:Sorting is pretty cool stuff. But since I'm a lazy programmer and wikieditor, I'm always looking for a way to cut corners. Check out {{ User:MrDolomite/Sandbox/Dts}} and let me know what you all think. — MrDolomite | Talk 18:04, 11 January 2007 (UTC)
Is it possible (or would it be possible) for cells to have a sort key different from that which is displayed? I want to make List of Liverpool F.C. players sortable, but for it to be useful I really need:
-- ArtVandelay13 13:19, 11 February 2007 (UTC)
The script, while ingenious, doesn't work very well with headers spanning over several columns, effectively screwing up List of members of the Riksdag, 2002-2006 by requiring a separate header for the colors (resulting in that column being unnecessarily wide). Solution, anyone? Jobjörn ( Talk ° contribs) 21:03, 22 February 2007 (UTC)
For some reason I'm no longer able to get tables in WP to obey the instruction class="wikitable sortable"
. Is this a known problem? JavaScript is not disabled on my system.
It must be something to do with my WP Preferences, because the problem disappears when I log out. I don't remember changing anything in the Prefs, however: any suggestions? I've tried bypassing my cache, but that didn't help.
What would I need to do (or have done) to disable the "sortable" property on my computer? -- NigelG (or Ndsg) | Talk 09:41, 13 March 2007 (UTC)
I started a discussion at Template talk:Sort, since there seem to be a number of unconnected efforts to create sortkeys for sortable wikitables. ~ trialsanderrors 23:21, 2 April 2007 (UTC)
I've read this page and looked at the code in the example table, but I don't quite get what is the best way to get numbers of varying lengths to sort properly (i.e. for 17,000,000 to show up as larger than 900,000). In particular, I would like to fix the attendance numbers at List of sports attendance figures. Thanks for any help. — Reinyday, 00:15, 5 April 2007 (UTC)
Do you plan to ultimately use
datagrid
?
David Latapie (
✒ |
@) —
www
19:35, 10 April 2007 (UTC)
I need the correct code for Instructions_per_second anywere can help? -- FidelFair 04:13, 6 May 2007 (UTC)
Processor | IPS (sortable don´t work?) | Year | Source |
---|---|---|---|
Pencil and Paper | 0.0119 IPS | 1892 | [1] |
IBM System/370 model 158-3 | 1 MIPS | 1972 | |
Intel 8080 | 640 kIPS at 2 MHz | 1974 | |
VAX 11/780 | 500 kIPS | 1977 | |
Motorola 68000 | 1 MIPS at 8 MHz | 1979 | |
Intel 386DX | 8.5 MIPS at 25 MHz | 1988 | |
Intel 486DX | 54 MIPS at 66 MHz | 1992 | |
PowerPC 600s (G2) | 35 MIPS at 33 MHz | 1994 | |
Intel Pentium Pro | 541 MIPS at 200 MHz | 1996 | [2] |
ARM 7500FE | 35.9 MIPS at 40 MHz | 1996 | |
PowerPC G3 | 525 MIPS at 233 MHz | 1997 | |
Zilog eZ80 | 80 MIPS at 50 MHz | 1999 | [3] |
Intel Pentium III | 1354 MIPS at 500 MHz | 1999 | |
AMD Athlon | 3561 MIPS at 1.2 GHz | 2000 | |
AMD Athlon XP 2400+ | 5935 MIPS at 2.0 GHz | 2002 | |
Pentium 4 Extreme Edition | 9726 MIPS at 3.2 GHz | 2003 | |
ARM Cortex A8 | 2000 MIPS at 1.0 GHz | 2005 | [4] |
Xbox360 IBM "Xenon" Triple Core | 6400 MIPS at 3.2 GHz | 2005 | |
AMD Athlon FX-57 | 12000 MIPS at 2.8 GHz | 2005 | |
AMD Athlon 64 3800+ X2 (Dual Core) | 14564 MIPS at 2.0 GHz | 2005 | [5] |
AMD Athlon FX-60 (Dual Core) | 18938 MIPS at 2.6 GHz | 2006 | [6] |
Intel Core 2 X6800 | 27079 MIPS at 2.93 GHz | 2006 | [7] |
IBM Cell one SPE | 25600 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
IBM Cell one PPE | 51200 MIPS (38400 MFLOPS)at 3.2 GHz | 2006 | |
IBM Cell BE (1PPE + 8SPEs) | 256000 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
SONY PS3 (1PPE + 7SPEs) | 230400 MIPS (217600 MFLOPS) at 3.2 GHz | 2006 | |
Intel Core 2 Extreme QX6700 | 57063 MIPS at 3.33 GHz | 2006 | [8] |
Processor | IPS | Year | Source |
---|---|---|---|
Pencil and Paper | 0.0119 IPS | 1892 | [9] |
IBM System/370 model 158-3 | 1 MIPS | 1972 | |
Intel 8080 | 640 kIPS at 2 MHz | 1974 | |
VAX 11/780 | 500 kIPS | 1977 | |
Motorola 68000 | 1 MIPS at 8 MHz | 1979 | |
Intel 386DX | 8.5 MIPS at 25 MHz | 1988 | |
Intel 486DX | 54 MIPS at 66 MHz | 1992 | |
PowerPC 600s (G2) | 35 MIPS at 33 MHz | 1994 | |
Intel Pentium Pro | 541 MIPS at 200 MHz | 1996 | [10] |
ARM 7500FE | 35.9 MIPS at 40 MHz | 1996 | |
PowerPC G3 | 525 MIPS at 233 MHz | 1997 | |
Zilog eZ80 | 80 MIPS at 50 MHz | 1999 | [11] |
Intel Pentium III | 1354 MIPS at 500 MHz | 1999 | |
AMD Athlon | 3561 MIPS at 1.2 GHz | 2000 | |
AMD Athlon XP 2400+ | 5935 MIPS at 2.0 GHz | 2002 | |
Pentium 4 Extreme Edition | 9726 MIPS at 3.2 GHz | 2003 | |
ARM Cortex A8 | 2000 MIPS at 1.0 GHz | 2005 | [12] |
Xbox360 IBM "Xenon" Triple Core | 6400 MIPS at 3.2 GHz | 2005 | |
AMD Athlon FX-57 | 12000 MIPS at 2.8 GHz | 2005 | |
AMD Athlon 64 3800+ X2 (Dual Core) | 14564 MIPS at 2.0 GHz | 2005 | [13] |
AMD Athlon FX-60 (Dual Core) | 18938 MIPS at 2.6 GHz | 2006 | [14] |
Intel Core 2 X6800 | 27079 MIPS at 2.93 GHz | 2006 | [15] |
IBM Cell one SPE | 25600 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
IBM Cell one PPE | 51200 MIPS (38400 MFLOPS)at 3.2 GHz | 2006 | |
IBM Cell BE (1PPE + 8SPEs) | 256000 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
SONY PS3 (1PPE + 7SPEs) | 230400 MIPS (217600 MFLOPS) at 3.2 GHz | 2006 | |
Intel Core 2 Extreme QX6700 | 57063 MIPS at 3.33 GHz | 2006 | [16] |
Is it possible to get a collapsable and sortable table? ∞ ΣɛÞ² ( τ| c) 12:30, 26 May 2007 (UTC)
Header 1 | Header 2 | Header 3 |
---|---|---|
A1 | B1 | C1 |
A2 | B2 | C2 |
Collapsible table
|
---|
I've made a sortable wikitable for a "crimes against humanity" table, here, but I couldn't get the estimates columns to sort properly. I know what the problem is in part, which is that because there are references together with the estimates in the first cell, the sort table reads as an alphabetic table instead of a numeric one.
The Help page says you just have to finish your cell with the code "sm=n" to make the sorting in such cases numeric, but it doesn't work. I found another way of making the table work by creating hidden rows at the top and bottom of the table with very high and low numbers respectively, but it's a kludgy fix and doesn't work right under all conditions.
Can someone please show me how to get this "sm=n" method to work? Thanks, Gatoclass 16:45, 15 June 2007 (UTC)
I have added the sm=n to the List of Aston Villa F.C. players article but the goals and appearances sections are still not listing properly. For the appearances section anyway it seems to be those numbers that are under 100. Can anyone help? Thanks Woodym555 14:11, 4 August 2007 (UTC)
I am trying to create number parameters for sorting. (Ex. sorting_table|table1|5|10, 5 being the number of rows and 10 being the number of colums). Is that even possible? I would like to be able to add or remove rows so a generic sorting template can be used for many different articles. The articles will have similar information but different names.
-- Ricky.Garcia 16:50, 7 August 2007 (UTC)
I just thought I should point out that as of time of writing some of the examples don't work in this version of the page (the initial sort is incorrect although second and subsequent sorts are correct) although they do on the meta original, so I guess something needs updating. -- 80.175.250.218 08:53, 9 August 2007 (UTC)
Can someone please look at the table here and check why the goal difference column does not sort correctly? Thanks in advance. Madcynic 10:06, 7 October 2007 (UTC)
Hi! I recently created my first table, which a fellow editor converted to a sorting table. Problem is, we're seeing different things when we click the sort buttons! He's getting proper sorting in all columns, while only the first column sorts (ascending/descending) for me—regardless of which column's header I click on. Why would that be? The page in question is Wikipedia:WikiProject_Birds/Country_lists. I'm on Mac OSX10.4.10, using Safari. Help! MeegsC | Talk 13:10, 6 November 2007 (UTC)
Hi,
I would like to know if it's possible to hide something in a sorting table.
Ex:
How I can sort byu last name
Name |
---|
Bob Dubois |
Roger Smith |
Frank Desmarais |
Thank! Riba en ( talk) 20:10, 9 December 2007 (UTC)
Could anyone tell me why this table is not sorting properly? We want to be able to sort by date. Various people over here have said that the sorting does not work for them. Thank you, Fang Aili talk 03:41, 16 December 2007 (UTC)
User Name | Date of Original Request | Last date page visited | Wiki areas of interest | Article areas of interest | Requestor comments | Contact log/Notes |
---|---|---|---|---|---|---|
Robotam ( talk · contribs) | 31 July 2004 | Been active for some time, I believe I have given positive contributions, but I want to make sure I have not developed "tunnel vision." I would definitely appreciate wiki mentoring to do even more, and do it the right way.RoBoTam ice 20:29, 31 July 2007 (UTC) | ||||
Lemonflash ( talk · contribs) | 1 August 2007 | I'm an active contributer to Wikipedia, and wish to be an admin some day. Lemonflash talk 01:03, 1 August 2007 (UTC) | ||||
Andyroo g ( talk · contribs) | 25 July 2002 | I have wanted to be an admin for some time now, and would like to get some training to do so. I realise it is cliched, but i do truly have a misleadingly low edit count compared to my true amount of edits as a result of a large amount of edits whilst not signed in Andyroo g 18:46, 25 July 2007 (UTC) | ||||
Violask81976 ( talk · contribs) | 20 July 2007 | Want some guidance. - Viola sk8 1976 15:15, 20 July 2007 (UTC) | ||||
geniussansom ( talk · contribs) | 16 July 2001 | Would like some guidance on expanding the articles which I edit and would like to be an admin at some point in the future -- geniussansom 15:34, 16 July 2007 (UTC) | ||||
Someguy1221 ( talk · contribs) | 11 July 2007 | Looking to be an admin, and I think I might need some advice. Someguy1221 08:47, 27 April 2007 (UTC). Still interested. Someguy1221 07:08, 11 July 2007 (UTC) | ||||
Flubeca ( talk · contribs) | 10 July 2009 | I want to become an admin :) - Flubeca Talk 19:02, 10 July 2007 (UTC) | ||||
Son ( talk · contribs) | 9 July 2007 | I've been on en.wikipedia since December 2005 with some IP editing before that, and I'd like to become an admin. I definitely need some improvement, and I've gotten more invovled in XfDs and RfCs. -- myselfalso 19:22, 9 July 2007 (UTC) | ||||
Nwwaew ( talk · contribs) | 23 June 2000 | I want to see what I'm doing right, and what I need to improve to become an admin, and stand a chance at WP:RfA. This is what I think is the best course of action. Nwwaew ( Talk Page) ( Contribs) ( E-mail me) 13:39, 23 June 2007 (UTC) |
{{dts|day|month|year}}
in place of the date values. It produces an invisible sortable date and displays it formatted correctly according to user preferences. —
EncMstr
03:54, 16 December 2007 (UTC)
When I have a column with a negative number, it sorts ok ascendingly, but sorts alphabetically descendingly. Is this a javascript problem? I've tried so many suggestions - none have worked -- JimWae ( talk) 08:30, 24 December 2007 (UTC)
I was hoping to use dates in a sortable table without specifying the year (i.e. 1 January), but I can't figure out how to do it and get the table to sort properly. I tried {{ Dts}}, but year seems to be a requirement. Any help would be appreciated! PC78 ( talk) 21:21, 22 February 2008 (UTC)
I'd like to add a header above the sortable row on the table in the Statewide polling article. Basically, above the first Clinton/Obama/Other columns I'd like to add a "Polling data" column (with colspan="3") and above the second Clinton/Obama/Other columns I'd like to add a "Delegates won" column (with colspan="3"). The "Date", "State", and "Delegates" column would ideally be modified to have rowspan="2". Can anyone help me do this? Andareed ( talk) 22:28, 8 March 2008 (UTC)
Clicking the sort button messes up this table by sorting the numbers by digit rather than by number. How do I make it recognize that 10 is bigger than 2? Is there a parameter that makes it look at numbers differently? Thanks. -- Arctic Gnome ( talk • contribs) 04:50, 20 March 2008 (UTC)
Number of years |
---|
1 year |
2 years |
5 years |
10 years |
20 years |
25 years |
Number of years |
---|
1 year |
2 years |
5 years |
10 years |
20 years |
25 years |
{{sort|
what to sort by|
what to display}}
. I thought it was smarter about accepting numbers, but to make the example work, I used leading zeros so a lexicographic sort works okay. Perhaps there's another form of the sort template which deals with numbers more intuitively. —
EncMstr
05:00, 20 March 2008 (UTC)How can this be done? Example: Opinion polling for the United States presidential election, 2008 -- Kallahan ( talk) 21:11, 26 March 2008 (UTC)
Poll Source | Date administered | Democrat | % | Republican | % |
---|---|---|---|---|---|
Rasmussen Reports Tracking | March 25-28, 2008 | Hillary Clinton | 40% | John McCain | 51% |
Barack Obama | 43% | John McCain | 48% | ||
Gallup Tracking | March 24-28, 2008 | Hillary Clinton | 44% | John McCain | 48% |
Barack Obama | 44% | John McCain | 46% | ||
NBC News/Wall Street Journal | March 24-25, 2008 | Hillary Clinton | 44% | John McCain | 46% |
Barack Obama | 44% | John McCain | 42% | ||
Pew Research Center | March 19-22, 2008 | Hillary Clinton | 49% | John McCain | 44% |
Barack Obama | 49% | John McCain | 43% | ||
Fox News/Opinion Dynamics | March 18-19, 2008 | Hillary Clinton | 46% | John McCain | 43% |
Barack Obama | 43% | John McCain | 44% | ||
CBS News | March 15-18, 2008 | Hillary Clinton | 46% | John McCain | 44% |
Barack Obama | 44% | John McCain | 46% |
Poll Source | Date administered | Democrat | % | Republican | % |
---|---|---|---|---|---|
Rasmussen Reports Tracking | March 25-28, 2008 | Hillary Clinton | 40% | John McCain | 51% |
Barack Obama | 43% | John McCain | 48% | ||
Gallup Tracking | March 24-28, 2008 | Hillary Clinton | 44% | John McCain | 48% |
Barack Obama | 44% | John McCain | 46% | ||
NBC News/Wall Street Journal | March 24-25, 2008 | Hillary Clinton | 44% | John McCain | 46% |
Barack Obama | 44% | John McCain | 42% | ||
Pew Research Center | March 19-22, 2008 | Hillary Clinton | 49% | John McCain | 44% |
Barack Obama | 49% | John McCain | 43% | ||
Fox News/Opinion Dynamics | March 18-19, 2008 | Hillary Clinton | 46% | John McCain | 43% |
Barack Obama | 43% | John McCain | 44% | ||
CBS News | March 15-18, 2008 | Hillary Clinton | 46% | John McCain | 44% |
Barack Obama | 44% | John McCain | 46% |
Poll Source | Date administered | Democrat | % | Republican | % |
---|---|---|---|---|---|
Rasmussen Reports Tracking | March 25-28, 2008 | Hillary Clinton Barack Obama |
40% 43% |
John McCain | 51% |
Gallup Tracking | March 24-28, 2008 | Hillary Clinton Barack Obama |
44% 44% |
John McCain | 48% 46% |
NBC News/Wall Street Journal | March 24-25, 2008 | Hillary Clinton Barack Obama |
44% 44% |
John McCain | 46% 42% |
Pew Research Center | March 19-22, 2008 | Hillary Clinton Barack Obama |
49% | John McCain | 44% 43% |
Fox News/Opinion Dynamics | March 18-19, 2008 | Hillary Clinton Barack Obama |
46% 43% |
John McCain | 43% |
CBS News | March 15-18, 2008 | Hillary Clinton Barack Obama |
46% 44% |
John McCain | 44% 46% |
I have started a wikitable using this format and I'm way over my head now. I want to display the endorsements for presidential candidates in the GOP 2012 race. Check it here Endorsements for the Republican Party presidential primaries, 2012 Unfortunately, the numbers are easier to place than the names. I want to put the names in collapsible rows so people can read the numbers and verify the endorsements by checking a row below. Please help. :-< -- Screwball23 talk 02:58, 27 October 2011 (UTC)
I think that my question is very simple but I couldn't find the answer myself... Is it possible to add some parameter that with one click table would be sorted in a descending order? Niktute ( talk) 22:43, 30 November 2011 (UTC)
There is a problem while sorting the "HS" column in this article. A few en-dashes come before "0". I'm unable to figure out the problem. Any help will be much appreciated. — Commander (Ping me) 17:15, 3 January 2012 (UTC)
Hi, all. I can't seem to get the table at List of countries by net international investment position to order by the "NIIP in % GDP" column as numeric - it always sorts it as characters instead.
All the entries in that column are numeric. Some have a leading plus sign, leading minus, and/or a leading zero, and many have references. But this should not bother the numeric sorting.
Any help would be greatly appreciated! Thanks! Facts707 ( talk) 19:49, 14 February 2012 (UTC)
I was working with List of maria on the Moon. Is there any reasonable way to sort latitude and longitude numerically instead of alphabetically? For example, getting it to treat °N as a negative number and °S as positive so the list would start with the northernmost entry and end with the most southerly. Thanks! Aubri ( talk) 18:52, 21 March 2012 (UTC)
{| class="wikitable sortable" ! Latin name ! Lat. ! Long. |- | [[Mare Anguis]] |align="right"|{{Hs|-226}} 22.6° N |align="right"|{{Hs|677}} 67.7° E |- | [[Mare Australe]] |align="right"|{{Hs|389}} 38.9° S |align="right"|{{Hs|930}} 93.0° E |- | [[Mare Cognitum]] |align="right"|{{Hs|100}} 10.0° S |align="right"|{{Hs|-231}} 23.1° W |- | [[Mare Crisium]] |align="right"|{{Hs|-170}} 17.0° N |align="right"|{{Hs|591}} 59.1° E |}
Latin name | Lat. | Long. |
---|---|---|
Mare Anguis | 22.6° N | 67.7° E |
Mare Australe | 38.9° S | 93.0° E |
Mare Cognitum | 10.0° S | 23.1° W |
Mare Crisium | 17.0° N | 59.1° E |
I was trying to use a sortable table with one of the headers extending the length of the table. Here is the table: User:B2project/sandbox2
I'd like to keep the table sortable so I can change the order to determine leaders and would like to keep the break in it to clean up the table but I can't seem to get the header row to extend the rest of the table. Does anyone know if this is possible? Any help would be appreciated. Thanks.
♣ B2project ♣ (Talk) 23:18, 16 April 2012 (UTC)
I see this was answered a couple of years ago, but in case anything has changed I'll ask again:
I want to include a "X see Y" crossref in column 1, which is a list of names of hills where just a couple have two names, but I then don't want "X" to have any content in the other cols and want it to sort down to the bottom. Can it be done? ( The Outlying Fells of Lakeland, "Cartmel Fell see Raven's Barrow", if you're interested in the exact example). Pam D 14:31, 2 May 2012 (UTC)
I've replaced the section "Initial alphabetical sort versus initial sort by rank order" because it was suggesting people remove rank columns and sort lists alphabetically, because it would make the list easier to update. This is inappropriate as it suggests removing a useful feature for readers in order to accommodate to editors. I have instead put together a how-to on updating lists sorted by rank. Pristino ( talk) 11:25, 7 June 2012 (UTC)
Hi, I'm having some issues with a sortable table that I'm working on here. It looks nice, but it doesn't sort! I also tried this, which looks good at the beginning, but once it's sorted, the pictures move with the Snake River row and mess up the formatting. Anyway, what I'm trying to do is have a functional sortable table with images on the right side that don't move at all. Any thoughts? Thanks, Little Mountain 5 14:58, 6 July 2012 (UTC)
I am unable to make the static column work on List of chess grandmasters - it appears to have a limit of 200? I've also posted on that template's talk page, so please rather answer there so that anyone else looking can find it one place. Greenman ( talk) 21:23, 16 July 2012 (UTC)
Currently, this help document explicitly states "References and reference notes after numbers do not break numerical sorting of a column. See: List of sovereign states by public debt.". However, when I was trying to fix a sorting issue with a table, the only way I can seem to make it work is to take out the references. The example given also doesn't actually seem to have any references. Am I missing something, or is the advice simply wrong? 80 Ursae Majoris ( talk) 21:17, 16 July 2012 (UTC)
In current page as of 31 July 2012, all except three sort as text, even though many of them are labeled numerical. The three that sort as currency are the ones with $, €, and £. The ¥ sorts as text. I have verified this behavior on Windows 7 Professional running IE9 and Chrome20. NONE of the examples sorts numerically. I've submitted this as a bug as well. — Preceding unsigned comment added by Mwengler ( talk • contribs) 18:22, 31 July 2012 (UTC)
The list Talk:List of college football coaches with 30 seasons has a sorting issue that I cannot seem to solve. Can someone peek at it please?-- Paul McDonald ( talk) 17:30, 27 July 2012 (UTC)
In athletics results pages in events with multiple heats like the first table in 2009 Asian Athletics Championships – Men's 100 metres it is useful to sort the table by heats (2nd column) to see the results of each individual run but at the same time it should retain sorting by rank (1st column). Is there any way to achieve this? It should be noted that Heat 1 is always sorted this way, but in all others the sorting is semi-random. All such tables used to work properly in the past, but now they don't. Pietaster ( talk) 12:28, 7 August 2012 (UTC)
I thought I was getting the hang of sortable tables, but the table in User:Sphilbrick/sandbox isn't sorting the Diameter or Age columns correctly. Can anyone see what I did wrong?-- SPhilbrick (Talk) 18:34, 25 August 2012 (UTC)
(unindent). OK. I see now. A number column using {{ sort}} is actually using an alphabetical sort due to the use of characters other than numbers. Thus the need for the same number of characters in the sort value throughout the column. I added some info about {{ sort}} to Help:Sorting#Numerical sorting problems. I linked to this discussion. Feel free to clarify the info there, here, and in the documentation for the template: Template:Sort/doc. -- Timeshifter ( talk) 04:16, 28 August 2012 (UTC)
Is there a way to sort ordinal numbers so they appear in numerical order? Because of the addition of alpha characters, on many Category pages they appear as 10th, 100th, 101st, 102d, 11th, 1st . . . (not as 1st, 10th, 11th, 100th, 101st, 102d . . . Lineagegeek ( talk) 14:14, 18 October 2012 (UTC)
Now that HTML5 is enabled, data-sort-value
will now work:
{|class="wikitable sortable" !Name and Surname!!Height |- |data-sort-value="Smith, John"|John Smith||1.85 |- |data-sort-value="Ray, Ian"|Ian Ray||1.89 |- |data-sort-value="Bianchi, Zachary"|Zachary Bianchi||1.72 |- !Average:||1.82 |}
Name and Surname | Height |
---|---|
John Smith | 1.85 |
Ian Ray | 1.89 |
Zachary Bianchi | 1.72 |
Average: | 1.82 |
---— Gadget850 (Ed) talk 18:26, 19 September 2012 (UTC)
data-sort-type
btw. This forces a column, to use a specific type of sort algorithm. —
TheDJ (
talk •
contribs)
06:14, 20 September 2012 (UTC){|class="wikitable sortable" !Name and Surname!! data-sort-type="date" | Height
Name and Surname | Height |
---|---|
Zachary Bianchi | 22-7-1956 |
Ian Ray | 14-9-1980 |
John Smith | Having text here would normally trigger alphabetic sort instead numerical |
Average: | 1.82 |
Beware though. There might still be a chance that HTML5 will be disabled, so I wouldn't start converting tables too quickly. No rush. — TheDJ ( talk • contribs) 06:14, 20 September 2012 (UTC)
!data-sort-type
and |data-sort-value
will now work on all JavaScript-enabled browsers, even IE6+? (Assuming that HTML5 is not reverted.) —
Richardguk (
talk)
21:43, 20 September 2012 (UTC)(unindent). Is HTML 5 still enabled? Assuming that HTML 5 remains enabled where is there detailed info on data-sort-type?
Also on date sorting. Help:Sorting#Dates and meta:Help:Sorting#Dates have little info. meta:Help:Sorting#Dates says: "On English Wikipedias dates are treated as US-Dates (eg. month-day-year) per default." -- Timeshifter ( talk) 20:04, 26 September 2012 (UTC)
data-sort-type
Is this ready to be included in the Help:Sorting page? Any volunteers? -- Michael Bednarek ( talk) 12:20, 28 September 2012 (UTC)
data-sort-type
to the section on numerical sorting problems. Much more needs to be done. I can not find much info about data-sort-type
. I found some info about various forks of tablesorter:
data-sorter
in table headers at the level of the HTML. It looks like MediaWiki is using data-sort-type
instead. That is what I see in the source code for this page with some example tables:
User:Timeshifter/Sandbox27. --
Timeshifter (
talk)
13:12, 29 September 2012 (UTC)
The stats section of 2005 Nebraska Cornhuskers baseball team doesn't sort. Can someone fix it and tell me what I am missing. I have tried 50 different things. Thundrplaya ( talk) 03:42, 25 October 2012 (UTC)
The table sorting function appears to be broken. (Took me about an hour looking for where I had screwed up on a table I was editing last night before I went to look at existing articles with known sortable tables, to find that none are sortable any longer...)
André Kritzinger 14:34, 26 October 2012 (UTC)
Hi, Is there any way to change the sort arrow colors from the default black?
Thanks. Synthesized designs ( talk) 14:58, 31 October 2012 (UTC)
I wonder whether someone could help me please with sortability on the Party column. As this is not currently sortable (it uses party colours for a more aesthetically-pleasing effect), it throws out the sortability on the other columns too. Thanks in anticipation. Steve cov ( talk) 20:07, 4 November 2012 (UTC)
! ...previous columns here... !! class="unsortable" style="border-right:hidden;" | <!-- blank for colour --> !! Party !! ...subsequent columns here...
data-sort-value
attribute described at
meta:Help:Sorting#Specifying a sort key so that the colours column could be sortable in its own right. But with hindsight that's not necessary because sorting by the party name in the next column is sufficient.)Having a bit of problem with the sorting of the Album column in the table. Its not sorting alphabetically and this is after adding the {{ sort}} in an attempt to force it to do so. I'm at a loss to why it is doing this, so any help/solution would be greatly appreciated. NapHit ( talk) 22:52, 1 November 2012 (UTC)
data-sort-type="..."
attribute to the column header.data-sort-type="text"
and the sorting now seems to work.text
, number
, IPAddress
, currency
, url
, isoDate
, usLongDate
, date
, or time
.data-sort-type="date"
and data-sort-type="number"
,
Help:Sorting would benefit from being updated so that readers did not have to check meta for the full list of types.data-sort-type="text"
and link to revisions of
List of songs recorded by Adele as examples. --
Timeshifter (
talk)
22:32, 3 November 2012 (UTC)data-sort-type
and data-sort-value
were available. But the old tricks are now redundant so the next step would be to remove this and make the advice more focused.Has the table been modified? It no longer seems to be acknowledging rowspan effect, so I see this, every single item separated by line, instead of what it was before, which was one single Emmy entry, Globe entry, whatever. It used to look like that link IF you sorted, but at it's default state, the rowspan was in effect. This is from List of awards and nominations received by Game of Thrones and I've seen it on other tables. Darkwarriorblake ( talk) 23:34, 7 November 2012 (UTC)
I don't know if I'm just crazy and hadn't noticed before, but I created a Sales table for the Batman Death of the Family story article, and when I sort the numerical columns it is sorting by the first digit rather than the total value, so putting 50,070 higher than 63,659 or 3 after 17. Now I don't think it used to do this, am I doing something wrong or has something changed? Darkwarriorblake ( talk) 14:22, 13 January 2013 (UTC)
{{
nts}}
to the sales numbers, so it sorts as I would expect. —
EncMstr (
talk)
16:52, 13 January 2013 (UTC)
data-sort-type="number"
to 2 column headers. That is easier than using {{
nts}}
in every number cell, or using leading zeroes. See the section "Numerical sorting problems" in
Help:Sorting. --
Timeshifter (
talk)
02:30, 15 January 2013 (UTC)
I have two questions: I run a mediawiki operation and most of the sorting works properly except for dates. Dates in text form (Aug 18, 2008, or 18 Aug 2008) do not sort properly - they sort by year, but months do not appear to sort, evaen if I try forcing the type to "date" (other types work). The documentation suggests you can "now" sort by date, suggesting this was an addition. Can anyone point me to what might have been edited or fixed so that I might add such code to my wiki?
Secondy, there is an example in the documentation where it notes that if you start out with numbers, the table can get confused and think the table is "numeric". When you sort the left column, numbers drop below letters and letters don't get sorted at all. In the right column with manually setting type to "text", it is sorted alphabetically with numbers on top. Is there any way to accomplish text sorting with numbers on the bottom (i.e. the left column but with the text cells also sorted alphabetically?) - I am doing this manually with hidden sort fields (i.e. I've prepended hidden digits to any text fields) but automatically doing it would be preferable. Similarly I've prepended hidden isodates to the dates for the first issue above, but would prefer automatics.
Thanks in advance. TheHYPO ( talk) 17:17, 22 January 2013 (UTC)
data-sort-type
and data-sort-value
helper attributes will only work if your wiki enables
$wgHtml5
(more info at
meta:Help:Sorting).tableSorterCollation
, which is not documented on Mediawiki Wiki; the
test code implies that this can be set to an array of decompositions, so possibly this could be configured to alter the alpanumeric treatment of digits; I don't know whether that would cause unwanted side-effects with numerical sorting. But I'm not an expert, so treat all these suggestions with caution!The table at List_of_most_common_surnames_in_North_America#United_States which uses some rowspans and colspans has broken sorting. The arrows sort by the column to the left of the one you are clicking on. I assume this is a general problem for more complicated tables; is there anyone who can help sort this out? -- Beland ( talk) 08:20, 7 April 2013 (UTC)
From the first section of the article: "A sortable table is identified by the arrows in one or more of its header cells."
I see NO arrows in any cells in the example tables. Clicking the header cells does NOTHING. And yes, I have JavaScript enabled. — Preceding unsigned comment added by 74.95.43.249 ( talk) 19:36, 2 May 2013 (UTC)
I'm having some problems with the table at Italian presidential election, 2013#Results. The columns for the first three rounds of voting sort fine, but for round 4-6 it sorts numbers as text. Could someone help? Cheers, Number 5 7 16:00, 22 April 2013 (UTC)
Barisan Nasional | Pakatan Rakyat | Others | Total | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
State | Seats | * | ± | Seats | * | ± | Seats | * | ± | Seats | ||
![]() |
38 | 68% | ![]() |
18 | 32% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
21 | 58% | ![]() |
15 | 42% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
12 | 27% | ![]() |
33 | 73% | ![]() |
0 | 0% | ![]() |
45 | ||
![]() |
21 | 75% | ![]() |
7 | 25% | ![]() |
0 | 0% | ![]() |
28 | ||
![]() |
22 | 61% | ![]() |
14 | 39% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
30 | 71% | ![]() |
12 | 29% | ![]() |
0 | 0% | ![]() |
42 | ||
![]() |
10 | 25% | ![]() |
30 | 75% | ![]() |
0 | 0% | ![]() |
40 | ||
![]() |
31 | 53% | ![]() |
28 | 47% | ![]() |
0 | 0% | ![]() |
59 | ||
![]() |
13 | 87% | ![]() |
2 | 13% | ![]() |
0 | 0% | ![]() |
15 | ||
![]() |
48 | 80% | ![]() |
11 | 18% | ![]() |
1 | 2% | ![]() |
60 | ||
![]() |
12 | 21% | ![]() |
44 | 79% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
17 | 53% | ![]() |
15 | 47% | ![]() |
0 | 0% | ![]() |
32 | ||
Total | 275 | 54% | ![]() |
229 | 45% | ![]() |
1 | 0% | ![]() |
505 |
Hello!
Besides using a hidden sort key (and risking the displayed and hidden data becoming inconsistent), is there a way to make tables using increase/decrease/steady templates sort correctly, preferably by modifying these templates so that the template user needn't be concerned with data-sort-type etc?
For example, clicking the sorting icons in the table on the right gives steady at one end, and numbers within a category are sorted in alphabetical order.
Thanks, cmɢʟee ୯ ͡° ̮د ͡° ੭ 12:18, 10 May 2013 (UTC)
Barisan Nasional | Pakatan Rakyat | Others | Total | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
State | Seats | * | +/- | Seats | * | +/- | Seats | * | +/- | Seats | ||
![]() |
38 | 68% | ![]() |
18 | 32% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
21 | 58% | ![]() |
15 | 42% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
12 | 27% | ![]() |
33 | 73% | ![]() |
0 | 0% | ![]() |
45 | ||
![]() |
21 | 75% | ![]() |
7 | 25% | ![]() |
0 | 0% | ![]() |
28 | ||
![]() |
22 | 61% | ![]() |
14 | 39% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
30 | 71% | ![]() |
12 | 29% | ![]() |
0 | 0% | ![]() |
42 | ||
![]() |
10 | 25% | ![]() |
30 | 75% | ![]() |
0 | 0% | ![]() |
40 | ||
![]() |
31 | 53% | ![]() |
28 | 47% | ![]() |
0 | 0% | ![]() |
59 | ||
![]() |
13 | 87% | ![]() |
2 | 13% | ![]() |
0 | 0% | ![]() |
15 | ||
![]() |
48 | 80% | ![]() |
11 | 18% | ![]() |
1 | 2% | ![]() |
60 | ||
![]() |
12 | 21% | ![]() |
44 | 79% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
17 | 53% | ![]() |
15 | 47% | ![]() |
0 | 0% | ![]() |
32 | ||
Total | 275 | 54% | ![]() |
229 | 45% | ![]() |
1 | 0% | ![]() |
505 |
As an example, I've added for the 1st "+/-" column the positive/negative delta number as the 1st parameter into the templates {{ Increase}}, {{ Decrease}}, {{ Steady}} (see their documentation), and that seems to do the trick. -- Michael Bednarek ( talk) 15:52, 10 May 2013 (UTC)
|out=y
, which will cause the template to emit the first, unnamed parameter. On the other hand, as those three templates are edit-protected, it might be easier to do that with the templates {{
Rise}}, {{
Fall}} and {{
Same position}} which are not protected. I imagine something like this (without line breaks) might work:{{#if: {{{out}}}|{{{1}}}|}}<span title="{{{1|Rise}}}"> [[File:Green Arrow Up Darker.svg|12px |alt={{{1|Rise}}}|link=]]</span></nowiki>
The List of largest hotels in the world article is crying out for auto-ranking. In the last week, two edits have added or removed hotels towards the top of the list, which has resulted in all the other entries requiring their rank to be edited. I've searched around, and cannot find a way to add an auto-rank column to a table. Is there a way of doing it that I've missed? Can one be developed? Julianhall ( talk) 11:08, 3 June 2013 (UTC)
See
Net international investment position.
Am I the only one who's having this problem with this table (tested in 3 different browsers)?
If not so (or in either case) could someone please explain why is this happening and how to fix it?
Thanx.
Thanatos|
talk
23:49, 28 June 2013 (UTC)
Is there a reason, why flags are now not discounted in sortable tables? Armbrust The Homunculus 09:14, 19 July 2013 (UTC)
Date sorting does not work with BC years and with 1st century (i think year 11 for example is interpreted as 2011). Is there a way to make them work with data-sort-value, or do we have to switch the whole column to Template:Dts? -- Bultro ( talk) 19:23, 28 August 2013 (UTC)
Date (Year-month-day) |
---|
5 Dec 1000 |
7 Jan 500 |
14 May 200 BC |
4 Aug 150 BC |
5 Dec 77 |
7 Jan 88 BC |
I can not get it to work even for non-BC years.
Date Year-month-day |
---|
5 Dec 1000 |
7 Jan 500 |
5 Dec 77 |
Date |
---|
5 Dec 1000 |
7 Jan 500 AD |
5 Dec 77 AD |
Date |
---|
5 Dec 1000 |
7 Jan 500 CE |
5 Dec 77 CE |
Date |
---|
5 Dec 1000 CE |
7 Jan 500 CE |
5 Dec 77 CE |
It does not work with 4-digit years either:
Date |
---|
5 Dec 1000 |
7 Jan 0500 |
5 Dec 0077 |
It only seems to work with 4-digit years starting with 1 or 2:
Date |
---|
5 Dec 1000 |
7 Jan 1500 |
5 Dec 1077 |
Date |
---|
5 Dec 1000 |
7 Jan 1500 |
5 Dec 2077 |
-- Timeshifter ( talk) 18:24, 29 August 2013 (UTC)
Not even isoDate works before 100 CE
Date |
---|
5 Dec 111 |
7 Jan 35 |
5 Dec 207 |
5 Dec 111 BC |
7 Jan 35 BC |
5 Dec 207 BC |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date |- | data-sort-value="0111-12-05" | 5 Dec 111 |- | data-sort-value="0035-01-07" | 7 Jan 35 |- | data-sort-value="0207-12-05" | 5 Dec 207 |- | data-sort-value="-00111-12-05" | 5 Dec 111 BC |- | data-sort-value="-0035-01-07" | 7 Jan 35 BC |- | data-sort-value="-207-12-05" | 5 Dec 207 BC |}
I'm afraid non-date keys are the only option. Here for example i use numbers
Date |
---|
5 Dec 111 |
7 Jan 35 |
5 Dec 207 |
5 Dec 111 BC |
7 Jan 35 BC |
5 Dec 207 BC |
{| class="wikitable sortable" |- ! data-sort-type="number" | Date |- | data-sort-value="1111205" | 5 Dec 111 |- | data-sort-value="350107" | 7 Jan 35 |- | data-sort-value="2071205" | 5 Dec 207 |- | data-sort-value="-1111205" | 5 Dec 111 BC |- | data-sort-value="-350107" | 7 Jan 35 BC |- | data-sort-value="-2071205" | 5 Dec 207 BC |}
-- 151.96.3.241 ( talk) 08:40, 30 August 2013 (UTC)
I see what you mean about isoDate only working with dates from 100 CE onward. I added some tricky dates to see if it was sorting correctly. It looks like this version of isoDate does not require 4 digits for years before 1000. See info on ISO date format here.
Date |
---|
5 Dec 100 |
5 Dec 102 |
5 Dec 1011 |
5 Dec 207 |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date |- | data-sort-value="100-12-05" | 5 Dec 100 |- | data-sort-value="102-12-05" | 5 Dec 102 |- | data-sort-value="1011-12-05" | 5 Dec 1011 |- | data-sort-value="207-12-05" | 5 Dec 207 |}
It also works with just the numbers:
Date (year-month-day) |
---|
100-12-05 |
102-12-05 |
1011-12-05 |
207-12-05 |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date<br />(year-month-day) |- | 100-12-05 |- | 102-12-05 |- | 1011-12-05 |- | 207-12-05 |}
Adding 99 CE to the table breaks sorting in the table below:
Date |
---|
5 Dec 99 |
5 Dec 100 |
5 Dec 102 |
5 Dec 1011 |
5 Dec 207 |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date |- | data-sort-value="99-12-05" | 5 Dec 99 |- | data-sort-value="100-12-05" | 5 Dec 100 |- | data-sort-value="102-12-05" | 5 Dec 102 |- | data-sort-value="1011-12-05" | 5 Dec 1011 |- | data-sort-value="207-12-05" | 5 Dec 207 |}
-- Timeshifter ( talk) 21:30, 30 August 2013 (UTC)
The Help:Sorting page uses a mix of "ca." and "c." as the abbreviation for circa. Would it break anything if I change the the abbreviation from "ca." to use "c." consistently? Per WP:ABBR "c." is the standard abbreviation for circa in English Wikipedia. Thanks, SchreiberBike talk 22:46, 4 September 2013 (UTC)
![]() | This is an archive of past discussions. 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. |
Archive 1 | Archive 2 | Archive 3 | Archive 4 |
How do I reverse order sort based on the order of the items in the list? I want to reverse the order of the items irrespective of date, currency, numeric, or string, but only by how the items first appear on the list. XP1 ( talk) 23:54, 12 April 2009 (UTC)
wikibits.js can be improved to include more date formats and trim leading/trailing spaces from dates. I've taken a stab at a couple of improvements outlined below
if (/^\d\d[\/. -][a-zA-Z]{3}[\/. -]\d\d\d\d$/.test(itm)) {
to
if (/^\d\d[\/. -]?[a-zA-Z]{3}[\/. -]?\d\d\d\d$/.test(itm)) {
Add the following before the first line of "ts_dateToSortKey"
date= date.replace(/^\s\s*/, ).replace(/\s\s*$/, ); if (date.length ==9){ date = date.substr(0,2)+" " + date.substr(2,3)+" "+ date.substr(5); }
-- Bala ( talk) 19:30, 20 March 2009 (UTC)
I saw that {{ Dts}} was copied from m:Template:Dts. Help:Sorting is pretty cool stuff. But since I'm a lazy programmer and wikieditor, I'm always looking for a way to cut corners. Check out {{ User:MrDolomite/Sandbox/Dts}} and let me know what you all think. — MrDolomite | Talk 18:04, 11 January 2007 (UTC)
Is it possible (or would it be possible) for cells to have a sort key different from that which is displayed? I want to make List of Liverpool F.C. players sortable, but for it to be useful I really need:
-- ArtVandelay13 13:19, 11 February 2007 (UTC)
The script, while ingenious, doesn't work very well with headers spanning over several columns, effectively screwing up List of members of the Riksdag, 2002-2006 by requiring a separate header for the colors (resulting in that column being unnecessarily wide). Solution, anyone? Jobjörn ( Talk ° contribs) 21:03, 22 February 2007 (UTC)
For some reason I'm no longer able to get tables in WP to obey the instruction class="wikitable sortable"
. Is this a known problem? JavaScript is not disabled on my system.
It must be something to do with my WP Preferences, because the problem disappears when I log out. I don't remember changing anything in the Prefs, however: any suggestions? I've tried bypassing my cache, but that didn't help.
What would I need to do (or have done) to disable the "sortable" property on my computer? -- NigelG (or Ndsg) | Talk 09:41, 13 March 2007 (UTC)
I started a discussion at Template talk:Sort, since there seem to be a number of unconnected efforts to create sortkeys for sortable wikitables. ~ trialsanderrors 23:21, 2 April 2007 (UTC)
I've read this page and looked at the code in the example table, but I don't quite get what is the best way to get numbers of varying lengths to sort properly (i.e. for 17,000,000 to show up as larger than 900,000). In particular, I would like to fix the attendance numbers at List of sports attendance figures. Thanks for any help. — Reinyday, 00:15, 5 April 2007 (UTC)
Do you plan to ultimately use
datagrid
?
David Latapie (
✒ |
@) —
www
19:35, 10 April 2007 (UTC)
I need the correct code for Instructions_per_second anywere can help? -- FidelFair 04:13, 6 May 2007 (UTC)
Processor | IPS (sortable don´t work?) | Year | Source |
---|---|---|---|
Pencil and Paper | 0.0119 IPS | 1892 | [1] |
IBM System/370 model 158-3 | 1 MIPS | 1972 | |
Intel 8080 | 640 kIPS at 2 MHz | 1974 | |
VAX 11/780 | 500 kIPS | 1977 | |
Motorola 68000 | 1 MIPS at 8 MHz | 1979 | |
Intel 386DX | 8.5 MIPS at 25 MHz | 1988 | |
Intel 486DX | 54 MIPS at 66 MHz | 1992 | |
PowerPC 600s (G2) | 35 MIPS at 33 MHz | 1994 | |
Intel Pentium Pro | 541 MIPS at 200 MHz | 1996 | [2] |
ARM 7500FE | 35.9 MIPS at 40 MHz | 1996 | |
PowerPC G3 | 525 MIPS at 233 MHz | 1997 | |
Zilog eZ80 | 80 MIPS at 50 MHz | 1999 | [3] |
Intel Pentium III | 1354 MIPS at 500 MHz | 1999 | |
AMD Athlon | 3561 MIPS at 1.2 GHz | 2000 | |
AMD Athlon XP 2400+ | 5935 MIPS at 2.0 GHz | 2002 | |
Pentium 4 Extreme Edition | 9726 MIPS at 3.2 GHz | 2003 | |
ARM Cortex A8 | 2000 MIPS at 1.0 GHz | 2005 | [4] |
Xbox360 IBM "Xenon" Triple Core | 6400 MIPS at 3.2 GHz | 2005 | |
AMD Athlon FX-57 | 12000 MIPS at 2.8 GHz | 2005 | |
AMD Athlon 64 3800+ X2 (Dual Core) | 14564 MIPS at 2.0 GHz | 2005 | [5] |
AMD Athlon FX-60 (Dual Core) | 18938 MIPS at 2.6 GHz | 2006 | [6] |
Intel Core 2 X6800 | 27079 MIPS at 2.93 GHz | 2006 | [7] |
IBM Cell one SPE | 25600 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
IBM Cell one PPE | 51200 MIPS (38400 MFLOPS)at 3.2 GHz | 2006 | |
IBM Cell BE (1PPE + 8SPEs) | 256000 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
SONY PS3 (1PPE + 7SPEs) | 230400 MIPS (217600 MFLOPS) at 3.2 GHz | 2006 | |
Intel Core 2 Extreme QX6700 | 57063 MIPS at 3.33 GHz | 2006 | [8] |
Processor | IPS | Year | Source |
---|---|---|---|
Pencil and Paper | 0.0119 IPS | 1892 | [9] |
IBM System/370 model 158-3 | 1 MIPS | 1972 | |
Intel 8080 | 640 kIPS at 2 MHz | 1974 | |
VAX 11/780 | 500 kIPS | 1977 | |
Motorola 68000 | 1 MIPS at 8 MHz | 1979 | |
Intel 386DX | 8.5 MIPS at 25 MHz | 1988 | |
Intel 486DX | 54 MIPS at 66 MHz | 1992 | |
PowerPC 600s (G2) | 35 MIPS at 33 MHz | 1994 | |
Intel Pentium Pro | 541 MIPS at 200 MHz | 1996 | [10] |
ARM 7500FE | 35.9 MIPS at 40 MHz | 1996 | |
PowerPC G3 | 525 MIPS at 233 MHz | 1997 | |
Zilog eZ80 | 80 MIPS at 50 MHz | 1999 | [11] |
Intel Pentium III | 1354 MIPS at 500 MHz | 1999 | |
AMD Athlon | 3561 MIPS at 1.2 GHz | 2000 | |
AMD Athlon XP 2400+ | 5935 MIPS at 2.0 GHz | 2002 | |
Pentium 4 Extreme Edition | 9726 MIPS at 3.2 GHz | 2003 | |
ARM Cortex A8 | 2000 MIPS at 1.0 GHz | 2005 | [12] |
Xbox360 IBM "Xenon" Triple Core | 6400 MIPS at 3.2 GHz | 2005 | |
AMD Athlon FX-57 | 12000 MIPS at 2.8 GHz | 2005 | |
AMD Athlon 64 3800+ X2 (Dual Core) | 14564 MIPS at 2.0 GHz | 2005 | [13] |
AMD Athlon FX-60 (Dual Core) | 18938 MIPS at 2.6 GHz | 2006 | [14] |
Intel Core 2 X6800 | 27079 MIPS at 2.93 GHz | 2006 | [15] |
IBM Cell one SPE | 25600 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
IBM Cell one PPE | 51200 MIPS (38400 MFLOPS)at 3.2 GHz | 2006 | |
IBM Cell BE (1PPE + 8SPEs) | 256000 MIPS (MFLOPS) at 3.2 GHz | 2006 | |
SONY PS3 (1PPE + 7SPEs) | 230400 MIPS (217600 MFLOPS) at 3.2 GHz | 2006 | |
Intel Core 2 Extreme QX6700 | 57063 MIPS at 3.33 GHz | 2006 | [16] |
Is it possible to get a collapsable and sortable table? ∞ ΣɛÞ² ( τ| c) 12:30, 26 May 2007 (UTC)
Header 1 | Header 2 | Header 3 |
---|---|---|
A1 | B1 | C1 |
A2 | B2 | C2 |
Collapsible table
|
---|
I've made a sortable wikitable for a "crimes against humanity" table, here, but I couldn't get the estimates columns to sort properly. I know what the problem is in part, which is that because there are references together with the estimates in the first cell, the sort table reads as an alphabetic table instead of a numeric one.
The Help page says you just have to finish your cell with the code "sm=n" to make the sorting in such cases numeric, but it doesn't work. I found another way of making the table work by creating hidden rows at the top and bottom of the table with very high and low numbers respectively, but it's a kludgy fix and doesn't work right under all conditions.
Can someone please show me how to get this "sm=n" method to work? Thanks, Gatoclass 16:45, 15 June 2007 (UTC)
I have added the sm=n to the List of Aston Villa F.C. players article but the goals and appearances sections are still not listing properly. For the appearances section anyway it seems to be those numbers that are under 100. Can anyone help? Thanks Woodym555 14:11, 4 August 2007 (UTC)
I am trying to create number parameters for sorting. (Ex. sorting_table|table1|5|10, 5 being the number of rows and 10 being the number of colums). Is that even possible? I would like to be able to add or remove rows so a generic sorting template can be used for many different articles. The articles will have similar information but different names.
-- Ricky.Garcia 16:50, 7 August 2007 (UTC)
I just thought I should point out that as of time of writing some of the examples don't work in this version of the page (the initial sort is incorrect although second and subsequent sorts are correct) although they do on the meta original, so I guess something needs updating. -- 80.175.250.218 08:53, 9 August 2007 (UTC)
Can someone please look at the table here and check why the goal difference column does not sort correctly? Thanks in advance. Madcynic 10:06, 7 October 2007 (UTC)
Hi! I recently created my first table, which a fellow editor converted to a sorting table. Problem is, we're seeing different things when we click the sort buttons! He's getting proper sorting in all columns, while only the first column sorts (ascending/descending) for me—regardless of which column's header I click on. Why would that be? The page in question is Wikipedia:WikiProject_Birds/Country_lists. I'm on Mac OSX10.4.10, using Safari. Help! MeegsC | Talk 13:10, 6 November 2007 (UTC)
Hi,
I would like to know if it's possible to hide something in a sorting table.
Ex:
How I can sort byu last name
Name |
---|
Bob Dubois |
Roger Smith |
Frank Desmarais |
Thank! Riba en ( talk) 20:10, 9 December 2007 (UTC)
Could anyone tell me why this table is not sorting properly? We want to be able to sort by date. Various people over here have said that the sorting does not work for them. Thank you, Fang Aili talk 03:41, 16 December 2007 (UTC)
User Name | Date of Original Request | Last date page visited | Wiki areas of interest | Article areas of interest | Requestor comments | Contact log/Notes |
---|---|---|---|---|---|---|
Robotam ( talk · contribs) | 31 July 2004 | Been active for some time, I believe I have given positive contributions, but I want to make sure I have not developed "tunnel vision." I would definitely appreciate wiki mentoring to do even more, and do it the right way.RoBoTam ice 20:29, 31 July 2007 (UTC) | ||||
Lemonflash ( talk · contribs) | 1 August 2007 | I'm an active contributer to Wikipedia, and wish to be an admin some day. Lemonflash talk 01:03, 1 August 2007 (UTC) | ||||
Andyroo g ( talk · contribs) | 25 July 2002 | I have wanted to be an admin for some time now, and would like to get some training to do so. I realise it is cliched, but i do truly have a misleadingly low edit count compared to my true amount of edits as a result of a large amount of edits whilst not signed in Andyroo g 18:46, 25 July 2007 (UTC) | ||||
Violask81976 ( talk · contribs) | 20 July 2007 | Want some guidance. - Viola sk8 1976 15:15, 20 July 2007 (UTC) | ||||
geniussansom ( talk · contribs) | 16 July 2001 | Would like some guidance on expanding the articles which I edit and would like to be an admin at some point in the future -- geniussansom 15:34, 16 July 2007 (UTC) | ||||
Someguy1221 ( talk · contribs) | 11 July 2007 | Looking to be an admin, and I think I might need some advice. Someguy1221 08:47, 27 April 2007 (UTC). Still interested. Someguy1221 07:08, 11 July 2007 (UTC) | ||||
Flubeca ( talk · contribs) | 10 July 2009 | I want to become an admin :) - Flubeca Talk 19:02, 10 July 2007 (UTC) | ||||
Son ( talk · contribs) | 9 July 2007 | I've been on en.wikipedia since December 2005 with some IP editing before that, and I'd like to become an admin. I definitely need some improvement, and I've gotten more invovled in XfDs and RfCs. -- myselfalso 19:22, 9 July 2007 (UTC) | ||||
Nwwaew ( talk · contribs) | 23 June 2000 | I want to see what I'm doing right, and what I need to improve to become an admin, and stand a chance at WP:RfA. This is what I think is the best course of action. Nwwaew ( Talk Page) ( Contribs) ( E-mail me) 13:39, 23 June 2007 (UTC) |
{{dts|day|month|year}}
in place of the date values. It produces an invisible sortable date and displays it formatted correctly according to user preferences. —
EncMstr
03:54, 16 December 2007 (UTC)
When I have a column with a negative number, it sorts ok ascendingly, but sorts alphabetically descendingly. Is this a javascript problem? I've tried so many suggestions - none have worked -- JimWae ( talk) 08:30, 24 December 2007 (UTC)
I was hoping to use dates in a sortable table without specifying the year (i.e. 1 January), but I can't figure out how to do it and get the table to sort properly. I tried {{ Dts}}, but year seems to be a requirement. Any help would be appreciated! PC78 ( talk) 21:21, 22 February 2008 (UTC)
I'd like to add a header above the sortable row on the table in the Statewide polling article. Basically, above the first Clinton/Obama/Other columns I'd like to add a "Polling data" column (with colspan="3") and above the second Clinton/Obama/Other columns I'd like to add a "Delegates won" column (with colspan="3"). The "Date", "State", and "Delegates" column would ideally be modified to have rowspan="2". Can anyone help me do this? Andareed ( talk) 22:28, 8 March 2008 (UTC)
Clicking the sort button messes up this table by sorting the numbers by digit rather than by number. How do I make it recognize that 10 is bigger than 2? Is there a parameter that makes it look at numbers differently? Thanks. -- Arctic Gnome ( talk • contribs) 04:50, 20 March 2008 (UTC)
Number of years |
---|
1 year |
2 years |
5 years |
10 years |
20 years |
25 years |
Number of years |
---|
1 year |
2 years |
5 years |
10 years |
20 years |
25 years |
{{sort|
what to sort by|
what to display}}
. I thought it was smarter about accepting numbers, but to make the example work, I used leading zeros so a lexicographic sort works okay. Perhaps there's another form of the sort template which deals with numbers more intuitively. —
EncMstr
05:00, 20 March 2008 (UTC)How can this be done? Example: Opinion polling for the United States presidential election, 2008 -- Kallahan ( talk) 21:11, 26 March 2008 (UTC)
Poll Source | Date administered | Democrat | % | Republican | % |
---|---|---|---|---|---|
Rasmussen Reports Tracking | March 25-28, 2008 | Hillary Clinton | 40% | John McCain | 51% |
Barack Obama | 43% | John McCain | 48% | ||
Gallup Tracking | March 24-28, 2008 | Hillary Clinton | 44% | John McCain | 48% |
Barack Obama | 44% | John McCain | 46% | ||
NBC News/Wall Street Journal | March 24-25, 2008 | Hillary Clinton | 44% | John McCain | 46% |
Barack Obama | 44% | John McCain | 42% | ||
Pew Research Center | March 19-22, 2008 | Hillary Clinton | 49% | John McCain | 44% |
Barack Obama | 49% | John McCain | 43% | ||
Fox News/Opinion Dynamics | March 18-19, 2008 | Hillary Clinton | 46% | John McCain | 43% |
Barack Obama | 43% | John McCain | 44% | ||
CBS News | March 15-18, 2008 | Hillary Clinton | 46% | John McCain | 44% |
Barack Obama | 44% | John McCain | 46% |
Poll Source | Date administered | Democrat | % | Republican | % |
---|---|---|---|---|---|
Rasmussen Reports Tracking | March 25-28, 2008 | Hillary Clinton | 40% | John McCain | 51% |
Barack Obama | 43% | John McCain | 48% | ||
Gallup Tracking | March 24-28, 2008 | Hillary Clinton | 44% | John McCain | 48% |
Barack Obama | 44% | John McCain | 46% | ||
NBC News/Wall Street Journal | March 24-25, 2008 | Hillary Clinton | 44% | John McCain | 46% |
Barack Obama | 44% | John McCain | 42% | ||
Pew Research Center | March 19-22, 2008 | Hillary Clinton | 49% | John McCain | 44% |
Barack Obama | 49% | John McCain | 43% | ||
Fox News/Opinion Dynamics | March 18-19, 2008 | Hillary Clinton | 46% | John McCain | 43% |
Barack Obama | 43% | John McCain | 44% | ||
CBS News | March 15-18, 2008 | Hillary Clinton | 46% | John McCain | 44% |
Barack Obama | 44% | John McCain | 46% |
Poll Source | Date administered | Democrat | % | Republican | % |
---|---|---|---|---|---|
Rasmussen Reports Tracking | March 25-28, 2008 | Hillary Clinton Barack Obama |
40% 43% |
John McCain | 51% |
Gallup Tracking | March 24-28, 2008 | Hillary Clinton Barack Obama |
44% 44% |
John McCain | 48% 46% |
NBC News/Wall Street Journal | March 24-25, 2008 | Hillary Clinton Barack Obama |
44% 44% |
John McCain | 46% 42% |
Pew Research Center | March 19-22, 2008 | Hillary Clinton Barack Obama |
49% | John McCain | 44% 43% |
Fox News/Opinion Dynamics | March 18-19, 2008 | Hillary Clinton Barack Obama |
46% 43% |
John McCain | 43% |
CBS News | March 15-18, 2008 | Hillary Clinton Barack Obama |
46% 44% |
John McCain | 44% 46% |
I have started a wikitable using this format and I'm way over my head now. I want to display the endorsements for presidential candidates in the GOP 2012 race. Check it here Endorsements for the Republican Party presidential primaries, 2012 Unfortunately, the numbers are easier to place than the names. I want to put the names in collapsible rows so people can read the numbers and verify the endorsements by checking a row below. Please help. :-< -- Screwball23 talk 02:58, 27 October 2011 (UTC)
I think that my question is very simple but I couldn't find the answer myself... Is it possible to add some parameter that with one click table would be sorted in a descending order? Niktute ( talk) 22:43, 30 November 2011 (UTC)
There is a problem while sorting the "HS" column in this article. A few en-dashes come before "0". I'm unable to figure out the problem. Any help will be much appreciated. — Commander (Ping me) 17:15, 3 January 2012 (UTC)
Hi, all. I can't seem to get the table at List of countries by net international investment position to order by the "NIIP in % GDP" column as numeric - it always sorts it as characters instead.
All the entries in that column are numeric. Some have a leading plus sign, leading minus, and/or a leading zero, and many have references. But this should not bother the numeric sorting.
Any help would be greatly appreciated! Thanks! Facts707 ( talk) 19:49, 14 February 2012 (UTC)
I was working with List of maria on the Moon. Is there any reasonable way to sort latitude and longitude numerically instead of alphabetically? For example, getting it to treat °N as a negative number and °S as positive so the list would start with the northernmost entry and end with the most southerly. Thanks! Aubri ( talk) 18:52, 21 March 2012 (UTC)
{| class="wikitable sortable" ! Latin name ! Lat. ! Long. |- | [[Mare Anguis]] |align="right"|{{Hs|-226}} 22.6° N |align="right"|{{Hs|677}} 67.7° E |- | [[Mare Australe]] |align="right"|{{Hs|389}} 38.9° S |align="right"|{{Hs|930}} 93.0° E |- | [[Mare Cognitum]] |align="right"|{{Hs|100}} 10.0° S |align="right"|{{Hs|-231}} 23.1° W |- | [[Mare Crisium]] |align="right"|{{Hs|-170}} 17.0° N |align="right"|{{Hs|591}} 59.1° E |}
Latin name | Lat. | Long. |
---|---|---|
Mare Anguis | 22.6° N | 67.7° E |
Mare Australe | 38.9° S | 93.0° E |
Mare Cognitum | 10.0° S | 23.1° W |
Mare Crisium | 17.0° N | 59.1° E |
I was trying to use a sortable table with one of the headers extending the length of the table. Here is the table: User:B2project/sandbox2
I'd like to keep the table sortable so I can change the order to determine leaders and would like to keep the break in it to clean up the table but I can't seem to get the header row to extend the rest of the table. Does anyone know if this is possible? Any help would be appreciated. Thanks.
♣ B2project ♣ (Talk) 23:18, 16 April 2012 (UTC)
I see this was answered a couple of years ago, but in case anything has changed I'll ask again:
I want to include a "X see Y" crossref in column 1, which is a list of names of hills where just a couple have two names, but I then don't want "X" to have any content in the other cols and want it to sort down to the bottom. Can it be done? ( The Outlying Fells of Lakeland, "Cartmel Fell see Raven's Barrow", if you're interested in the exact example). Pam D 14:31, 2 May 2012 (UTC)
I've replaced the section "Initial alphabetical sort versus initial sort by rank order" because it was suggesting people remove rank columns and sort lists alphabetically, because it would make the list easier to update. This is inappropriate as it suggests removing a useful feature for readers in order to accommodate to editors. I have instead put together a how-to on updating lists sorted by rank. Pristino ( talk) 11:25, 7 June 2012 (UTC)
Hi, I'm having some issues with a sortable table that I'm working on here. It looks nice, but it doesn't sort! I also tried this, which looks good at the beginning, but once it's sorted, the pictures move with the Snake River row and mess up the formatting. Anyway, what I'm trying to do is have a functional sortable table with images on the right side that don't move at all. Any thoughts? Thanks, Little Mountain 5 14:58, 6 July 2012 (UTC)
I am unable to make the static column work on List of chess grandmasters - it appears to have a limit of 200? I've also posted on that template's talk page, so please rather answer there so that anyone else looking can find it one place. Greenman ( talk) 21:23, 16 July 2012 (UTC)
Currently, this help document explicitly states "References and reference notes after numbers do not break numerical sorting of a column. See: List of sovereign states by public debt.". However, when I was trying to fix a sorting issue with a table, the only way I can seem to make it work is to take out the references. The example given also doesn't actually seem to have any references. Am I missing something, or is the advice simply wrong? 80 Ursae Majoris ( talk) 21:17, 16 July 2012 (UTC)
In current page as of 31 July 2012, all except three sort as text, even though many of them are labeled numerical. The three that sort as currency are the ones with $, €, and £. The ¥ sorts as text. I have verified this behavior on Windows 7 Professional running IE9 and Chrome20. NONE of the examples sorts numerically. I've submitted this as a bug as well. — Preceding unsigned comment added by Mwengler ( talk • contribs) 18:22, 31 July 2012 (UTC)
The list Talk:List of college football coaches with 30 seasons has a sorting issue that I cannot seem to solve. Can someone peek at it please?-- Paul McDonald ( talk) 17:30, 27 July 2012 (UTC)
In athletics results pages in events with multiple heats like the first table in 2009 Asian Athletics Championships – Men's 100 metres it is useful to sort the table by heats (2nd column) to see the results of each individual run but at the same time it should retain sorting by rank (1st column). Is there any way to achieve this? It should be noted that Heat 1 is always sorted this way, but in all others the sorting is semi-random. All such tables used to work properly in the past, but now they don't. Pietaster ( talk) 12:28, 7 August 2012 (UTC)
I thought I was getting the hang of sortable tables, but the table in User:Sphilbrick/sandbox isn't sorting the Diameter or Age columns correctly. Can anyone see what I did wrong?-- SPhilbrick (Talk) 18:34, 25 August 2012 (UTC)
(unindent). OK. I see now. A number column using {{ sort}} is actually using an alphabetical sort due to the use of characters other than numbers. Thus the need for the same number of characters in the sort value throughout the column. I added some info about {{ sort}} to Help:Sorting#Numerical sorting problems. I linked to this discussion. Feel free to clarify the info there, here, and in the documentation for the template: Template:Sort/doc. -- Timeshifter ( talk) 04:16, 28 August 2012 (UTC)
Is there a way to sort ordinal numbers so they appear in numerical order? Because of the addition of alpha characters, on many Category pages they appear as 10th, 100th, 101st, 102d, 11th, 1st . . . (not as 1st, 10th, 11th, 100th, 101st, 102d . . . Lineagegeek ( talk) 14:14, 18 October 2012 (UTC)
Now that HTML5 is enabled, data-sort-value
will now work:
{|class="wikitable sortable" !Name and Surname!!Height |- |data-sort-value="Smith, John"|John Smith||1.85 |- |data-sort-value="Ray, Ian"|Ian Ray||1.89 |- |data-sort-value="Bianchi, Zachary"|Zachary Bianchi||1.72 |- !Average:||1.82 |}
Name and Surname | Height |
---|---|
John Smith | 1.85 |
Ian Ray | 1.89 |
Zachary Bianchi | 1.72 |
Average: | 1.82 |
---— Gadget850 (Ed) talk 18:26, 19 September 2012 (UTC)
data-sort-type
btw. This forces a column, to use a specific type of sort algorithm. —
TheDJ (
talk •
contribs)
06:14, 20 September 2012 (UTC){|class="wikitable sortable" !Name and Surname!! data-sort-type="date" | Height
Name and Surname | Height |
---|---|
Zachary Bianchi | 22-7-1956 |
Ian Ray | 14-9-1980 |
John Smith | Having text here would normally trigger alphabetic sort instead numerical |
Average: | 1.82 |
Beware though. There might still be a chance that HTML5 will be disabled, so I wouldn't start converting tables too quickly. No rush. — TheDJ ( talk • contribs) 06:14, 20 September 2012 (UTC)
!data-sort-type
and |data-sort-value
will now work on all JavaScript-enabled browsers, even IE6+? (Assuming that HTML5 is not reverted.) —
Richardguk (
talk)
21:43, 20 September 2012 (UTC)(unindent). Is HTML 5 still enabled? Assuming that HTML 5 remains enabled where is there detailed info on data-sort-type?
Also on date sorting. Help:Sorting#Dates and meta:Help:Sorting#Dates have little info. meta:Help:Sorting#Dates says: "On English Wikipedias dates are treated as US-Dates (eg. month-day-year) per default." -- Timeshifter ( talk) 20:04, 26 September 2012 (UTC)
data-sort-type
Is this ready to be included in the Help:Sorting page? Any volunteers? -- Michael Bednarek ( talk) 12:20, 28 September 2012 (UTC)
data-sort-type
to the section on numerical sorting problems. Much more needs to be done. I can not find much info about data-sort-type
. I found some info about various forks of tablesorter:
data-sorter
in table headers at the level of the HTML. It looks like MediaWiki is using data-sort-type
instead. That is what I see in the source code for this page with some example tables:
User:Timeshifter/Sandbox27. --
Timeshifter (
talk)
13:12, 29 September 2012 (UTC)
The stats section of 2005 Nebraska Cornhuskers baseball team doesn't sort. Can someone fix it and tell me what I am missing. I have tried 50 different things. Thundrplaya ( talk) 03:42, 25 October 2012 (UTC)
The table sorting function appears to be broken. (Took me about an hour looking for where I had screwed up on a table I was editing last night before I went to look at existing articles with known sortable tables, to find that none are sortable any longer...)
André Kritzinger 14:34, 26 October 2012 (UTC)
Hi, Is there any way to change the sort arrow colors from the default black?
Thanks. Synthesized designs ( talk) 14:58, 31 October 2012 (UTC)
I wonder whether someone could help me please with sortability on the Party column. As this is not currently sortable (it uses party colours for a more aesthetically-pleasing effect), it throws out the sortability on the other columns too. Thanks in anticipation. Steve cov ( talk) 20:07, 4 November 2012 (UTC)
! ...previous columns here... !! class="unsortable" style="border-right:hidden;" | <!-- blank for colour --> !! Party !! ...subsequent columns here...
data-sort-value
attribute described at
meta:Help:Sorting#Specifying a sort key so that the colours column could be sortable in its own right. But with hindsight that's not necessary because sorting by the party name in the next column is sufficient.)Having a bit of problem with the sorting of the Album column in the table. Its not sorting alphabetically and this is after adding the {{ sort}} in an attempt to force it to do so. I'm at a loss to why it is doing this, so any help/solution would be greatly appreciated. NapHit ( talk) 22:52, 1 November 2012 (UTC)
data-sort-type="..."
attribute to the column header.data-sort-type="text"
and the sorting now seems to work.text
, number
, IPAddress
, currency
, url
, isoDate
, usLongDate
, date
, or time
.data-sort-type="date"
and data-sort-type="number"
,
Help:Sorting would benefit from being updated so that readers did not have to check meta for the full list of types.data-sort-type="text"
and link to revisions of
List of songs recorded by Adele as examples. --
Timeshifter (
talk)
22:32, 3 November 2012 (UTC)data-sort-type
and data-sort-value
were available. But the old tricks are now redundant so the next step would be to remove this and make the advice more focused.Has the table been modified? It no longer seems to be acknowledging rowspan effect, so I see this, every single item separated by line, instead of what it was before, which was one single Emmy entry, Globe entry, whatever. It used to look like that link IF you sorted, but at it's default state, the rowspan was in effect. This is from List of awards and nominations received by Game of Thrones and I've seen it on other tables. Darkwarriorblake ( talk) 23:34, 7 November 2012 (UTC)
I don't know if I'm just crazy and hadn't noticed before, but I created a Sales table for the Batman Death of the Family story article, and when I sort the numerical columns it is sorting by the first digit rather than the total value, so putting 50,070 higher than 63,659 or 3 after 17. Now I don't think it used to do this, am I doing something wrong or has something changed? Darkwarriorblake ( talk) 14:22, 13 January 2013 (UTC)
{{
nts}}
to the sales numbers, so it sorts as I would expect. —
EncMstr (
talk)
16:52, 13 January 2013 (UTC)
data-sort-type="number"
to 2 column headers. That is easier than using {{
nts}}
in every number cell, or using leading zeroes. See the section "Numerical sorting problems" in
Help:Sorting. --
Timeshifter (
talk)
02:30, 15 January 2013 (UTC)
I have two questions: I run a mediawiki operation and most of the sorting works properly except for dates. Dates in text form (Aug 18, 2008, or 18 Aug 2008) do not sort properly - they sort by year, but months do not appear to sort, evaen if I try forcing the type to "date" (other types work). The documentation suggests you can "now" sort by date, suggesting this was an addition. Can anyone point me to what might have been edited or fixed so that I might add such code to my wiki?
Secondy, there is an example in the documentation where it notes that if you start out with numbers, the table can get confused and think the table is "numeric". When you sort the left column, numbers drop below letters and letters don't get sorted at all. In the right column with manually setting type to "text", it is sorted alphabetically with numbers on top. Is there any way to accomplish text sorting with numbers on the bottom (i.e. the left column but with the text cells also sorted alphabetically?) - I am doing this manually with hidden sort fields (i.e. I've prepended hidden digits to any text fields) but automatically doing it would be preferable. Similarly I've prepended hidden isodates to the dates for the first issue above, but would prefer automatics.
Thanks in advance. TheHYPO ( talk) 17:17, 22 January 2013 (UTC)
data-sort-type
and data-sort-value
helper attributes will only work if your wiki enables
$wgHtml5
(more info at
meta:Help:Sorting).tableSorterCollation
, which is not documented on Mediawiki Wiki; the
test code implies that this can be set to an array of decompositions, so possibly this could be configured to alter the alpanumeric treatment of digits; I don't know whether that would cause unwanted side-effects with numerical sorting. But I'm not an expert, so treat all these suggestions with caution!The table at List_of_most_common_surnames_in_North_America#United_States which uses some rowspans and colspans has broken sorting. The arrows sort by the column to the left of the one you are clicking on. I assume this is a general problem for more complicated tables; is there anyone who can help sort this out? -- Beland ( talk) 08:20, 7 April 2013 (UTC)
From the first section of the article: "A sortable table is identified by the arrows in one or more of its header cells."
I see NO arrows in any cells in the example tables. Clicking the header cells does NOTHING. And yes, I have JavaScript enabled. — Preceding unsigned comment added by 74.95.43.249 ( talk) 19:36, 2 May 2013 (UTC)
I'm having some problems with the table at Italian presidential election, 2013#Results. The columns for the first three rounds of voting sort fine, but for round 4-6 it sorts numbers as text. Could someone help? Cheers, Number 5 7 16:00, 22 April 2013 (UTC)
Barisan Nasional | Pakatan Rakyat | Others | Total | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
State | Seats | * | ± | Seats | * | ± | Seats | * | ± | Seats | ||
![]() |
38 | 68% | ![]() |
18 | 32% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
21 | 58% | ![]() |
15 | 42% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
12 | 27% | ![]() |
33 | 73% | ![]() |
0 | 0% | ![]() |
45 | ||
![]() |
21 | 75% | ![]() |
7 | 25% | ![]() |
0 | 0% | ![]() |
28 | ||
![]() |
22 | 61% | ![]() |
14 | 39% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
30 | 71% | ![]() |
12 | 29% | ![]() |
0 | 0% | ![]() |
42 | ||
![]() |
10 | 25% | ![]() |
30 | 75% | ![]() |
0 | 0% | ![]() |
40 | ||
![]() |
31 | 53% | ![]() |
28 | 47% | ![]() |
0 | 0% | ![]() |
59 | ||
![]() |
13 | 87% | ![]() |
2 | 13% | ![]() |
0 | 0% | ![]() |
15 | ||
![]() |
48 | 80% | ![]() |
11 | 18% | ![]() |
1 | 2% | ![]() |
60 | ||
![]() |
12 | 21% | ![]() |
44 | 79% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
17 | 53% | ![]() |
15 | 47% | ![]() |
0 | 0% | ![]() |
32 | ||
Total | 275 | 54% | ![]() |
229 | 45% | ![]() |
1 | 0% | ![]() |
505 |
Hello!
Besides using a hidden sort key (and risking the displayed and hidden data becoming inconsistent), is there a way to make tables using increase/decrease/steady templates sort correctly, preferably by modifying these templates so that the template user needn't be concerned with data-sort-type etc?
For example, clicking the sorting icons in the table on the right gives steady at one end, and numbers within a category are sorted in alphabetical order.
Thanks, cmɢʟee ୯ ͡° ̮د ͡° ੭ 12:18, 10 May 2013 (UTC)
Barisan Nasional | Pakatan Rakyat | Others | Total | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
State | Seats | * | +/- | Seats | * | +/- | Seats | * | +/- | Seats | ||
![]() |
38 | 68% | ![]() |
18 | 32% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
21 | 58% | ![]() |
15 | 42% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
12 | 27% | ![]() |
33 | 73% | ![]() |
0 | 0% | ![]() |
45 | ||
![]() |
21 | 75% | ![]() |
7 | 25% | ![]() |
0 | 0% | ![]() |
28 | ||
![]() |
22 | 61% | ![]() |
14 | 39% | ![]() |
0 | 0% | ![]() |
36 | ||
![]() |
30 | 71% | ![]() |
12 | 29% | ![]() |
0 | 0% | ![]() |
42 | ||
![]() |
10 | 25% | ![]() |
30 | 75% | ![]() |
0 | 0% | ![]() |
40 | ||
![]() |
31 | 53% | ![]() |
28 | 47% | ![]() |
0 | 0% | ![]() |
59 | ||
![]() |
13 | 87% | ![]() |
2 | 13% | ![]() |
0 | 0% | ![]() |
15 | ||
![]() |
48 | 80% | ![]() |
11 | 18% | ![]() |
1 | 2% | ![]() |
60 | ||
![]() |
12 | 21% | ![]() |
44 | 79% | ![]() |
0 | 0% | ![]() |
56 | ||
![]() |
17 | 53% | ![]() |
15 | 47% | ![]() |
0 | 0% | ![]() |
32 | ||
Total | 275 | 54% | ![]() |
229 | 45% | ![]() |
1 | 0% | ![]() |
505 |
As an example, I've added for the 1st "+/-" column the positive/negative delta number as the 1st parameter into the templates {{ Increase}}, {{ Decrease}}, {{ Steady}} (see their documentation), and that seems to do the trick. -- Michael Bednarek ( talk) 15:52, 10 May 2013 (UTC)
|out=y
, which will cause the template to emit the first, unnamed parameter. On the other hand, as those three templates are edit-protected, it might be easier to do that with the templates {{
Rise}}, {{
Fall}} and {{
Same position}} which are not protected. I imagine something like this (without line breaks) might work:{{#if: {{{out}}}|{{{1}}}|}}<span title="{{{1|Rise}}}"> [[File:Green Arrow Up Darker.svg|12px |alt={{{1|Rise}}}|link=]]</span></nowiki>
The List of largest hotels in the world article is crying out for auto-ranking. In the last week, two edits have added or removed hotels towards the top of the list, which has resulted in all the other entries requiring their rank to be edited. I've searched around, and cannot find a way to add an auto-rank column to a table. Is there a way of doing it that I've missed? Can one be developed? Julianhall ( talk) 11:08, 3 June 2013 (UTC)
See
Net international investment position.
Am I the only one who's having this problem with this table (tested in 3 different browsers)?
If not so (or in either case) could someone please explain why is this happening and how to fix it?
Thanx.
Thanatos|
talk
23:49, 28 June 2013 (UTC)
Is there a reason, why flags are now not discounted in sortable tables? Armbrust The Homunculus 09:14, 19 July 2013 (UTC)
Date sorting does not work with BC years and with 1st century (i think year 11 for example is interpreted as 2011). Is there a way to make them work with data-sort-value, or do we have to switch the whole column to Template:Dts? -- Bultro ( talk) 19:23, 28 August 2013 (UTC)
Date (Year-month-day) |
---|
5 Dec 1000 |
7 Jan 500 |
14 May 200 BC |
4 Aug 150 BC |
5 Dec 77 |
7 Jan 88 BC |
I can not get it to work even for non-BC years.
Date Year-month-day |
---|
5 Dec 1000 |
7 Jan 500 |
5 Dec 77 |
Date |
---|
5 Dec 1000 |
7 Jan 500 AD |
5 Dec 77 AD |
Date |
---|
5 Dec 1000 |
7 Jan 500 CE |
5 Dec 77 CE |
Date |
---|
5 Dec 1000 CE |
7 Jan 500 CE |
5 Dec 77 CE |
It does not work with 4-digit years either:
Date |
---|
5 Dec 1000 |
7 Jan 0500 |
5 Dec 0077 |
It only seems to work with 4-digit years starting with 1 or 2:
Date |
---|
5 Dec 1000 |
7 Jan 1500 |
5 Dec 1077 |
Date |
---|
5 Dec 1000 |
7 Jan 1500 |
5 Dec 2077 |
-- Timeshifter ( talk) 18:24, 29 August 2013 (UTC)
Not even isoDate works before 100 CE
Date |
---|
5 Dec 111 |
7 Jan 35 |
5 Dec 207 |
5 Dec 111 BC |
7 Jan 35 BC |
5 Dec 207 BC |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date |- | data-sort-value="0111-12-05" | 5 Dec 111 |- | data-sort-value="0035-01-07" | 7 Jan 35 |- | data-sort-value="0207-12-05" | 5 Dec 207 |- | data-sort-value="-00111-12-05" | 5 Dec 111 BC |- | data-sort-value="-0035-01-07" | 7 Jan 35 BC |- | data-sort-value="-207-12-05" | 5 Dec 207 BC |}
I'm afraid non-date keys are the only option. Here for example i use numbers
Date |
---|
5 Dec 111 |
7 Jan 35 |
5 Dec 207 |
5 Dec 111 BC |
7 Jan 35 BC |
5 Dec 207 BC |
{| class="wikitable sortable" |- ! data-sort-type="number" | Date |- | data-sort-value="1111205" | 5 Dec 111 |- | data-sort-value="350107" | 7 Jan 35 |- | data-sort-value="2071205" | 5 Dec 207 |- | data-sort-value="-1111205" | 5 Dec 111 BC |- | data-sort-value="-350107" | 7 Jan 35 BC |- | data-sort-value="-2071205" | 5 Dec 207 BC |}
-- 151.96.3.241 ( talk) 08:40, 30 August 2013 (UTC)
I see what you mean about isoDate only working with dates from 100 CE onward. I added some tricky dates to see if it was sorting correctly. It looks like this version of isoDate does not require 4 digits for years before 1000. See info on ISO date format here.
Date |
---|
5 Dec 100 |
5 Dec 102 |
5 Dec 1011 |
5 Dec 207 |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date |- | data-sort-value="100-12-05" | 5 Dec 100 |- | data-sort-value="102-12-05" | 5 Dec 102 |- | data-sort-value="1011-12-05" | 5 Dec 1011 |- | data-sort-value="207-12-05" | 5 Dec 207 |}
It also works with just the numbers:
Date (year-month-day) |
---|
100-12-05 |
102-12-05 |
1011-12-05 |
207-12-05 |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date<br />(year-month-day) |- | 100-12-05 |- | 102-12-05 |- | 1011-12-05 |- | 207-12-05 |}
Adding 99 CE to the table breaks sorting in the table below:
Date |
---|
5 Dec 99 |
5 Dec 100 |
5 Dec 102 |
5 Dec 1011 |
5 Dec 207 |
{| class="wikitable sortable" |- ! data-sort-type="isoDate" | Date |- | data-sort-value="99-12-05" | 5 Dec 99 |- | data-sort-value="100-12-05" | 5 Dec 100 |- | data-sort-value="102-12-05" | 5 Dec 102 |- | data-sort-value="1011-12-05" | 5 Dec 1011 |- | data-sort-value="207-12-05" | 5 Dec 207 |}
-- Timeshifter ( talk) 21:30, 30 August 2013 (UTC)
The Help:Sorting page uses a mix of "ca." and "c." as the abbreviation for circa. Would it break anything if I change the the abbreviation from "ca." to use "c." consistently? Per WP:ABBR "c." is the standard abbreviation for circa in English Wikipedia. Thanks, SchreiberBike talk 22:46, 4 September 2013 (UTC)