Kendo Grid / JSDO / Not returning single table in multi-table data source - Forum - Mobile - Progress Community

Kendo Grid / JSDO / Not returning single table in multi-table data source

 Forum

Kendo Grid / JSDO / Not returning single table in multi-table data source

This question is not answered

Hi All 

I have a very simple Kendo Grid:

dataSource = new kendo.data.DataSource( {type: "jsdo",

serverPaging: true,

serverFiltering: true,
// filter: { field: "Country", operator: "eq", value: "USA" },
serverSorting: true,
// sort: { field: "State", dir: "desc" },
pageSize: 10,
transport: {
jsdo: "OEAA.Repairs.LocationListBusinessEntity",


tableRef: "eLocListEntries",


// viewTables can be used as a comma separated list to selectively fill
// child/grandchild tables of the tableRef specified above. By default
// if querying top level table in the dataset, all children are returned
// if querying a child table, only the child table will be returned. Can
// also use wildcards in the comma separated list e.g. eJob*
viewTables: "",
countFnName: "count"
},

The JSON returned is of the format:

{
"dsLocationList": {
"eLocList": [{
"OrgCode": "01",
"ClientCode": "",
"LocList": "PB",
"Description": "PB",
"NoOfLocations": 0,
"Inactive": false,
"CustomUIResponse": null,
"id": "01||PB",
"seq": null
}, {
"OrgCode": "01",
"ClientCode": "HSG",
"LocList": "BOIL",
"Description": "boiler scheme II",
"NoOfLocations": 2,
"Inactive": false,
"CustomUIResponse": null,
"id": "01|HSG|BOIL",
"seq": null,
"eLocListEntries": [{
"OrgCode": "01",
"ClientCode": "HSG",
"LocList": "BOIL",
"PlaceRef": "1000191",
"Address": "46 Stanhope Park Drive, Carlisle, Cumbria, CA1",
"LocationStatus": "O",
"LocationStatusDescription": "Occupied",
"LocationSubStatus": "OCC",
"LocationSubStatusDescription": "Occupied",
"JobAllowed": "Y",
"CustomUIResponse": null,
"id": "01|HSG|BOIL|1000191",
"seq": null
},

But the grid is empty.

Any ideas?

Thanks

All Replies
  • Your JSON is nested. And the first eLocList record does not have any child records. Does it work when the first eLocList record has child records?

    Did you try without a nested relation?

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • Hi Mike

    This was developed using the CW framework and the UI was created using the BE entity designer.

    See screenshots.

    Shall i log a call for this.

    Thanks

  • ... that still leaves you the option to NOT use nested in the relations.

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • Hi Mike

    This seems to work with the JSDO 4.2 and OE 11.6.3 but not the JSDO 4.4 and OE 11.7.2.

    Is this what you would expect.

    Thanks

  • Hello,

    I'm afraid that this is a known limitation of the JSDO. Our Angular components do offer a fix for this, however I am afraid that there is no known workaround for working with partial datasets using the JSDO directly.

  • Not to use nested would probably work, but wouldn't it be nice to be able to have nested in relations and still be able to return the data from any level in the hierarchy? We have marked all our BE dataset relations as nested.

  • How do you mark your relations as nested?

  • It’s a property on the relation.

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.