Standard Tiles displaying particular number of records present in database table
<p>I am trying to create a page with standard tiles inside a tile container displaying the number of records (that are approved/ rejected/ pending) present in table made in view called by that tile not the entries of complete table.</p>

<p>The following code displays the records present in whole table.  </p>

<p>Here's the code:</p>

<p><em>tiletest.view.js</em></p>

<pre><code>var oDataModel = new sap.ui.model.odata.ODataModel("https://.../tiletest/tile.xsodata", true);

var items;
oDataModel.read("/Expense", null, null, false, function success(oData) {
        items = oData.results.length;
    },
    function failure() {});
var page1 = new sap.m.Page("page1", {
        showHeader: false
    }),
    content: [
        new sap.m.TileContainer({
            tiles: [
                new sap.m.StandardTile("tile", {
                    title: "Request",
                    info: "Create Request",
                    infoState: "Success",
                    press: function() {
                        oController.ab();
                    }
                }),
                new sap.m.StandardTile("tile1", {
                    number: items,
                    title: "Approved",
                    info: "Approved Requests",
                    infoState: "Success",
                    press: function() {
                        oController.appr();
                    }
                }),
                new sap.m.StandardTile("tile2", {
                    number: items,
                    title: "Rejected",
                    info: "Rejected Request",
                    infoState: "Warning",
                    press: function() {
                        oController.appr1();
                    }
                })
            ]
        })
    ]
});

return page1;
}
</code></pre>

<p><em>tiletest.controller.js</em></p>

<pre><code>sap.ui.controller("test1.tiletest", {
    ab: function() {
        var app = sap.ui.getCore().byId("AppID");
        app.to("list_id2");
    },

    ab2: function() {
        var app = sap.ui.getCore().byId("AppID");
        app.to("list_id6");
    },

    appr: function() {
        var app = sap.ui.getCore().byId("AppID");
        app.to("list_id4");
    }
}); 
</code></pre>

<p><em>tile.xsodata</em></p>

<pre><code>service{
"DATABASE_NAME"."TABLE_NAME" as "Expense";
 }
</code></pre>