get aggregated data via oData service

[Former Member]

Hi experts,

I have a oData service with aggregation option like that:

service namespace "example.service" {

     "<schema>"."<table_name>" as "CarSales"

     keys generate local "OrderId"

     aggregates always (SUM of "Quantity");

}

And UI5 table which is generated dynamically (columns).

oData service normal works with any requests (with select, filter options, etc.), but i can't bind select operator to UI5 table (it generates request without select operator, so returns not aggregated data)

I can take aggregated data in json format (create json model, bind it to table), but the table is too big...

Can i combine operators select and filter in UI5 table (using dynamic oData requests), in order to generate request like that:

.../services/Orders.xsodata/CarSales/?$skip=1100&$top=1000&$filter = Brand eq 'BMW'&$select = Car, Quantity&$inlinecount=allpages

(writed manually)

P.S.

Only filter operator within the UI5 table works good.

Thanks in advance.

Andrew.

[former_member91307 · Accepted solution]

Hi Andrew,

You could pass the select parameter while binding as shown below is an example on

http://services.odata.org/Northwind/Northwind.svc

{ path:"/Products",

                              parameters: {select : "ProductName,ProductID"},

                              filters:[new sap.ui.model.Filter("ProductName", "Contains", 'X')]

                              }

Attached is the example using northwind service.

Please remove .txt extension.

Thanks and Regards, Venkatesh

selct parameters with binding.html.txt.zip