Correct examples 53, 54, and 61

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Minor
    • V4.0_CSD04
    • Affects Version/s: V4.0_CS02
    • Component/s: Data Aggregation
    • Environment:

      Applied

    • Hide
      1. Updates to sections 3.1 and 3.1.1 in the specification: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67246/ODATA-945%20-%20Proposal%20for%20Spec%20Update.docx
      2. Update examples in document:

      Replace response payload of example 53 with

      {
      "@odata.context": "$metadata#Products(Name,Total)",
      "value": [

      { "@odata.id": null, "Name": "Coffee", "Total": 12 }

      ,

      { "@odata.id": null, "Name": "Paper", "Total": 8 }

      ,

      { "@odata.id": null, "Name": "Pencil", "Total": null }

      ,

      { "@odata.id": null, "Name": "Sugar", "Total": 4 }

      ]
      }

      Example 54: Modify request to properly reflect the nesting shown in the response:
      GET ~/Products?$apply=groupby((Name,Sales/Currency/Code),
      aggregate(Sales(Amount with sum as Total)))

      Correct Example 61 as

      { "Name": "Coffee", "Forecast": 6, "Sales": [ { "Actual": 12 } ] }
      Show
      Updates to sections 3.1 and 3.1.1 in the specification: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/67246/ODATA-945%20-%20Proposal%20for%20Spec%20Update.docx Update examples in document: Replace response payload of example 53 with { "@odata.context": "$metadata#Products(Name,Total)", "value": [ { "@odata.id": null, "Name": "Coffee", "Total": 12 } , { "@odata.id": null, "Name": "Paper", "Total": 8 } , { "@odata.id": null, "Name": "Pencil", "Total": null } , { "@odata.id": null, "Name": "Sugar", "Total": 4 } ] } Example 54: Modify request to properly reflect the nesting shown in the response: GET ~/Products?$apply=groupby((Name,Sales/Currency/Code), aggregate(Sales(Amount with sum as Total))) Correct Example 61 as { "Name" : "Coffee" , "Forecast" : 6, "Sales" : [ { "Actual" : 12 } ] }

      Example 53 requests aggregation of property path Sales/Amount, but the response shows the dynamic property Total nested inside Sales. Rightly, it should have been “added to the type containing the original expression” (section 3.1.1).
      In example 54, the response payload shows the dynamic property Total nested within Sales. According to the request, which uses the path expression Sales/Amount for aggregation, the Total property should be at the top level.

            Assignee:
            Unassigned
            Reporter:
            gerald.krause1
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: