Problem in Complex Binding Propertied to Grid

[ahmed]

I bind to list of columns, some of them are complex like "ProfileDetails" property.
If we bind to a complex column like “ProfileDetails.FullAddress” while “ProfileDetails” object is null in received data  
we get an exception on JavaScript code and no data appear. 

can any one tell me how to fix it 

[ahmed]

Here is My Code Demo To Explain my problem : 
 var list= [{
        "EmployeID": "1",
        "ProfileDetails":
            {
                "id": 1,
                "FullAddress": "4 u st.,uk"
            },
 "isAdmin": false}];
  var tempSource = new kendo.data.DataSource({
        data: list,});
$("#grid").kendoGrid({
        dataSource: tempSource,
        columns: [{field:"EmployeID",title:"ID"},{field:"ProfileDetails.FullAddress",title:"Address"}],});

[ahmed]

Here is My Code Demo To Explain my problem : 
 var list= [{
        "EmployeID": "1",
        "ProfileDetails":
            {
                "id": 1,
                "FullAddress": "4 u st.,uk"
            },
 "isAdmin": false},{
        "EmployeID": "2",
        "ProfileDetails":null,
 "isAdmin": true}];
  var tempSource = new kendo.data.DataSource({
        data: list,});
$("#grid").kendoGrid({
        dataSource: tempSource,
        columns: [{field:"EmployeID",title:"ID"},{field:"ProfileDetails.FullAddress",title:"Address"}],});

[Petur Subev]

Hello Ahmend,

You can fix this by defining a safe template because the built-in one that is generated looks like this:

template: "#= complex.foo #"

And what you can use is:

template: "#= complex && complex.foo #"

Kind Regards,
Petur Subev
Telerik

 

 

[ahmed]

This fix my problem thank you

[Jacques]

Using a template breaks filtering. You end up with the "".toLowerCase is not a function exception.

Kendo version: 2015.1.408

 

[Boyan Dimitrov]

Hello Jacques,

Basically sorting / filtering / grouping of columns that are bound to a complex property from the model is not supported out-of-the-box as the Grid didn't have the information about which of the nested fields should be used for these operations.

If the field configuration is set as 

{field:"ProfileDetails.FullAddress",title:"Address"}

the filtering will work on the FullAdress value. 

Regards,
Boyan Dimitrov
Telerik