Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

CMIS JOIN Query result set properties not being populated

rg1_
Star Contributor
Star Contributor

‎08-21-2013 11:39 AM

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>
0 Kudos
2 REPLIES 2

Florent_Guillau
World-Class Innovator
World-Class Innovator

‎08-23-2013 10:58 AM

It must be a Nuxeo bug. Could you please open a NXP ticket for it?

0 Kudos

rg1_
Star Contributor
Star Contributor

‎08-23-2013 11:03 AM

[NXP-12312][1] opened for this issue. Thanks for the prompt reply.

0 Kudos
Getting started

Attention: Blogs & Forums are in READ-ONLY mode from Oct 9-19 as we transition to our new platform. Learn more.

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2026 Khoros, LLC