## Re: [Semediawiki-user] Problems with sorting

 Re: [Semediawiki-user] Problems with sorting From: Thomas Krueger - 2012-03-25 16:37:21 ```Hi, if I remenber correctly you have to use a "point" instead of a "coma" to separate the decimal value: e.g. 4; 5; 9; 15; 3.3; 3.4 ... nest regards, Thomas 2012/3/25 Francis Hunger - Grafik > Hi > > when doing this semantic search > > > http://de.wiki-products.org/Spezial:Semantische_Suche?title=Spezial%3ASemantische+Suche&q=%5B%5BKategorie%3APKW%5D%5D+%5B%5BNicht+mehr+im+Handel%3A%3Afalsch%5D%5D&po=%3FEnergieverbrauch+PKW%0D%0A%3FMix-Verbrauch%0D%0A&sort%5B0%5D=Energieverbrauch_PKW&order%5B0%5D=ASC&sort_num=&order_num=ASC&eq=yes&p%5Bformat%5D=broadtable&p%5Blimit%5D=500&p%5Bsort%5D=Energieverbrauch_PKW&p%5Boffset%5D=&p%5Bheaders%5D=show&p%5Bmainlabel%5D=Modell&p%5Blink%5D=all&p%5Bsearchlabel%5D=&p%5Bintro%5D=&p%5Boutro%5D=&p%5Bdefault%5D=&p%5Bclass%5D=sortable+wikitable+smwtable&eq=yes > > The sorting of the "Mixverbrauch" row doesn't work properly. If you > click the arrow, so that the Mixverbrauch row gets sorted ascending, I > see the values 4; 5; 9; 15; 3,3; 3,4 ... . So obviously the values that > do not have a decimal value get sorted wrongly. > > (MW 1.18.1; MySQL 5.0.77; SF 2.3.2; SMW 1.7.0.2) I did a SMW Database > update just to be sure. > > This might be a SMW problem or a MW problem. I guess the sorting is done > by javascript or jquery. > > Any comments, what to look for? > > Thanks, > > best > > Francis > > > > -- > > > > Francis Hunger > Bruederstr. 2 > 04103 Leipzig > > m: 0163-2013602 > e: info@... > w: http://www.design-hunger.com > > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Semediawiki-user mailing list > Semediawiki-user@... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > ```

 [Semediawiki-user] Problems with sorting From: Francis Hunger - Grafik - 2012-03-25 15:38:29 ```Hi when doing this semantic search http://de.wiki-products.org/Spezial:Semantische_Suche?title=Spezial%3ASemantische+Suche&q=%5B%5BKategorie%3APKW%5D%5D+%5B%5BNicht+mehr+im+Handel%3A%3Afalsch%5D%5D&po=%3FEnergieverbrauch+PKW%0D%0A%3FMix-Verbrauch%0D%0A&sort%5B0%5D=Energieverbrauch_PKW&order%5B0%5D=ASC&sort_num=&order_num=ASC&eq=yes&p%5Bformat%5D=broadtable&p%5Blimit%5D=500&p%5Bsort%5D=Energieverbrauch_PKW&p%5Boffset%5D=&p%5Bheaders%5D=show&p%5Bmainlabel%5D=Modell&p%5Blink%5D=all&p%5Bsearchlabel%5D=&p%5Bintro%5D=&p%5Boutro%5D=&p%5Bdefault%5D=&p%5Bclass%5D=sortable+wikitable+smwtable&eq=yes The sorting of the "Mixverbrauch" row doesn't work properly. If you click the arrow, so that the Mixverbrauch row gets sorted ascending, I see the values 4; 5; 9; 15; 3,3; 3,4 ... . So obviously the values that do not have a decimal value get sorted wrongly. (MW 1.18.1; MySQL 5.0.77; SF 2.3.2; SMW 1.7.0.2) I did a SMW Database update just to be sure. This might be a SMW problem or a MW problem. I guess the sorting is done by javascript or jquery. Any comments, what to look for? Thanks, best Francis -- Francis Hunger Bruederstr. 2 04103 Leipzig m: 0163-2013602 e: info@... w: http://www.design-hunger.com ```
 Re: [Semediawiki-user] Problems with sorting From: Thomas Krueger - 2012-03-25 16:37:21 ```Hi, if I remenber correctly you have to use a "point" instead of a "coma" to separate the decimal value: e.g. 4; 5; 9; 15; 3.3; 3.4 ... nest regards, Thomas 2012/3/25 Francis Hunger - Grafik > Hi > > when doing this semantic search > > > http://de.wiki-products.org/Spezial:Semantische_Suche?title=Spezial%3ASemantische+Suche&q=%5B%5BKategorie%3APKW%5D%5D+%5B%5BNicht+mehr+im+Handel%3A%3Afalsch%5D%5D&po=%3FEnergieverbrauch+PKW%0D%0A%3FMix-Verbrauch%0D%0A&sort%5B0%5D=Energieverbrauch_PKW&order%5B0%5D=ASC&sort_num=&order_num=ASC&eq=yes&p%5Bformat%5D=broadtable&p%5Blimit%5D=500&p%5Bsort%5D=Energieverbrauch_PKW&p%5Boffset%5D=&p%5Bheaders%5D=show&p%5Bmainlabel%5D=Modell&p%5Blink%5D=all&p%5Bsearchlabel%5D=&p%5Bintro%5D=&p%5Boutro%5D=&p%5Bdefault%5D=&p%5Bclass%5D=sortable+wikitable+smwtable&eq=yes > > The sorting of the "Mixverbrauch" row doesn't work properly. If you > click the arrow, so that the Mixverbrauch row gets sorted ascending, I > see the values 4; 5; 9; 15; 3,3; 3,4 ... . So obviously the values that > do not have a decimal value get sorted wrongly. > > (MW 1.18.1; MySQL 5.0.77; SF 2.3.2; SMW 1.7.0.2) I did a SMW Database > update just to be sure. > > This might be a SMW problem or a MW problem. I guess the sorting is done > by javascript or jquery. > > Any comments, what to look for? > > Thanks, > > best > > Francis > > > > -- > > > > Francis Hunger > Bruederstr. 2 > 04103 Leipzig > > m: 0163-2013602 > e: info@... > w: http://www.design-hunger.com > > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Semediawiki-user mailing list > Semediawiki-user@... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > ```