Grid Sorting issue

[cra]

Hello all,

 

I have a grid bound to a datasource that is receiving data from an odata-v4 endpoint. The data is loaded correctly and I have several columns with templates defined as the data has some complex values. One of the fields in this complex object is a date field (returned as so: "2015-09-01T00:00:00-05:00"). By default sorting by this column does not work, neither does formatting using the format property in the grid column (format: "{0:MM/dd/yyyy}"). So I realize I need to declare the field as a date type in the schema.model. Thus I have: 

 

 

schema: {
    model: {
        fields: {
            workPeriod: {
                startDate: {type: "date"}
            }
        }
    }
}

 

However, this does not seem to be declaring the type correctly. Is this not how you reference a complex object in the schema for a datasource?

[cra]

UPDATE:

 

It seems there is no way to reference a nested object in the model. But what I was able to do was create a reference to a nested object at the "root" object using the from: attribute like so:

 

startDate: {type: "date" , from: "workPeriod.startDate"}

 

[Boyan Dimitrov]

Hello,

 

Indeed the Kendo UI DataSource is designed to work with flat data and does not support nested objects. Indeed this is the only to achieve sorting against complex object. 

 

Regards,
Boyan Dimitrov
Telerik