Uploaded image for project: 'OASIS Open Data Protocol (OData) TC'
  1. OASIS Open Data Protocol (OData) TC
  2. ODATA-897

Allow the count of a filtered/searched collection in common expressions

    XMLWordPrintable

    Details

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

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              handl Ralf Handl
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: