How to use as the datasource a property (field) of the result (Kendo Grid)

[ALEXIS]

Hi All,

I am creating the grid via javascript. The datasource is connected directly to the webservice. An example of the webservice result is the following:
[ { col1: "",
col2: "",
Items: [ { ....} }
}]

Instead of using the main result like col1 and col2 I need to use the Items. How can I specify that using the example below?

var locationItems = $("#grid").kendoGrid({
    columns: lockedGridColumns(),
    height: 500,
    scrollable: true,
    sortable: true,
    filterable: true,
    pageable: true,
    //reorderable: true,
    //resizable: true,
    autoBind: false
}).data("kendoGrid");

function getItems(locationId) {
    if (locationId == null) {
        locationId = 0;
    }   

var dataSource = new kendo.data.DataSource(locationId != 0 ?
            {
                transport: {
                    read: {
                        dataType: "json",
                        url: "api/items/getlocationitems?locationID=" + locationId
                    }
                },
                pageSize: 25
            } :
            {
                data: [],
                pageSize: 25
            });   

locationItems.setDataSource(dataSource);
    locationItems.dataSource.read();
}

[Nikolay Rusev]

Hello Alexis,

schema.data in DataSource configuration defines where the actual data is in the response.

Regards,
Nikolay Rusev
Telerik

 

 

[ALEXIS]

Hi,

If I use the transport to setup the datasource the properties total() or view doesnt work. How can I identify if the datasource returned something using transport. If I get the data outside and asign it to the datasource the previously mentioned properties work. I would like to use the transport because the progress of the grid shows automatically.

[Nikolay Rusev]

Hello Alexis,

I'm not sure whether I understand your question correctly. Usually when DataSource is configured for remote operation it must know from which field of the response to read the actual data and total information. All this settings can be defined in the schema configuration section.

schema.data for the actual data
schema.total for the total count of all items 

` If I get the data outside and asign it to the datasource the previously mentioned properties work.` - I assume that you are setting data of the DataSource via data field in the configuration or via data method. In this case DataSource will assume that this is all the data it have and use it to calculate the total etc.

Regards,
Nikolay Rusev
Telerik