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

VCS Oracle queries failing

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3.1
    • Fix Version/s: 5.3.2
    • Component/s: Core VCS

      Description

      The following NXQL query fails when used with security check:
      SELECT * FROM Document WHERE ecm:fulltext LIKE 'testNote1' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'

      -> ORA-00918: column ambiguously defined

        Attachments

          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: