get aggregated data via oData service

852 Views

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.