<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>OData Date Table Multiple Sorters</title>
<link rel="stylesheet" type="text/css" href="">
<script id="sap-ui-bootstrap" src="https://openui5.hana.ondemand.com/resources/sap-ui-core.js" type="text/javascript" data-sap-ui-libs="sap.ui.core,sap.ui.commons,sap.ui.table" data-sap-ui-theme="sap_goldreflection">
</script>
<script>
var sURI = 'http://demos.kendoui.com/service/Northwind.svc/';
var oDataModel = new sap.ui.model.odata.ODataModel(sURI, true);
sap.ui.getCore().setModel(oDataModel, 'data');
var sEntity = '/Categories';
var properties = oDataModel.oMetadata._getEntityTypeByPath(sEntity).property;
var oMetaModel = new sap.ui.model.json.JSONModel();
oMetaModel.setData({
columns: properties,
});
sap.ui.getCore().setModel(oMetaModel, 'meta');
var oTable = new sap.ui.table.Table({
title: "OData Model dynamic column and data binding",
showNoData: true,
columnHeaderHeight: 10,
visibleRowCount: 7
});
oTable.bindColumns('meta>/columns', function(sId, oContext) {
var sColumnId = oContext.getObject().name;
return new sap.ui.table.Column({
id: sColumnId,
label: sColumnId,
template: new sap.ui.commons.TextView({"text" : {path: "data>" + sColumnId}}),
sortProperty: sColumnId,
filterProperty: sColumnId
});
});
oTable.bindRows('data>'+ sEntity);
oTable.placeAt("content");
</script>
</head>
<body class="sapUiBody" role="application">
<div id="content"></div>
</body>
</html>
Output
You can jump to the latest bin by adding /latest
to your URL
Keyboard Shortcuts
Shortcut | Action |
---|---|
ctrl + [num] | Toggle nth panel |
ctrl + 0 | Close focused panel |
ctrl + enter | Re-render output. If console visible: run JS in console |
Ctrl + l | Clear the console |
ctrl + / | Toggle comment on selected lines |
ctrl + ] | Indents selected lines |
ctrl + [ | Unindents selected lines |
tab | Code complete & Emmet expand |
ctrl + shift + L | Beautify code in active panel |
ctrl + s | Save & lock current Bin from further changes |
ctrl + shift + s | Open the share options |
ctrl + y | Archive Bin |
Complete list of JS Bin shortcuts |
JS Bin URLs
URL | Action |
---|---|
/ | Show the full rendered output. This content will update in real time as it's updated from the /edit url. |
/edit | Edit the current bin |
/watch | Follow a Code Casting session |
/embed | Create an embeddable version of the bin |
/latest | Load the very latest bin (/latest goes in place of the revision) |
/[username]/last | View the last edited bin for this user |
/[username]/last/edit | Edit the last edited bin for this user |
/[username]/last/watch | Follow the Code Casting session for the latest bin for this user |
/quiet | Remove analytics and edit button from rendered output |
.js | Load only the JavaScript for a bin |
.css | Load only the CSS for a bin |
Except for username prefixed urls, the url may start with http://jsbin.com/abc and the url fragments can be added to the url to view it differently. |