Skip to Content
avatar image
Former Member

DISTINCT in sapui5

Hello,

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?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Regards,

    Florian

    Add comment
    10|10000 characters needed characters exceeded