-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: 5.7.2
-
Fix Version/s: 5.8.0-HF04, 5.9.1
-
Component/s: CMIS
-
Tags:
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. See http://answers.nuxeo.com/questions/6440/cmis-join-query-result-set-properties-not-being-populated.
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
- is required by
-
NXP-12357 CMIS Query with multiple LEFT OUTER JOINs returns empty result set
- Resolved