...
Code Block | ||
---|---|---|
| ||
function sample(req,resp){ var reportObj = { columns: [{ columnType: "text", field: "YOUR_FIELD", title: "YOUR FIELD" }, { columnType: "text", field: "YOUR_OTHER_FIELD", title: "YOUR OTHER FIELD" }], data: [] }; function getAllAssets() { var assetsCollection = ClearBladeAsync.Collection('assets'); var query = ClearBladeAsync.Query(); query.equalTo('type', 'YOUR_ASSET_TYPE'); return assetsCollection.fetch(query).then(function (results) { return results.DATA; }); } getAllAssets().then(function(allAssetDetails) { for (var x = 0; x < allAssetDetails.length; x++) { var row = {}; //fields ex: id, label, custom_data, location row.YOUR_FIELD =allAssetDetails[x].YOUR_FIELD row.YOUR_OTHER_FIELD = allAssetDetailallAssetDetails[x].YOUR_OTHER_FIELD reportObj.data.push(row); } resp.success(reportObj); }).catch(function (reason) { console.error('failed: ', reason); resp.error(reason); }); } |
...