Skip to Content
0
Feb 04, 2014 at 02:40 PM

System query options $orderby etc error for sap.m.Table bindItem method

635 Views

I am trying to bind an OData Service to a sap.m.Table using bindItem method as follows:

closingBalanceTable.bindItems("/CreditSocietyStatementSet('2014')",new sap.m.ColumnListItem({

cells: [

new sap.m.Text({

text : "{TotContriOpenBal}"

}),

new sap.m.Text({

text : "{TotContriOpenBal}"

})

]

}));

its throwing following error:

{"error":{"code":"005056A509B11EE1B9A8FEC11C23378E","message":{"lang":"en","value":"System query options '$orderby,$skip,$top,$skiptoken,$inlinecount,' are not allowed in the requested URI"}}}


OData Service returns only single element as follows response:


<content type="application/xml">

<m:properties>

<d:IFyear>2014</d:IFyear>

<d:TotContriCloseBal>53726.00</d:TotContriCloseBal>

<d:TotContriDepContri>0.00</d:TotContriDepContri>

<d:TotContriOpenBal>53726.00</d:TotContriOpenBal>

<d:UnitCode/>

</m:properties>

</content>