Showing results for 
Search instead for 
Did you mean: 

DISTINCT in sapui5

Former Member
0 Kudos


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?


Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

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.