Last modified: 2012-02-14 17:35:09 UTC
If table has string and integer in one column.media wiki has problem with sorting. specially up to down sorting http://fa.wikipedia.org/wiki/%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1:Reza1615/table_bug
In English table it has 4 type sorting 2 types string sorting and others are integer sorting but in Persian table it has only 2 type and that is string sorting
Krinkle (Since I think you did the sorting code), is this something that would have to be done upstream or could we add it?
The bug is on 1.17wmf1. The upcoming 1.18 has totally different sorting code that should fix this, by giving the user the option to define how the column should be sorted.
is it possible to save sorted table as new table?
Marking INVALID as 1.18 has a new sorting system which supports this. (In reply to comment #4) > is it possible to save sorted table as new table? No, but that's not related to this bug. Please ask on IRC or at the support desk: http://www.mediawiki.org/wiki/Support
now (1.18) it completely disabled! http://fa.wikipedia.org/wiki/%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1:Reza1615/table_bug
@reza1615 Your tables don't use headers, and headers are required to add sorting. If it worked like that before 1.18, than we fixed a big bug in my opinion. See also: https://meta.wikimedia.org/wiki/Help:Table#Sorting
I added header but it doesn't work correctly http://fa.wikipedia.org/wiki/%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1:Reza1615/table_bug in both English and Farsi numbers the biggest number (102) is not sorted as biggest one.
That's because you are using it wrong. When you mix types, you need to tell it what type to use for sorting. See https://meta.wikimedia.org/wiki/Help:Sorting#Sort_modes
Oh, and for defining an order that is not yet predefined, you have to define your own collation algorithm: https://meta.wikimedia.org/wiki/Help:Sorting#Text That will solve the issue of your farsi numbers ordering. You might have to do this in MediaWiki:Common.js if you want it to work for all users.
i set like mw.config.set('tableSorterCollation', {'۰':'0', '۱' : '1', '۲': '2', '۳':'3','۴':'4', '۵' : '5', '۶': '6', '۷':'7','۸':'8', '۹' : '9'}); but in mix table it doesn't recognize ۱ as number and ۲ (2 in English) is upper than ۱۱۱ (111 in English) also i tested it in meta https://meta.wikimedia.org/wiki/User:Reza1615/test it is the same as fa.wiki
I added your fixing advise http://fa.wikipedia.org/w/index.php?title=%D9%85%D8%AF%DB%8C%D8%A7%D9%88%DB%8C%DA%A9%DB%8C:Common.js&diff=5689809&oldid=5640897 but didn't work :( please check this again: http://fa.wikipedia.org/wiki/%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1:Reza1615/table_bug
it is solved thank you from who solved it :) http://winkyfrown.com/fawiki/index.php/Table