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

CMIS query on type with complex property fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 7.1
    • Fix Version/s: 7.4
    • Component/s: CMIS

      Description

      When the nuxeo-dam marketplace package is installed, the following CMIS query fails:

      SELECT * FROM Picture
      

      With, on the server side:

      Invalid query: CMISQL: SELECT * FROM Picture : org.nuxeo.ecm.core.api.ClientException: Failed to execute query: NXQL: SELECT ecm:uuid, dc:title, dc:description, dc:creator, dc:created, dc:lastContributor, dc:modified, ecm:currentLifeCycleState, ecm:parentId, ecm:name, ecm:pos, ecm:isLatestVersion, ecm:isLatestMajorVersion, ecm:versionLabel, ecm:isVersion, ecm:isCheckedIn, size, icon-expanded, icon, uid, major_version, minor_version, dc:description, dc:language, dc:coverage, dc:valid, dc:creator, dc:modified, dc:lastContributor, dc:rights, dc:expired, dc:format, dc:created, dc:title, dc:issued, dc:nature, dc:source, dc:publisher, filename, dateline, origin, caption, language, source, cropCoords, slugline, genre, typage, credit, headline, subheadline, byline, info, imd:color_space, imd:user_comment, imd:image_description, imd:date_time_original, imd:focal_length, imd:white_balance, imd:copyright, imd:fnumber, imd:pixel_xdimension, imd:equipment, imd:orientation, imd:exposure_time, imd:xresolution, imd:iso_speed_ratings, imd:icc_profile, imd:yresolution, imd:pixel_ydimension, imd:focalLength, ecm:primaryType FROM Document WHERE ecm:primaryType IN ('Picture') AND ecm:currentLifeCycleState <> 'deleted' AND ecm:isLatestVersion = 1 AND ecm:isProxy = 0: No such property: info

      Note that the following works, because views is a complex list which is never passed to the NXQL query:

      SELECT views FROM Picture
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.