Unable to bind TableSelectDialog . Getting empty table .

[Former Member]

novalue.jpg
onpressTableDialogfunction : function()

{
 	var sSelectedItemText = this.byId("POInput").getValue();
 	
 	 var oTableSelectDialog4 = new sap.m.TableSelectDialog( {
			title: "Inbound Delivery Details",
	
		
			multiSelect : true,
		
			columns : [
				new sap.m.Column({
					hAlign: "Begin",
					header: new sap.m.Label({
						text: "Inbound Delivery "
					})
				})
			
			], 
			items :
			[new sap.m.ColumnListItem({
					cells:[
					new sap.m.Text({
					text :"{InboundDelivery}"
				})
					]	
			})
							]
		});
		
		
		var sJson12 = {};
			var oModel1 = new sap.ui.model.json.JSONModel();
		this.oApplicationFacade.getApplicationModel("oData").read("GR4PO_DL_Headers('" + sSelectedItemText + "')/?$expand=Header2Items",
				null,
				null,
				false,
				function(oData, oResponse) {
						
sJson12.InboundDelivery = oData.Header2Items.results[0].InboundDelivery;
// Check header for backend system errors
var oHeader = oResponse.headers["sap-message"];
			if (oHeader) {
			var oJson = JSON.parse(oHeader);
				if (oJson.code) {
		sap.ca.ui.message.showMessageBox({
			type: sap.ca.ui.message.Type.INFO,
		message: decodeURIComponent(oJson.message)
						}, null);

					
						}
					}
				}
					);
	oModel1.setData(sJson12);
oTableSelectDialog4.setModel(oModel1);
 console.log(sJson12, "2200004784");
		       
  oTableSelectDialog4.open();
 
 	
 }

[former_member227918 · Accepted solution]

do read like this,

var aFilters = [];
//use your filter property(Itemname) and value (Item1)
var oFilter = new sap.ui.model.Filter("ItemName", sap.ui.model.FilterOperator.EQ, "Item1"); 
aFilters.push(oFilter);
this.oApplicationFacade.getApplicationModel("oData").read("/GR4PO_DL_Headers", {
    filters : aFilters,
    urlParameters: {
        "$expand": "Header2Items"
    },
    null,
    null,
    false,
    function(oData, oResponse) {.............

And, aggregation binding as below,

var oTableSelectDialog4 = new sap.m.TableSelectDialog({
    title: "Inbound Delivery Details",
    multiSelect: true,
    columns: [
        new sap.m.Column({
            hAlign: "Begin",
            header: new sap.m.Label({
                text: "Inbound Delivery "
            })
        })
    ]
});

var oTemplate = new sap.m.ColumnListItem({
		cells:[new sap.m.Text({text:"{InboundDelivery}"})]

});


oTableSelectDialog4.setModel(oModel1);
oTableSelectDialog4.bindItems("/results", oTemplate); //check your data if data inside "results", if not do "/" only

[Former Member · Accepted solution]

if i am passing Filters in ,read url ( in Networks) is

/GR4PO_DL_Headers?$expand=Header2Items&$filter=InboundDelivery%20eq%20%272200004784%27

however it should be (to get value from odata)

/GR4PO_DL_Headers('2200004784')?$expand=Header2Items

let me know how can this be fixed

[former_member227918 · Accepted solution]

var sInboundDelivery = "2200004784";
this.oApplicationFacade.getApplicationModel("oData").read("/GR4PO_DL_Headers('" + sInboundDelivery  + "')", {
//filters: aFilters, //remove this line

try this.

[Former Member · Accepted solution]

i am able to read odata correctly but table is still not displaying values . let me know how can this be fixed

		var sSelectedItemText = this.byId("POInput").getValue();


		var oModel1 = new sap.ui.model.json.JSONModel();
		this.oApplicationFacade.getApplicationModel("oData").read("GR4PO_DL_Headers('" + sSelectedItemText + "')/?$expand=Header2Items",
			null,
			null,
			false,
			function(oData, oResponse) {
				oModel1.setData(oData);
				 console.log(oData, "Inside read");
				var oHeader = oResponse.headers["sap-message"];
				if (oHeader) {
					var oJson = JSON.parse(oHeader);
					if (oJson.code) {


						sap.ca.ui.message.showMessageBox({
							type: sap.ca.ui.message.Type.INFO,
							message: decodeURIComponent(oJson.message)
						}, null);


					}
				}
			}
		);
	
		var oTableSelectDialog4 = new sap.m.TableSelectDialog({
			title: "Inbound Delivery Details",
			multiSelect: true,
			columns: [
				new sap.m.Column({
					hAlign: "Begin",
					header: new sap.m.Label({
						text: "Inbound Delivery "
					})
				})
			]
		});


		var oTemplate = new sap.m.ColumnListItem({
			cells: [new sap.m.Text({
				text: "{InboundDelivery}"
			})]


		});


		oTableSelectDialog4.setModel(oModel1);
		oTableSelectDialog4.bindItems("/", oTemplate);


		
		oTableSelectDialog4.open();


	

[Former Member · Accepted solution]

pfb the table : it is showing rows but the value is not getting bind.

Console.log(oData); in read of odata .

[former_member227918 · Accepted solution]

try

oTableSelectDialog4.bindItems("/Header2Items/results", oTemplate);

[former_member227918 · Accepted solution]

please accept this thread as right answer that will be helpful for others 🙂

[former_member227918 · Accepted solution]

you closed this without accepted the right ans 😛 just mark it as right ans 🙂

[Former Member]

yes it solved the issue . Thank you Akhilesh

[former_member365727]

Aggregation binding of 'items' is missing in your code

check the explored app

[Former Member]

since i have to pass a value while reading odata also it has $expand , how can i bind this with items aggegation .?

.read("GR4PO_DL_Headers('" + sSelectedItemText + "')/?$expand=Header2Items"