Uploaded image for project: 'Nuxeo Studio'
  1. Nuxeo Studio
  2. NXS-5611

Refactor NXQL queries

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Done
    • Affects Version/s: 3.21.2
    • Fix Version/s: 3.24.0
    • Component/s: Performances

      Description

      • NXQL queries are all over the NOS code base. There's no centralized or easy way to view all the queries that are being used. Makes it hard to perform maintenance tasks (such as NXS-5544 and NXS-5545).
      • There's no "standard" way to write the query => each one is a little different.
      • Some of them are duplicated.
      • Many of them can be refactored to be reused in different use cases.
      • We need to figure out what clauses are supposed to be in every query. For example ecm:isVersion = 0 and ecm:currentLifeCycleState != 'delete' are present in many of them, which makes me think if they might be missing from the others.

        Attachments

          Issue Links

          is required by

          Improvement - An improvement or enhancement to an existing feature or task. NXS-5544 Optimize NXQL for querying field of type list

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXS-5545 Add expression ecm:isProxy = 0 to all NOS queries

          • Major - Major loss of function.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 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 - 2 weeks
                  2w