This is a migrated thread and some comments may be shown as answers.

DataSource + Sort + case insensitive?

5 Answers 80 Views
Data Source
This is a migrated thread and some comments may be shown as answers.
Kyle
Top achievements
Rank 1
Kyle asked on 12 Jun 2012, 01:30 PM
Hello,
I'm trying to add sorting to a DataSource, which generally is working just fine. The only problem is that it seems the sort mode is case sensitive.

If you check out this Fiddle: http://jsfiddle.net/EaNm4/ 
You will see what I mean. ('Alphy' is at the beginning of the list, while 'alpha' is at the end of the list). Is there a way I can specify my own sort algorithm or a way to make the default one case insensitive? I've checked the docs but I'm having a hard time finding anything.

5 Answers, 1 is accepted

Sort by
0
Chris
Top achievements
Rank 1
answered on 12 Apr 2013, 11:27 PM
I got it to sort correctly by setting the serverSorting = true on the DataSource.
0
Markus
Top achievements
Rank 2
answered on 16 Dec 2013, 02:58 PM
Good day

http://www.kendoui.com/forums/kendo-ui-web/grid/how-to-enable-case-insensitive-sorting-on-kendo-ui-grid.aspx states that case insensitive sorting would be implemented in July

I use kendo.all 2013.3.1119 and my grid still sorts case sensitive.

Am I doing something wrong, or has it not been implemented?
Could it be because FirmaPlus is origanaly an int? However the problem is with User_firmaname which is a string type.

Markus

var dataSource = new kendo.data.DataSource({
        type: "json",
        transport: {
            read: {
                url: url,
                data:{
                    Accept: "application/json"
                }
            }
        },
          
             sort:[
        {field: "FirmaPlus", dir: "desc"},
         {field: "User_firmaname", dir: "asc"}
       ] ,
    });

0
Atanas Korchev
Telerik team
answered on 16 Dec 2013, 04:18 PM
Hello Markus,

Case insensitive sorting is enabled by default. Here is a demo showing it in action: http://jsbin.com/AvUQudU/1/edit

And here is how things looked when using an older version (Q1 2013): http://jsbin.com/aTinumIW/2/edit


Regards,
Atanas Korchev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Markus
Top achievements
Rank 2
answered on 17 Dec 2013, 07:58 AM
Dear Atanas

Thanks for the feedback. Just don't know why my icenium grid does not sort insensitvie :-( using 2013.3.1119

Markus

0
Atanas Korchev
Telerik team
answered on 17 Dec 2013, 08:21 AM
Hello Markus,

We can't tell that without a working case. I suggest trying to reproduce your issue in jsbin by modifying my example.

Regards,
Atanas Korchev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Tags
Data Source
Asked by
Kyle
Top achievements
Rank 1
Answers by
Chris
Top achievements
Rank 1
Markus
Top achievements
Rank 2
Atanas Korchev
Telerik team
Share this question
or