[Progress Communities] [Progress OpenEdge ABL] Forum Post: Kendo Grid / JSDO / Not returning single table in multi-table data source

[christian.bryan@capita.co.uk]

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

Continue reading...