Uploaded image for project: 'OASIS Open Data Protocol (OData) TC'
  1. OASIS Open Data Protocol (OData) TC
  2. ODATA-1406

Clarify behavior of aggregate on property paths with collection-valued properties

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: V4.0_CSD03
    • Fix Version/s: V4.0_CSD04
    • Component/s: Data Aggregation
    • Labels:
      None
    • Environment:

      Applied

    • Proposal:
      Hide

      In section 3.1, extend the third paragraph (insertions surrounded by *):
      If paths are present, the corresponding navigation properties are implicitly expanded to make the properties part of the result representation. *For every collection-valued navigation or complex property in the path, the aggregate transformation considers the concatenated list of all instances identified by that property for the remainder of the path.*

      Show
      In section 3.1, extend the third paragraph (insertions surrounded by *): If paths are present, the corresponding navigation properties are implicitly expanded to make the properties part of the result representation. *For every collection-valued navigation or complex property in the path, the aggregate transformation considers the concatenated list of all instances identified by that property for the remainder of the path.*

      Description

      Example 53 illustrates a use case for such property paths:
      GET ~/Products?$apply=
      groupby((Name),
               }}{{aggregate(Sales/Amount with sum as Total))

      ODATA-1206 clarified that the aggregate transformation supports collection-valued navigation/complex properties in property paths.

      What is still missing for a complete definition is a description of the service behavior for the aggregate transformation applied on paths containing segments with collection-valued properties.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              gerald.krause1 Gerald Krause
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: