-
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:
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.
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)))}} |
Status | New [ 10000 ] | Closed [ 6 ] |
Status | Closed [ 6 ] | Open [ 1 ] |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Resolved [ 5 ] |
Status | Resolved [ 5 ] | Applied [ 10002 ] |
Status | Applied [ 10002 ] | Closed [ 6 ] |
Duplicate of
ODATA-1255