[OASIS Issue Tracker] (ODATA-662) Allow usage of $apply as "Expand Option" in $expand

[ https://issues.oasis-open.org/browse/ODATA-662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ralf Handl updated ODATA-662:
-----------------------------

    Description: 
We haven't specified the usage of $apply as "Expand Option" in $expand. 
There are good use cases for $apply as an option of $expand (and it combines very well):

    GET Products?$expand=Sales($apply=aggregate(Amount with sum as Total))

Returns all products, and the Sales navigation property value is a one-element array with the Total
Means: per Product in top-level result inline result of 

    GET Product(<key>)/Sales?$apply=aggregate(Amount with sum as Total)

This is equivalent to the clumsier

    GET Products?$apply=groupby((<key properties of Product>,<all non-key structural properties of Product>),aggregate(Sales/(Amount with sum as Total))


  was:
We haven't specified the usage of $apply as "Expand Option" in $expand. 
There are good use cases for $apply as an option of $expand (and it combines very well).


> Allow usage of $apply as "Expand Option" in $expand
> ---------------------------------------------------
>
>                 Key: ODATA-662
>                 URL: https://issues.oasis-open.org/browse/ODATA-662
>             Project: OASIS Open Data Protocol (OData) TC
>          Issue Type: Improvement
>          Components: OData Extension for Data Aggregation
>    Affects Versions: V4.0_CS01
>            Reporter: Martin Zurmuehl
>             Fix For: V4.0_CSD03
>
>
> We haven't specified the usage of $apply as "Expand Option" in $expand. 
> There are good use cases for $apply as an option of $expand (and it combines very well):
>     GET Products?$expand=Sales($apply=aggregate(Amount with sum as Total))
> Returns all products, and the Sales navigation property value is a one-element array with the Total
> Means: per Product in top-level result inline result of 
>     GET Product(<key>)/Sales?$apply=aggregate(Amount with sum as Total)
> This is equivalent to the clumsier
>     GET Products?$apply=groupby((<key properties of Product>,<all non-key structural properties of Product>),aggregate(Sales/(Amount with sum as Total))



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)