OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

odata message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [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:

    Environment: [Proposed]

> 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
>         Environment: [Proposed]
>            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

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]