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

Add support for joining entities with instances of their related collections

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • 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

      To support such use cases, this gap could be closed by a new transformation join that allows decomposing the collections on the property path and hereby combining entities with instances of their related collections.

      The proposal is described in section 3.21 and examples 57 and 58 in this file: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/68332/ODATA-1409-2.docx

      Show
      To support such use cases, this gap could be closed by a new transformation join that allows decomposing the collections on the property path and hereby combining entities with instances of their related collections. The proposal is described in section 3.21 and examples 57 and 58 in this file: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/68332/ODATA-1409-2.docx

      Description

      Such a feature would allow handling property paths with one or more collection-valued segments in it, i.e. collection-valued navigation or complex properties.

      There are use cases in data aggregation that require to deal with such paths, e.g. to group by properties that can only be reached via a path involving a collection-valued navigation property like this:

      GET ~/Products?$apply=groupby((Name,Sales/Customer/ID), aggregate(TaxRate with average as AverageTaxRate))

       

      ODATA-1206 declared support for such paths with collection-valued properties in groupby, however it lacks a description how to process them and furthermore ODATA-1404 withdraws this statement by restricting grouping properties to be reached via single-valued navigation and complex properties.

        Attachments

        1. ODATA-1409.docx
          498 kB
          Gerald Krause
        2. ODATA-1409.docx
          512 kB
          Gerald Krause

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: