Nested object value on platform (everlive)

[Anthony]

Hi

I have nested object field in Telerik Platform (everlive data) which I want to display in a grid. 

I could only manage to display such a nested object value when hardcoding the data in JS as follow:

//HARDODED

var data = [ {  "Id": "asdads",  "surname": "asdaassadds", "healthRiskAssessment": { "totalAlcoholPerWeek": "test 59" } }];
var dataSource = new kendo.data.DataSource({
    data: data
});

$("#kendoGridExportAll").kendoGrid({
            dataSource: dataSource,
            columns: [    { field: "Id" },    { field: "surname" },  { field: "healthRiskAssessment.totalAlcoholPerWeek" }   ]
        });​

//---------------

 

But I could not get the "totalAlcoholPerWeek" field to dosplay while using everlive. See telerik data screenshot. Could you please assist?

//EVERLIVE

var dataSource = new kendo.data.DataSource({ type: "everlive", transport: { typeName: "healthRiskAssessment" }});
$("#kendoGridExportAll").kendoGrid({

            dataSource: dataSource,

            columns: [{ field: "Id" }, { field: "surname" }, { field: "healthRiskAssessment.totalAlcoholPerWeek" } ]

});​

​

[Anthony]

FYI. The "surname" field displays in the Everlive grid. But the totalAlcoholPerWeek is blank.

[Anton Dobrev]

Hello Trev,

Most probably the reason for this behavior is that the healthRiskAssessment in the database is saved as a string and not as an object. Thus, the configuration of the Grid widget cannot access the property totalAlcoholPerWeek.

For example, the current state is:

healthRiskAssessment: {\"totalAlcoholPerWeek\" : \"23\" }

while the correct value to be used by the Grid is:

healthRiskAssessment: { "totalAlcoholPerWeek" : "23" }

You may want to examine the code that creates the value for healthRiskAssessment and adjust it to do not enter the value as a string.

Let me know if you have questions.

Regards,
Anton Dobrev
Telerik