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] Commented: (ODATA-32) Allow filtering of expanded to-many navigation properties


    [ http://tools.oasis-open.org/issues/browse/ODATA-32?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31232#action_31232 ] 

Michael Pizzo commented on ODATA-32:
------------------------------------

I like the functionality, and I understand that it's legal syntax within a query string, but it does make it a bit confusing to visually parse. It would be nice to have something to group the $filter applied to Items expansion separate from the rest of the query parameters.

Also, I wonder if we should be doing a one-off for $filter. What about $orderby? $top/$skip? seems like we might want to apply these operators to the expanded property as well.

Finally, how would we do deep expands (i.e., expand a subset of the items and, for those items, the related products and categories).

We could support a more composable syntax like: 
    GET ~/PurchaseOrders?$filter=Status eq 'OPEN'&$expand=Items[$filter=WeightInKg gt 5000?$orderby=Quantity?$top=5?$expand=Products,Categories]

We would have to come up with the right grouping operators and separators

> Allow filtering of expanded to-many navigation properties
> ---------------------------------------------------------
>
>                 Key: ODATA-32
>                 URL: http://tools.oasis-open.org/issues/browse/ODATA-32
>             Project: OASIS Open Data Protocol (OData) TC
>          Issue Type: New Feature
>          Components: OData Protocol v1.0, OData URL Conventions v1.0
>    Affects Versions: WD01
>         Environment: [Proposed]
>            Reporter: Ralf Handl
>             Fix For: WD01
>
>
> "Give me all open purchase orders and expand all items that have a weight of over five tons"
> This cannot be expressed as a query on the items if these are contained in the orders.
> Even if the items are not contained, the reformulation as a query on items expanding the order would repeat the included order entities in case of multiple matching items, which is undesirable.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


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