natural sort on data source field

[Paul]

Is there a way to override or add functionality to the data source so i can add natural sort functionality?  I have a column that has numbers stored as text.  I need it to sort using a natural sort.

I'm using the an ajax data source on a grid.  Where does the sort actually happen, server side or client side?

thanks,
~ Paul

[Alexander Valchev]

Hi Paul,

Kendo DataSource supports both client and server side sorting. By default server side sorting is turned off and sorting happens on the client side.

I believe that the problem in your case is connected with the type of the fields which are defined in schema.model.type object. If the field types are not defined explicitly, the DataSource will consider them as strings - this is the reason why numbers are sorted in alphabetical order.

Please check your DataSource configuration, the model should look like:

schema: {
    model: {
        id: "ProductID",
        fields: {
            ProductID: { editable: false, nullable: true },
            ProductName: { type: "string" },
            UnitPrice: { type: "number", validation: { min: 1} }
        }
    }
}

I hope this will help.

Kind regards,
Alexander Valchev
the Telerik team