on 01-13-2015 5:56 AM
Hi Experts
I am doing a test, and is not completely working.... I am displaying a table with the content of the Categories from the Northwind, with the $expand=Products, To get the products linked to the categories... On the table I can get to display the info from the categories but not the info for the products.
This is the code... You are welcome to test it
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta http-equiv='Content-Type' content='text/html;charset=UTF-8'/>
<script src="https://sapui5.hana.ondemand.com/resources/sap-ui-core.js"
id="sap-ui-bootstrap"
data-sap-ui-libs="sap.m,sap.ui.table"
data-sap-ui-theme="sap_bluecrystal">
</script>
<!-- only load the mobile lib "sap.m" and the "sap_bluecrystal" theme -->
<script>
var url = "proxy/http/services.odata.org/Northwind/Northwind.svc/";
var oModel = new sap.ui.model.odata.ODataModel(url, true);
sap.ui.getCore().setModel(oModel);
var oTable = new sap.ui.table.Table("table", { // create Table UI
title: "Northwind - Orders",
columns : [
{label: "Description", template: "Description" },
{label: "Category Name", template: "CategoryName" },
{label: "Category ID", template: "CategoryID"},
{label: "Product ID", template: "Products/ProductID"},
{label: "Supplier ID", template: "Products/SupplierID"},
{label: "Produc tName", template: "Products/ProductName"}
]
});
oTable.bindRows({
path: "/Categories",
parameters: {
select:"Description,CategoryName,CategoryID,Products/ProductID,Products/SupplierID,Products/ProductName",
expand:"Products"
}
}); // bind the table rows
oTable.placeAt("content"); // place Table onto UI
</script>
</head>
<body class="sapUiBody" role="application">
<div id="content"></div>
</body>
</html>
Any ideas?
Regards
Henry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.