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

Use new HIERARCHY.ISVERSION column for version tests in NXQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4
    • Fix Version/s: 5.5
    • Component/s: Core VCS, Query & PageProvider

      Description

      In NXQL when testing ecm:isCheckedInVersion = 0 we generate:

      ... LEFT JOIN versions ON h.id = versions.id ... WHERE ...versions.id IS NULL

      This is costly and since NXP-5797 can be improved using the new hierarchy.isversion boolean.

        Attachments

          Issue Links

          depends on

          New Feature - A new feature of the product, which has yet to be developed. NXP-4464 VCS: allow NXQL to query complex properties

          • Major - Major loss of function.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. NXP-5797 Add versioning-related features to Nuxeo Core to support the CMIS versioning model

          • Major - Major loss of function.
          • Resolved

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: