CMIS JOIN Query result set properties not being populated

rg1_ — Wed, 21 Aug 2013 15:39:58 GMT

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>

Re: CMIS JOIN Query result set properties not being populated

Florent_Guillau — Fri, 23 Aug 2013 14:58:37 GMT

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

Re: CMIS JOIN Query result set properties not being populated

rg1_ — Fri, 23 Aug 2013 15:03:57 GMT

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

topic CMIS JOIN Query result set properties not being populated in Nuxeo Forum

CMIS JOIN Query result set properties not being populated

Re: CMIS JOIN Query result set properties not being populated

Re: CMIS JOIN Query result set properties not being populated