OASIS Open Data Protocol (OData) TCIcon indicating the project type

OASIS Open Data Protocol (OData) TC

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

Examples 60, 61: Missing aggregation method for $count on related entities

    Details

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

      Proposed

    • Proposal:
      Hide

      Ex 60: Replace

      GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount))

      with

      GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))

      Ex 61: Replace

      GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount,Sales(Amount with sum as TotalAmount)))

      with

      GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount,Sales(Amount with sum as TotalAmount)))

      Show
      Ex 60: Replace GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount)) with GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount)) Ex 61: Replace GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount, Sales(Amount with sum as TotalAmount))) with GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount, Sales(Amount with sum as TotalAmount)))

      Description

      The examples make use of $count applied to a path expression in an aggregate expression without specifying an aggregation method, e.g. aggregate(Sales/$count as SalesCount)

      This syntax construct and its semantics has been introduced in the Core specification, section 11.2.6.1 System Query Option $filter and must not be confused with the virtual property $count defined in the Data Aggregation extension specification, section 3.1.5 Virtual Property $count. It represents a common expression that, if used in the aggregate transformation, must be complemented with an aggregation method.

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          gerald.krause1 Gerald Krause created issue -
          gerald.krause1 Gerald Krause made changes -
          Field Original Value New Value
          Proposal Ex 60:
           Replace

          {{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount))}}

          with
          {{ GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))}}

          Ex 61: Replace

          {{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}

          with

          {{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}           		*Ex 60: Replace*

          {{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount))}}

          with

          {{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))}}

          *Ex 61: Replace*

          {{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}

          with

          {{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}
          Hide
          Permalink
          gerald.krause1 Gerald Krause added a comment -

          Duplicate of ODATA-1255

          Show
          gerald.krause1 Gerald Krause added a comment - Duplicate of ODATA-1255
          gerald.krause1 Gerald Krause made changes -
          Status New [ 10000 ] Closed [ 6 ]
          handl Ralf Handl made changes -
          Status Closed [ 6 ] Open [ 1 ]
          handl Ralf Handl made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          handl Ralf Handl made changes -
          Status Resolved [ 5 ] Applied [ 10002 ]
          handl Ralf Handl made changes -
          Status Applied [ 10002 ] Closed [ 6 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved: