Ask Question
« General Questions on Nuxeo

CMIS JOIN Query result set properties not being populated

When I invoke the following CMIS JOIN Query against the Nuxeo Demo server, the d.nuxeo:contentStreamDigest and f.cmis:path properties in the result set are not populated. OTOH, when I invoke separate cmis:document and cmis:folder queries, these respective properties are indeed populated. Am I correct that this is a bug? If so, is it a nuxeo-chemistry bug or an apache chemistry bug?

Query:

curl -u Administrator:Administrator "http://demo.nuxeo.com/nuxeo/atom/cmis/default/query?q=SELECT+d.cmis:objectId,+d.cmis:name,+d.nuxeo:parentId,+d.nuxeo:contentStreamDigest,+f.cmis:path+FROM+cmis:document+d+INNER+JOIN+cmis:folder+f+ON+d.nuxeo:parentId+=+f.cmis:objectId+WHERE+IN_FOLDER(d,+'a4f296b4-d4bc-4321-8207-dad4a28c8bd6')+AND+d.nuxeo:isVersion=false&searchAllVersions=true" | tidy -q -xml -indent -wrap 999

Results:

<?xml version='1.0' encoding='utf-8'?>
<atom:feed xmlns:atom="http://www.w3.org/2005/Atom" xmlns:cmis="http://docs.oasis-open.org/ns/cmis/core/200908/" xmlns:cmisra="http://docs.oasis-open.org/ns/cmis/restatom/200908/" xmlns:app="http://www.w3.org/2007/app">
  <atom:author>
    <atom:name></atom:name>
  </atom:author>
  <atom:id>http://chemistry.apache.org/cXVlcnk=</atom:id>
  <atom:title>Query</atom:title>
  <app:edited>2013-08-21T15:15:28.824+02:00</app:edited>
  <atom:updated>2013-08-21T15:15:28.824+02:00</atom:updated>
  <cmisra:numItems>5</cmisra:numItems>
  <atom:link rel="service" href="http://demo.nuxeo.com/nuxeo/atom/cmis/default?repositoryId=default" type="application/atomsvc+xml" />
  <atom:entry>
    <atom:author>
      <atom:name></atom:name>
    </atom:author>
    <atom:id>http://chemistry.apache.org/aWQtMQ==</atom:id>
    <atom:published>2013-08-21T15:15:28.824+02:00</atom:published>
    <atom:title>Query Result id-1</atom:title>
    <app:edited>2013-08-21T15:15:28.824+02:00</app:edited>
    <atom:updated>2013-08-21T15:15:28.824+02:00</atom:updated>
    <cmisra:object>
      <cmis:properties>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="d.cmis:objectId">
          <cmis:value>ebbb1914-a769-44a6-a808-49923bc93ae5</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="nuxeo:contentStreamDigest" displayName="Content Stream Digest" localName="nuxeo:contentStreamDigest" queryName="d.nuxeo:contentStreamDigest" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="f.cmis:objectTypeId">
          <cmis:value>Folder</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="f.cmis:objectId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:path" displayName="Path" localName="cmis:path" queryName="f.cmis:path" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="d.cmis:objectTypeId">
          <cmis:value>File</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="nuxeo:parentId" displayName="Nuxeo Parent ID" localName="nuxeo:parentId" queryName="d.nuxeo:parentId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" localName="cmis:name" queryName="d.cmis:name">
          <cmis:value>Bon de commande.pdf</cmis:value>
        </cmis:propertyString>
      </cmis:properties>
      <cmis:rendition>
        <cmis:streamId>nx:icon</cmis:streamId>
        <cmis:mimetype>image/gif</cmis:mimetype>
        <cmis:length>589</cmis:length>
        <cmis:kind>cmis:thumbnail</cmis:kind>
        <cmis:title>folder.gif</cmis:title>
        <cmis:height>16</cmis:height>
        <cmis:width>16</cmis:width>
      </cmis:rendition>
    </cmisra:object>
  </atom:entry>
  <atom:entry>
    <atom:author>
      <atom:name></atom:name>
    </atom:author>
    <atom:id>http://chemistry.apache.org/aWQtMg==</atom:id>
    <atom:published>2013-08-21T15:15:28.824+02:00</atom:published>
    <atom:title>Query Result id-2</atom:title>
    <app:edited>2013-08-21T15:15:28.824+02:00</app:edited>
    <atom:updated>2013-08-21T15:15:28.824+02:00</atom:updated>
    <cmisra:object>
      <cmis:properties>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="d.cmis:objectId">
          <cmis:value>f184e5c0-009d-4eb0-ad11-1297833bcb07</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="nuxeo:contentStreamDigest" displayName="Content Stream Digest" localName="nuxeo:contentStreamDigest" queryName="d.nuxeo:contentStreamDigest" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="f.cmis:objectTypeId">
          <cmis:value>Folder</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="f.cmis:objectId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:path" displayName="Path" localName="cmis:path" queryName="f.cmis:path" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="d.cmis:objectTypeId">
          <cmis:value>Picture</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="nuxeo:parentId" displayName="Nuxeo Parent ID" localName="nuxeo:parentId" queryName="d.nuxeo:parentId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" localName="cmis:name" queryName="d.cmis:name">
          <cmis:value>Image1.jpg</cmis:value>
        </cmis:propertyString>
      </cmis:properties>
      <cmis:rendition>
        <cmis:streamId>nx:icon</cmis:streamId>
        <cmis:mimetype>image/gif</cmis:mimetype>
        <cmis:length>589</cmis:length>
        <cmis:kind>cmis:thumbnail</cmis:kind>
        <cmis:title>folder.gif</cmis:title>
        <cmis:height>16</cmis:height>
        <cmis:width>16</cmis:width>
      </cmis:rendition>
    </cmisra:object>
  </atom:entry>
  <atom:entry>
    <atom:author>
      <atom:name></atom:name>
    </atom:author>
    <atom:id>http://chemistry.apache.org/aWQtMw==</atom:id>
    <atom:published>2013-08-21T15:15:28.824+02:00</atom:published>
    <atom:title>Query Result id-3</atom:title>
    <app:edited>2013-08-21T15:15:28.824+02:00</app:edited>
    <atom:updated>2013-08-21T15:15:28.824+02:00</atom:updated>
    <cmisra:object>
      <cmis:properties>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="d.cmis:objectId">
          <cmis:value>776b8920-88e9-474a-9796-182c537a934d</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="nuxeo:contentStreamDigest" displayName="Content Stream Digest" localName="nuxeo:contentStreamDigest" queryName="d.nuxeo:contentStreamDigest" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="f.cmis:objectTypeId">
          <cmis:value>Folder</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="f.cmis:objectId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:path" displayName="Path" localName="cmis:path" queryName="f.cmis:path" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="d.cmis:objectTypeId">
          <cmis:value>File</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="nuxeo:parentId" displayName="Nuxeo Parent ID" localName="nuxeo:parentId" queryName="d.nuxeo:parentId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" localName="cmis:name" queryName="d.cmis:name">
          <cmis:value>project_report.xls</cmis:value>
        </cmis:propertyString>
      </cmis:properties>
      <cmis:rendition>
        <cmis:streamId>nx:icon</cmis:streamId>
        <cmis:mimetype>image/gif</cmis:mimetype>
        <cmis:length>589</cmis:length>
        <cmis:kind>cmis:thumbnail</cmis:kind>
        <cmis:title>folder.gif</cmis:title>
        <cmis:height>16</cmis:height>
        <cmis:width>16</cmis:width>
      </cmis:rendition>
    </cmisra:object>
  </atom:entry>
  <atom:entry>
    <atom:author>
      <atom:name></atom:name>
    </atom:author>
    <atom:id>http://chemistry.apache.org/aWQtNA==</atom:id>
    <atom:published>2013-08-21T15:15:28.824+02:00</atom:published>
    <atom:title>Query Result id-4</atom:title>
    <app:edited>2013-08-21T15:15:28.824+02:00</app:edited>
    <atom:updated>2013-08-21T15:15:28.824+02:00</atom:updated>
    <cmisra:object>
      <cmis:properties>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="d.cmis:objectId">
          <cmis:value>df1e6b73-6173-4ec0-b861-e86c7961ff31</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="nuxeo:contentStreamDigest" displayName="Content Stream Digest" localName="nuxeo:contentStreamDigest" queryName="d.nuxeo:contentStreamDigest" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="f.cmis:objectTypeId">
          <cmis:value>Folder</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="f.cmis:objectId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:path" displayName="Path" localName="cmis:path" queryName="f.cmis:path" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="d.cmis:objectTypeId">
          <cmis:value>File</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="nuxeo:parentId" displayName="Nuxeo Parent ID" localName="nuxeo:parentId" queryName="d.nuxeo:parentId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" localName="cmis:name" queryName="d.cmis:name">
          <cmis:value>Java_softwarePlatform.doc</cmis:value>
        </cmis:propertyString>
      </cmis:properties>
      <cmis:rendition>
        <cmis:streamId>nx:icon</cmis:streamId>
        <cmis:mimetype>image/gif</cmis:mimetype>
        <cmis:length>589</cmis:length>
        <cmis:kind>cmis:thumbnail</cmis:kind>
        <cmis:title>folder.gif</cmis:title>
        <cmis:height>16</cmis:height>
        <cmis:width>16</cmis:width>
      </cmis:rendition>
    </cmisra:object>
  </atom:entry>
  <atom:entry>
    <atom:author>
      <atom:name></atom:name>
    </atom:author>
    <atom:id>http://chemistry.apache.org/aWQtNQ==</atom:id>
    <atom:published>2013-08-21T15:15:28.824+02:00</atom:published>
    <atom:title>Query Result id-5</atom:title>
    <app:edited>2013-08-21T15:15:28.824+02:00</app:edited>
    <atom:updated>2013-08-21T15:15:28.824+02:00</atom:updated>
    <cmisra:object>
      <cmis:properties>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="d.cmis:objectId">
          <cmis:value>2e527cd8-ecec-4122-9b5a-5ddc7955f4bd</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="nuxeo:contentStreamDigest" displayName="Content Stream Digest" localName="nuxeo:contentStreamDigest" queryName="d.nuxeo:contentStreamDigest" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="f.cmis:objectTypeId">
          <cmis:value>Folder</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="cmis:objectId" displayName="Object ID" localName="cmis:objectId" queryName="f.cmis:objectId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:path" displayName="Path" localName="cmis:path" queryName="f.cmis:path" />
        <cmis:propertyId propertyDefinitionId="cmis:objectTypeId" displayName="Type ID" localName="cmis:objectTypeId" queryName="d.cmis:objectTypeId">
          <cmis:value>File</cmis:value>
        </cmis:propertyId>
        <cmis:propertyId propertyDefinitionId="nuxeo:parentId" displayName="Nuxeo Parent ID" localName="nuxeo:parentId" queryName="d.nuxeo:parentId">
          <cmis:value>a4f296b4-d4bc-4321-8207-dad4a28c8bd6</cmis:value>
        </cmis:propertyId>
        <cmis:propertyString propertyDefinitionId="cmis:name" displayName="Name" localName="cmis:name" queryName="d.cmis:name">
          <cmis:value>Nuxeo_BootCampProgram.odt</cmis:value>
        </cmis:propertyString>
      </cmis:properties>
      <cmis:rendition>
        <cmis:streamId>nx:icon</cmis:streamId>
        <cmis:mimetype>image/gif</cmis:mimetype>
        <cmis:length>589</cmis:length>
        <cmis:kind>cmis:thumbnail</cmis:kind>
        <cmis:title>folder.gif</cmis:title>
        <cmis:height>16</cmis:height>
        <cmis:width>16</cmis:width>
      </cmis:rendition>
    </cmisra:object>
  </atom:entry>
</atom:feed>
rg1
Member (2.1K)   3   4   7 		08/21/2013 ( History)
0 votes
0 answers
2575 views
ANSWER
Florent Guillaume
It must be a Nuxeo bug. Could you please open a NXP ticket for it?
08/23/2013
rg1
NXP-12312 opened for this issue. Thanks for the prompt reply.
08/23/2013
Follow
Tags
Linked Questions
Related Questions
CMIS Browser Binding NavigationService getObjectParents/getFolderParent fail on latest 5.6.0 branch
CmisConnectionException 'canCreatePolicy.Folder' not a valid value for enumAllowableActionsKey
CMIS Query with a "null predicate" containing a "multi-valued-column reference" throws exception
Document creation handler succeeds from UI but fails from CMIS document creation
Performance of CMIS Folder.getChildren()
Illegal path..when using Ephesoft and Nuxeo
Preview can not be generated for this document?
Internal servlet error while creating a Relationship using CMIS
access problem switching from H2 to Oracle database