on 12-30-2014 7:14 PM
Hi Experts,
I called the xacute query in ajax and tried to bind with sap ui table.
But I could not get json data from query template,Instead it ruturning result as [object,object],[object,object],[object,object]
With static data Ui5 table is working fine but if bind it following way is working .
Pls help me to resolve it.
var oModel = new sap.ui.model.json.JSONModel();
$.ajax({
type: "POST",
success: function (data) {
alert("ok"+data);
var rows = data.Rowsets.Rowset[0].Row;
alert("rows"+rows);// returning object...... instead of actual results...
oModel.setData({modelData: rows});
oTable.setModel(oModel);
oTable.bindRows("/modelData");
},
error: function (err) {
alert("Local error callback.");
}
});//ajax close
Regards,
Raj.
Your alert outputs '[object]' etc because rows var is an object. Google "json to string" for ways to look at the content of your object.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Christian/Swarrop,
I could see the data if I display by converting with function decodeURIComponent($.param(data));
But I can bind it. Can you pls guid me..
$.ajax({
type: "POST",
success: function (data) {
alert("success");
var rows = data.Rowsets.Rowset[0].Row;
var Mat = data.Rowsets[Rowset][0][Row][0][MatNo];
//alert("rows"+data.Rowsets.Rowset[0]);
//var result = Y.QueryString.stringify(data);
var result =decodeURIComponent($.param(data)); // it is giving results in Rowsets[Rowset][0][Row][0][MatNo] format
alert("result" +result);
oModel.setData({modelData: rows}); // binding in this way
oTable.setModel(oModel);
oTable.bindRows("/modelData");
},
Regards,
Bikshapathi.
Hi Raj,
Please refer:
use something like shown below:
Create a column -
var oColumn = new sap.ui.table.Column({
label: new sap.ui.commons.Label({text: "Material No."}),
template: new sap.ui.commons.TextView().bindProperty("text", "MatNo"),
width: "200px"
});
Add this column to your table:
oTable.addColumn(oColumn);
Thanks,
Swaroop
Hi Raj,
How are you binding the columns?
Basically, data.Rowsets.Rowset[0].Row gives json output only. You need to bound elements using names you get under object[]of the row.
Let's say a column in Rowset[0] is "name", then columns in ui.table should be binded as "{name}".
Hope this helps.
Regards,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.