topic CMIS Query Language - Outer joins in Alfresco Archive

CMIS Query Language - Outer joins

iv0id — Wed, 18 Jun 2014 13:16:23 GMT

Hi,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.cmisbjectId = t.cmisbjectId‍‍‍i get the exception : org.apache.chemistry.opencmis.co

Re: CMIS Query Language - Outer joins

mrogers — Wed, 18 Jun 2014 14:47:44 GMT

No JOIN are not yet supported. However cm:titled is an aspect (in CMIS speak a secondary type) so is an important case that does work on all versions of alfresco that support CMIS. With CMIS 1.1 it works out of the box. With the older versions alfresco provides a plugin to support aspects.

Re: CMIS Query Language - Outer joins

iv0id — Wed, 18 Jun 2014 15:15:48 GMT

Hi mrogers,

Yes, an inner join works perfectly with any aspect. Ex of a query that works :

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

But when i want to perform a left/right join it raises the exception.

Re: CMIS Query Language - Outer joins

kaynezhang — Wed, 18 Jun 2014 15:37:55 GMT

alfresco dose not support outer join

Re: CMIS Query Language - Outer joins

iv0id — Thu, 19 Jun 2014 07:32:06 GMT

I see. thank you for your time