Skip to Content
0
Mar 15, 2018 at 04:45 PM

Separate OData into two tables based on a criterial

171 Views Last edit Mar 15, 2018 at 06:08 PM 2 rev

Hi,

I wanted to separate oData coming from 1 entity set into two tables. The Active table would need to show only the ones with the end date of 20180312 and the Future table would show the rest.

I was trying to use the Filter and Filter operator but it still shows all the entries.

Currently I bind it like this:

var activeTemplate = new sap.m.ColumnListItem({
	cells: [
		new sap.m.Text({
				text: "{USER_ID}"
				}),
		new sap.m.Text({
				text: "{USER_LASTNAME}, {USER_FIRSTNAME}"
				}),
		new sap.m.Text({
				text: "{START_DATE} - {END_DATE}"
			})
				]
			});
var date = "20180312";
var oFilterActive = new Filter("END_DATE", FilterOperator.EQ, date);
activeTable.bindItems({
	path: "/ITS_OQASet",
	filter: oFilterActive,
	template: activeTemplate});
			
var date1 = "20180530";
var oFilterFuture = new Filter("END_DATE", FilterOperator.EQ, date1);
futureTable.bindItems({
	path: "/ITS_OQASet",
	filter: oFilterFuture,
	template: activeTemplate});

Thanks!

Attachments

tables.png (20.2 kB)