[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]