Help:Sortable tables/gu

This page is a translated version of the page Help:Sortable tables and the translation is 1% complete.

નૉૅધ: જ્યારે તમે આ પૃષ્ઠને સંપાદિત કરો છો, ત્યારે તમે તમારા યોગદાનને CC0 હેઠળ મુક્ત કરવા માટે સંમત થાઓ છો. વધુ માહિતી માટે સાર્વજનિક ડોમેન સહાય પૃષ્ઠો જુઓ.

To make a sortable table, add the sortable class to a table. This class adds arrows displayed beside the header within each header cell. (See example below.) When you click on an arrow, the table rows are arranged according to the chosen column. Continuously clicking the arrow alters the sorting order in the following pattern: Ascending (min to max), Descending (max to min), and then Unsorted (sequential). You can perform secondary sorts by shift-clicking the arrows in different columns.

Each shift click will set the secondary sort based on the clicked column, and this capability extends to tertiary and further sorts.

Sort modes

Items are sorted based on the data type of the first few rows below the header. To determine the data type, the first five non-empty rows below the header are examined upon page loading, and the most suitable format is selected. Discrepancies can occur. Additionally, specific columns can have their sorting order forced, as explained in the relevant section below.

Currently, tags like span or sup don't affect how data types are determined, but reference numbers and visible comments do.

Dates

Different date formats are accepted, even those with month names in local languages. For instance, on the German Wikipedia, "16. März 2010" is appropriately sorted as 2010-03-16.

Different numerical formats, including ones with various separators like periods, commas, apostrophes, or slashes (such as . , ' /), are supported. The English Wikipedia typically uses the US date format, (e.g. month-day-year).

Numbers

The script can detect numbers that use either "." or "," as decimal separators, as well as numbers written in scientific notation (using "e" or "E"). By default, numbers will be sorted based on alphanumeric order, meaning that they will be sorted as strings rather than numerical values. This may result in unexpected sortings, such as "9" coming after "10". However, this default behavior can be overridden if desired.

Text

When lists are sorted alphabetically by MediaWiki, the order of characters is sorted with Intl.Collator. This sorts accented characters correctly based on PageContentLanguage.

Android Webviews don't support this, so fallback to the old sort routine is required. The order is the same as the order of Unicode code points. Some of the more common characters are ordered as follows (in ascending order):

	!	"	#	$	%	&	'	(	)	*	+	,	-	.	/	0	1	2	3	4	5	6	7	8	9	:	;	<	=	>	?	@	A	B	C
D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	[	\	]	^	_	`	a	b	c	d	e	f	g
h	i	j	k	l	m	n	o	p	q	r	s	t	u	v	w	x	y	z	{	\|	}	~		¡	¢	£	¤	¥	¦	§	¨	©	ª	«	¬
	®	¯	°	±	²	³	´	µ	¶	·	¸	¹	º	»	¼	½	¾	¿	À	Á	Â	Ã	Ä	Å	Æ	Ç	È	É	Ê	Ë	Ì	Í	Î	Ï	Ð
Ñ	Ò	Ó	Ô	Õ	Ö	×	Ø	Ù	Ú	Û	Ü	Ý	Þ	ß	à	á	â	ã	ä	å	æ	ç	è	é	ê	ë	ì	í	î	ï	ð	ñ	ò	ó	ô
õ	ö	÷	ø	ù	ú	û	ü	ý	þ	ÿ	Ā	ā	Ă	ă	Ą	ą	Ć	ć	Ĉ	ĉ	Ċ	ċ	Č	č	Ď	ď	Đ	đ	Ē	ē	Ĕ	ĕ	Ė	ė	Ę
ę	Ě	ě	Ĝ	ĝ	Ğ	ğ	Ġ	ġ	Ģ	ģ	Ĥ	ĥ	Ħ	ħ	Ĩ	ĩ	Ī	ī	Ĭ	ĭ	Į	į	İ	ı	Ĳ	ĳ	Ĵ	ĵ	Ķ	ķ	ĸ	Ĺ	ĺ	Ļ	ļ
Ľ	ľ	Ŀ	ŀ	Ł	ł	Ń	ń	Ņ	ņ	Ň	ň	ŉ	Ŋ	ŋ	Ō	ō	Ŏ	ŏ	Ő	ő	Œ	œ	Ŕ	ŕ	Ŗ	ŗ	Ř	ř	Ś	ś	Ŝ	ŝ	Ş	ş	Š
š	Ţ	ţ	Ť	ť	Ŧ	ŧ	Ũ	ũ	Ū	ū	Ŭ	ŭ	Ů	ů	Ű	ű	Ų	ų	Ŵ	ŵ	Ŷ	ŷ	Ÿ	Ź	ź	Ż	ż	Ž	ž	ſ	Ə	ƒ	Ǻ	ǻ	Ǽ
ǽ	Ǿ	ǿ	Ș	ș	Ț	ț	ə	ˆ	ˇ	ˉ	˘	˙	˚	˛	˜	˝	΄	΅	Ά	·	Έ	Ή	Ί	Ό	Ύ	Ώ	ΐ	Α	Β	Γ	Δ	Ε	Ζ	Η	Θ
Ι	Κ	Λ	Μ	Ν	Ξ	Ο	Π	Ρ	Σ	Τ	Υ	Φ	Χ	Ψ	Ω	Ϊ	Ϋ	ά	έ	ή	ί	ΰ	α	β	γ	δ	ε	ζ	η	θ	ι	κ	λ	μ	ν
ξ	ο	π	ρ	ς	σ	τ	υ	φ	χ	ψ	ω	ϊ	ϋ	ό	ύ	ώ	Ѐ	Ё	Ђ	Ѓ	Є	Ѕ	І	Ї	Ј	Љ	Њ	Ћ	Ќ	Ѝ	Ў	Џ	А	Б	В
Г	Д	Е	Ж	З	И	Й	К	Л	М	Н	О	П	Р	С	Т	У	Ф	Х	Ц	Ч	Ш	Щ	Ъ	Ы	Ь	Э	Ю	Я	а	б	в	г	д	е	ж
з	и	й	к	л	м	н	о	п	р	с	т	у	ф	х	ц	ч	ш	щ	ъ	ы	ь	э	ю	я	ѐ	ё	ђ	ѓ	є	ѕ	і	ї	ј	љ	њ
ћ	ќ	ѝ	ў	џ	Ґ	ґ	Ḃ	ḃ	Ḋ	ḋ	Ḟ	ḟ	Ṁ	ṁ	Ṗ	ṗ	Ṡ	ṡ	Ṫ	ṫ	Ẁ	ẁ	Ẃ	ẃ	Ẅ	ẅ	Ỳ	ỳ	–	—	―	‗	‘	’	‚
‛	“	”	„	†	‡	•	…	‰	′	″	‹	›	‼	‾	⁄	ⁿ	₣	₤	₧	€	℅	ℓ	№	™	Ω	℮	⅛	⅜	⅝	⅞	←	↑	→	↓	↔
↕	↨	∂	∆	∏	∑	−	∕	∙	√	∞	∟	∩	∫	≈	≠	≡	≤	≥	⌂	⌐	⌠	⌡	─	│	┌	┐	└	┘	├	┤	┬	┴	┼	═	║
╒	╓	╔	╕	╖	╗	╘	╙	╚	╛	╜	╝	╞	╟	╠	╡	╢	╣	╤	╥	╦	╧	╨	╩	╪	╫	╬	▀	▄	█	▌	▐	░	▒	▓	■
□	▪	▫	▬	▲	►	▼	◄	◊	○	●	◘	◙	◦	☺	☻	☼	♀	♂	♠	♣	♥	♦	♪	♫			ﬁ	ﬂ	�

ISO basic Latin alphabet

Greek alphabet

Russian Cyrillic alphabet

Forcing the sort mode of a column

Adding data-sort-type="..." to the header lets you control how a table is sorted. This feature is derived from tablesorter.com (webarchive). Valid values for "data-sort-type" include the following which are not case-sensitive:

currency
number
isoDate
time
IPAddress
usLongDate
date
text
url

For example:

Wikitext

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

Rendering

Date	Name	Height	Salary
01.10.1977	Smith	1.85	1,000.000
11.6.1972	Ray	1.89	900.000
1.9.1992	Bianchi	1.72	2,000.50

Specifying a sort key

You can adjust how cells are sorted or parsed if needed. For instance, if a cell says "John Smith" but should be sorted under "Smith", you can use the data-sort-value="..." attribute to achieve this.

Wikitext

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

Rendering

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

Controlling sorting and display

To ensure certain text isn't sorted but still displayed, use data-sort-type="...". You can then append additional text after values, like "200 approx" or "100^[1]". An empty cell sorts as "-Infinity". If a cell contains a range of dates or numbers (for example, from 2 to 5), use data-sort-value="...".

Examples

The first column sorts plain numbers. The second column sorts more content as numbers using data-sort-type="number" in the table header. The fourth column defines numeric sort values independently of cell content using data-sort-value="...".

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

The way commas (,) and decimal points (.) are displayed in Mediawiki depends on the language settings. Currency symbols and the percentage (%) symbol are sorted numerically based on these settings.

currencies
$ 9
$ 80
$ 70
$ 600

currencies
9 €
80 €
70 €
600 €

currencies
£ 9
£ 80
£ 70
£ 600

currencies
¥ 9
¥ 80
¥ 70
¥ 600

percent
9 %
80 %
70 %
600 %

numbers
−7e270
-1.4285714285714E-13
999e9
7e270

Forcing the initial sort direction

MediaWiki version:

≥ 1.47

By default, clicking a column header for the first time sorts it in ascending order. To make a column sort in descending order on the first click, add data-sort-order="desc" to its header cell. The default behavior for all subsequent clicks remains unchanged.

Wikitext

{| class="wikitable sortable"
!data-sort-order="desc"| Score !! Name
|-
| 72 || Smith
|-
| 50 || Ray
|-
| 95 || Bianchi
|}

Rendering

Score	Name
72	Smith
50	Ray
95	Bianchi

Secondary sort key

You can sort data by columns, with Column A as the primary sort key. If Column A has equal values, use Column B as the secondary key. Click Column A's sort button once or twice, then while holding shift, click Column B's sort button once or twice for further refinement.

For example:

Click on the "Text" column first, then hold down the shift key and click on the "Numbers" column. You'll notice that the items are sorted based on text first and then numbers.

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

Additional features

Excluding the last row from sorting

You can skip sorting the last row of a table by marking it with class="sortbottom". You can also exclude it from sorting by declaring it as a footer with an exclamation mark(!).

Wikitext

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

Rendering

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

Excluding the first row from sorting

You can exclude the first row by using the class="sorttop".

Wikitext

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

Rendering

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

Making a column unsortable

To stop a column from being sortable, use class="unsortable" in its header cell's attributes.

Wikitext

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

Rendering

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

Keeping some rows together

To allow an uncolumned row to always stay beneath the columned row above it, no matter how you sort them, use class="expand-child" in the row's attribute.

Wikitext

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

Rendering

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

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

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

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

Country/province	Capital
France	Paris
Netherlands	Amsterdam
South Holland	The Hague
U.K.	London

Special dates

To represent years Before the Common Era (BCE) subtract the BCE year from ૧૦,૦૦૦. For instance, -62 BCE would be ૧૦,૦૦૦ - 62 = 9938.

For example, September 23, 62 BCE would be represented as 9938-09-23.

If a table column has incomplete dates, sorting won't be an issue. If only a year and month are provided, it's sorted before the first day of that month. Similarly, if only a year is given, it's sorted before the first month or day of that year.

Wikitext

{| class="wikitable sortable"
|-
! Date
|-
| 2022-01-01
|-
| 2023-12-31
|-
| 2024
|-
| 2024-04
|-
| 2024-04-00
|-
| 2024-05
|-
| 2024-05-00
|}

Rendering

Date
2022-01-01
2023-12-31
2024
2024-04
2024-04-00
2024-05
2024-05-00

Using #time

You can use the parser function #time and HTML tags to display a specific date range. By adding the HTML tag <span style="display:none">&{{#expr:3e11+{{#time:U|..}}}}</span> before the displayed date, you can manipulate the way the date is shown. This method works for dates between January 1, 111 CE, and December 31, 9999 CE, using the proleptic Gregorian calendar. The added value ensures all values are positive and uniform in length. Placing "&" before the expression forces string sorting mode.

You can input dates and times using any PHP format for date and time. Remember, if you're specifying just a year, you must include a month (usually January) in the background.

For example using date :

input date	text	date and time as interpreted, with hidden sort key	input with visible sort key	input with hidden sort key	Unix time
010203		૧૨ જુલા ૨૦૨૬ ૦૧:૦૨:૦૩	&Expression error: Unrecognized punctuation character "૧". 010203	010203	૧૭૮૩૮૧૮૧૨૩
1/2		૦૨ જાન્યુ ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 1/2	1/2	૧૭૬૭૩૧૨૦૦૦
1/2/3		૦૨ જાન્યુ ૨૦૦૩ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 1/2/3	1/2/3	૧૦૪૧૪૬૫૬૦૦
1-2-2003		૦૧ ફેબ્રુ ૨૦૦૩ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 1-2-2003	1-2-2003	૧૦૪૪૦૫૭૬૦૦
1-2-3		૦૩ ફેબ્રુ ૨૦૦૧ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૯". 1-2-3	1-2-3	૯૮૧૧૫૮૪૦૦
2007		૦૧ જાન્યુ ૨૦૦૭ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 2007	2007	૧૧૬૭૬૦૯૬૦૦
1 Jan 111, 00:00:00		&241335609600 ૦૧ જાન્યુ ૦૧૧૧ ૦૦:૦૦:૦૦	&241335609600 1 Jan 111, 00:00:00	&241335609600 1 Jan 111, 00:00:00	-58664390400
31 Dec 9999, 23:59:59		૩૧ ડિસે ૯૯૯૯ ૨૩:૫૯:૫૯	&Expression error: Unrecognized punctuation character "૨". 31 Dec 9999, 23:59:59	31 Dec 9999, 23:59:59	૨૫૩૪૦૨૩૦૦૭૯૯
Sep 1970		૦૧ સપ્ટે ૧૯૭૦ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૨". Sep 1970	Sep 1970	૨૦૯૯૫૨૦૦
1970		૦૧ જાન્યુ ૧૯૭૦ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૦". 1970	1970	૦
Jun 2007	or later	૦૧ જૂન ૨૦૦૭ ૦૦:૦૦:૦૦ or later	&Expression error: Unrecognized punctuation character "૧". Jun 2007 or later	Jun 2007 or later	૧૧૮૦૬૫૬૦૦૦ or later
Jun 2007	perhaps earlier	૦૧ જૂન ૨૦૦૭ ૦૦:૦૦:૦૦ perhaps earlier	&Expression error: Unrecognized punctuation character "૧". Jun 2007 perhaps earlier	Jun 2007 perhaps earlier	૧૧૮૦૬૫૬૦૦૦ perhaps earlier
2007-6		૦૧ જૂન ૨૦૦૭ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 2007-6	2007-6	૧૧૮૦૬૫૬૦૦૦
Jun 2007		૦૧ જૂન ૨૦૦૭ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Jun 2007	Jun 2007	૧૧૮૦૬૫૬૦૦૦
4 Jun 2007		૦૪ જૂન ૨૦૦૭ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 4 Jun 2007	4 Jun 2007	૧૧૮૦૯૧૫૨૦૦
3 Jul 2007		૦૩ જુલા ૨૦૦૭ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 3 Jul 2007	3 Jul 2007	૧૧૮૩૪૨૦૮૦૦
12 Aug 2006		૧૨ ઓગ ૨૦૦૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 12 Aug 2006	12 Aug 2006	૧૧૫૫૩૪૦૮૦૦
1 Mar 2006 -1day		૨૮ ફેબ્રુ ૨૦૦૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 1 Mar 2006 -1day	1 Mar 2006 -1day	૧૧૪૧૦૮૪૮૦૦
1 Mar 2008 -1day		૨૯ ફેબ્રુ ૨૦૦૮ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 1 Mar 2008 -1day	1 Mar 2008 -1day	૧૨૦૪૨૪૩૨૦૦
1 Mar 2010 -1day		૨૮ ફેબ્રુ ૨૦૧૦ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". 1 Mar 2010 -1day	1 Mar 2010 -1day	૧૨૬૭૩૧૫૨૦૦
1 Mar 1900 -1day		&297796022400 ૨૮ ફેબ્રુ ૧૯૦૦ ૦૦:૦૦:૦૦	&297796022400 1 Mar 1900 -1day	&297796022400 1 Mar 1900 -1day	-2203977600
1 Mar 1600 -1day		&288329001600 ૨૯ ફેબ્રુ ૧૬૦૦ ૦૦:૦૦:૦૦	&288329001600 1 Mar 1600 -1day	&288329001600 1 Mar 1600 -1day	-11670998400
Jun 1607		&288557875200 ૦૧ જૂન ૧૬૦૭ ૦૦:૦૦:૦૦	&288557875200 Jun 1607	&288557875200 Jun 1607	-11442124800
20260712003257		૧૨ જુલા ૨૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". 20260712003257	20260712003257	૧૭૮૩૮૧૬૩૭૭
yesterday		૧૧ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". yesterday	yesterday	૧૭૮૩૭૨૮૦૦૦
today		૧૨ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". today	today	૧૭૮૩૮૧૪૪૦૦
tomorrow		૧૩ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". tomorrow	tomorrow	૧૭૮૩૯૦૦૮૦૦
1week		૧૯ જુલા ૨૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". 1week	1week	૧૭૮૪૪૨૧૧૭૭
-1week		૦૫ જુલા ૨૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". -1week	-1week	૧૭૮૩૨૧૧૫૭૭
1day		૧૩ જુલા ૨૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". 1day	1day	૧૭૮૩૯૦૨૭૭૭
-1day		૧૧ જુલા ૨૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". -1day	-1day	૧૭૮૩૭૨૯૯૭૭
1month		૧૨ ઓગ ૨૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". 1month	1month	૧૭૮૬૪૯૪૭૭૭
-1month		૧૨ જૂન ૨૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". -1month	-1month	૧૭૮૧૨૨૪૩૭૭
1year		૧૨ જુલા ૨૦૨૭ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". 1year	1year	૧૮૧૫૩૫૨૩૭૭
-1year		૧૨ જુલા ૨૦૨૫ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૧". -1year	-1year	૧૭૫૨૨૮૦૩૭૭
1000year		૧૨ જુલા ૩૦૨૬ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૩". 1000year	1000year	૩૩૩૪૦૭૨૫૧૭૭
10000month		૧૨ નવે ૨૮૫૯ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૨". 10000month	10000month	૨૮૦૮૧૩૮૪૩૭૭
1000000day		૦૮ જૂન ૪૭૬૪ ૦૦:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૮". 1000000day	1000000day	૮૮૧૮૩૮૧૬૩૭૭
10000000hour		૨૮ એપ્રિલ ૩૧૬૭ ૧૬:૩૨:૫૭	&Expression error: Unrecognized punctuation character "૩". 10000000hour	10000000hour	૩૭૭૮૩૮૧૬૩૭૭
1000000000minute		૦૮ નવે ૩૯૨૭ ૧૧:૧૨:૫૭	&Expression error: Unrecognized punctuation character "૬". 1000000000minute	1000000000minute	૬૧૭૮૩૮૧૬૩૭૭
100000000000second		૨૭ મે ૫૧૯૫ ૧૦:૧૯:૩૭	&Expression error: Unrecognized punctuation character "૧". 100000000000second	100000000000second	૧૦૧૭૮૩૮૧૬૩૭૭
7980year		Error: #time only supports years up to 9999.	&Expression error: Unexpected < operator. 7980year	7980year	Error: #time only supports years up to 9999.
-1890year		&242141205177 ૧૨ જુલા ૦૧૩૬ ૦૦:૩૨:૫૭	&242141205177 -1890year	&242141205177 -1890year	-57858794823
Mon		૧૩ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Mon	Mon	૧૭૮૩૯૦૦૮૦૦
Tue		૧૪ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Tue	Tue	૧૭૮૩૯૮૭૨૦૦
Wed		૧૫ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Wed	Wed	૧૭૮૪૦૭૩૬૦૦
Thu		૧૬ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Thu	Thu	૧૭૮૪૧૬૦૦૦૦
Fri		૧૭ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Fri	Fri	૧૭૮૪૨૪૬૪૦૦
Sat		૧૮ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Sat	Sat	૧૭૮૪૩૩૨૮૦૦
Sun		૧૨ જુલા ૨૦૨૬ ૦૦:૦૦:૦૦	&Expression error: Unrecognized punctuation character "૧". Sun	Sun	૧૭૮૩૮૧૪૪૦૦
		ક્ષતિ: અયોગ્ય સમય.	&Expression error: Unexpected < operator.		ક્ષતિ: અયોગ્ય સમય.
unknown		ક્ષતિ: અયોગ્ય સમય.	&Expression error: Unexpected < operator. unknown	unknown	ક્ષતિ: અયોગ્ય સમય.

To use dates before 111 CE, add a multiple of 400 (like 6000) to all years. This shifts the range to start from January 1st, -5889, at 00:00:00, and ends on December 31st, 3999, at 23:59:59, without altering the calendar system.

આ પણ જુઓ:

w:Template:dts - Sorting a table by a date column

Cell spanning multiple rows/cells

A cell that extends across multiple rows or columns is considered equivalent to having multiple cells with identical values.

rowspan
Date	Name	Height
01.10.1977	Smith	1.85
11.06.1972	Adams	1.85
01.09.1992	Bianchi	1.72

colspan
A	B		C
A	2	1
B	1		3
C	2

Any missing cells at the end of a row will turn into empty cells after the first sort.

Colspanned cells

Sort modes are detected separately for each column containing colspanned cells. You can set a sort mode for all colspanned columns by including data-sort-type in the header.

To implement separate sort keys for each column within a colspanned cell, utilize a CSS trick described here: Ensure an equal number of cells in each row for sortable columns. If there's a mismatch, all columns become sortable. This rule should apply up to and including the last sortable column. However, employing a CSS workaround allows for a difference between the displayed number of cells in a row and the formal count. For instance, two formal cells can appear as one by adjusting the width of the first column, shifting the content of the second cell to the left, increasing its width by the same measure, and concealing the cell border that would typically be visible. Concealed sort keys enable managing the sorting order of specific rows in relation to each column.

For example:

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

Static column

To make a static column, like one with row numbers, use two tables placed next to each other. Make sure each row in both tables has the same height. You can also use w:Template:Static row numbers to generate row numbers implicitly using CSS rather than creating another table.

Number
1
2

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

The formatting can be modified to present everything in a unified table. If a row is too short for the text in a cell, the browser will expand it, disrupting the alignment.

Default order

You can't show a table sorted by a column without the user clicking on it. By default, table rows appear in the order as the wikitext. To display a table sorted by a specific column, you'll need to arrange the wikitext accordingly. One way of doing this is:

Rearrange the table's wikitext without the top and bottom lines.
Replace the cell separators with a unique code that doesn't contain a "|" by using "find and replace".
Replace any pipes within table cells with a code, and then substitute that code with a newline character preceded by it (indicating the start of a new row).
Use the Sort module on Special:ExpandTemplates. To sort the items between the pipes and produce the desired separator, expand templates and add {{#invoke:Sort|f||- | (with the newline) before and }} after the wikitext.
Delete the items that begin with "-" and a newline.
Change the temporary codes for the cell separators and pipes inside the cells to restore them.

This sorting method relies on the wikitext in each row, primarily sorting by the content of the first column. The second column serves as a secondary key. However, wikitext codes in the first column cells before the content can impact the order.

You can also use Snippets/Sort table on reload to automatically sort the table when it loads using JavaScript.

Persistent sort states using cookies

You can save the state of sortable tables across reloads using Snippets/Persistent sort order .

આ પણ જુઓ

Help:Table
Category:Sorting templates
jquery.tablesorter.js – TableSorter for MediaWiki
http://www.kryogenix.org/code/browser/sorttable/ – Stuart Langridge's original code needs explaining. In the MediaWiki version, tables no longer need IDs.
For much more detailed instructions, see the Wikipedia page.
Manual:$wgCategoryCollation – Allows you to change the collation used for categories (requires shell access).
Unicode character references on the Wikibooks.
- Initial characters

Other examples:

w:Ranked list of Dutch provinces
w:List of countries by GDP estimates for 2006 (nominal)
w:List of countries by GDP (PPP), 2006
w:List of longest reigning current monarchs – Date columns can be sorted by those who don't care about date format and by those who prefer [[YYYY-MM-DD]].
Pokémon table – Place a "#" before numbers to position them ahead of "-".
Nuclear power by country (Featured List)
w:Desert Island Discs: castaways' choices
zh:秘鲁行政区划 (Subdivisions of Peru) for sorting of Chinese (CJK)
w:Standard electrode potential (data page)