7.1: Add example for grouping by single-valued navigation property

XMLWordPrintable

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

      Applied

    • Hide

      Proposal amended during meeting 2018-7-19: treat group by NavProp as group by NavProp/$ref and return the nested @odata.id values

      Since section 3.10.1 only mentions grouping by navigation properties, but lacks a definition that is then finally given by example in section 7.1, move the relevant statements from section 7.1 to 3.10.1

      Show
      Proposal amended during meeting 2018-7-19: treat group by NavProp as group by NavProp/$ref and return the nested @odata.id values Since section 3.10.1 only mentions grouping by navigation properties, but lacks a definition that is then finally given by example in section 7.1, move the relevant statements from section 7.1 to 3.10.1

      Section 7.1 defines the result of grouping by a single-valued navigation property without giving an example.

      Any example in this section that groups by the key property of a related entity could be rephrased to group by the navigation property instead. Here's how example 52 would look like:

      GET ~Sales?$apply=groupby((Customer,Product))

      and results in

      {
  "@odata.context": "$metadata#Sales(Customer,Product)",
  "value": [
    { "@odata.id": null, "Customer": { "@odata.id": "Customers('C1')" }, "Product": { "@odata.id": "Products('P2')" } },
    { "@odata.id": null, "Customer": { "@odata.id": "Customers('C1')" }, "Product": { "@odata.id": "Products('P3')" } },
    { "@odata.id": null, "Customer": { "@odata.id": "Customers('C1')" }, "Product": { "@odata.id": "Products('P1')" } },
    { "@odata.id": null, "Customer": { "@odata.id": "Customers('C2')" }, "Product": { "@odata.id": "Products('P2')" } },
    { "@odata.id": null, "Customer": { "@odata.id": "Customers('C2')" }, "Product": { "@odata.id": "Products('P3')" } },
    { "@odata.id": null, "Customer": { "@odata.id": "Customers('C3')" }, "Product": { "@odata.id": "Products('P3')" } },
    { "@odata.id": null, "Customer": { "@odata.id": "Customers('C3')" }, "Product": { "@odata.id": "Products('P1')" } }
  ]
}

            Assignee:
            Unassigned
            Reporter:
            handl
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: