Skip to Content

DISTINCT in sapui5

Oct 10, 2016 at 06:31 PM


avatar image
Former Member


Im triyng to get data from an iot table and I want to filter it by ID. There is any way to do a distinct in the query?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Oct 10, 2016 at 06:35 PM

Hello Stefania,

I assume you expose your data via an XSOData service. XSOData supports at the moment OData 2.0 which has no option to determine the distinct values by e.g. a parameter. You can create a view on the DB layer which determines the distinct values for the data you need and then expose that view via XSOData.

With OData 4.0 distinct values are supported by the Extension for Data Aggregation. But so far there is not info, if in the upcoming releases which will support OData 4.0 that extension will be supported too.



10 |10000 characters needed characters left characters exceeded