cancel
Showing results for 
Search instead for 
Did you mean: 

Cmis LEFT JOIN Query Nuxeo 5.9.2

Rafael_Bueno
Confirmed Champ
Confirmed Champ

Scenario:

1 - Create two Files.

2 - Create a Note.

3 - Create a Relation using File and Note.

4 - Want Return all files in a LEFT JOIN Query with Notes.

SELECT F.* FROM File F 
LEFT JOIN Relation R ON R.cmis:sourceId = F.cmis:objectId

Expected:

All Files include the files that doent have Relation with Note.

Problem:

A message "connection: Parsing Exception!" appears on Workbench Cmis after execute the query.

Google Search:

I updated the Nuxeo because I saw on github that the new version solved the left join query.

https://github.com/nuxeo/nuxeo-chemistry/commits/master https://github.com/nuxeo/nuxeo-chemistry/commit/fe1cf363c21fa0a9f453fc286f388e723d110d14 https://github.com/nuxeo/nuxeo-chemistry/commit/9002dab1e30a88d00421de22f6a8530449fe8e13

2 REPLIES 2

Rafael_Bueno
Confirmed Champ
Confirmed Champ

Works on 5.9.3

Yes there have been LEFT JOIN fixes in [NXP-12357](https

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.