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

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 © 2024 Khoros, LLC