AnsweredAssumed Answered

CMIS Query Language - Outer joins

Question asked by iv0id on Jun 18, 2014
Latest reply on Jun 19, 2014 by iv0id

I'm trying to execute this query using CMIS but apparently it's not possible to perform outer joins in CMIS QL.(Alfresco 4.0.e & CMIS 1.0 )
Query :

SELECT * FROM cmis:document d LEFT join cm:titled t on d.cmis:objectId = t.cmis:objectId

i get the exception :

org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: Outer joins are not supported
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(
   at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(
   at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(
   at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(
   at com.sqli.sante.ged.alfresco.document.service.AlfrescoDocumentServiceImpl.main(

is there a configuration to make or the outer joins are not supported?

Thank you.