-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: V4.0_ERRATA02
-
Fix Version/s: V4.01_WD01
-
Component/s: URL Conventions
-
Labels:None
-
Environment:
New Query Capabilities; [Proposed]
-
Proposal:
-
Resolution:
The count of a collection-valued (structural or navigation) property can already be used in common expressions, e.g. in $orderby.
It would be useful to also allow the /$count segment followed by a nested filter or search option, e.g.
GET entitySet?$filter=navigationProperty/$count($filter=YYY) gt 5&$expand=navigationProperty/$count($filter=XXX)&$orderby=navigationProperty/$count($filter=XXX) desc
to get the entities with the highest number of related entities matching filter first.
This was proposed on the Olingo mailing list: http://mail-archives.apache.org/mod_mbox/olingo-user/201512.mbox/%3C5662B48C.7020305%40gmail.com%3E