Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-19262

Improved query API for directories

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.3
    • Component/s: Directory
    • Epic Link:
    • Tags:
    • Impact type:
      API change
    • Upgrade notes:
      Hide

      New directory query APIs using a QueryBuilder:

      • Session.query(QueryBuilder, fetchReferences)
      • Session.queryIds(QueryBuilder)
      Show
      New directory query APIs using a QueryBuilder : Session.query(QueryBuilder, fetchReferences) Session.queryIds(QueryBuilder)
    • Sprint:
      nxFG 10.3.3, nxFG 10.3.4, nxFG 10.3.5, nxFG 10.3.6, nxFG 10.3.7, nxFG 10.3.8, nxFG 10.3.9
    • Story Points:
      8

      Description

      Currently directories can be queried through a map of key/values with the implicit semantics of filtering on key1 = value1 AND key2 = value2 AND ....

      However there is a need for more expressive filter clauses, the first being to do OR clauses, with or without the same keys. More generally, let's go to a fully general clause based on a org.nuxeo.ecm.core.query.sql.model.Predicate.

      The ordering features (ORDER BY) and paging features (LIMIT / OFFSET) must still be supported with this.

        Attachments

          Issue Links

          depends on

          Clean up - NXP-25526 Move AuditQueryBuilder common code to nuxeo-core-query

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. NXP-23085 Fix UserGroup.Suggestion operation when a group is set with the groupRestriction parameter

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. NXP-25382 Investigate lock issues and handle lock expiration

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          Improvement - An improvement or enhancement to an existing feature or task. NXP-19264 Improved query API for UserManager

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-25804 Improve expired locks query when NXP-19262 is done

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 week, 3 days
                  1w 3d