topic CMIS Queries on Aspects in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-aspects/m-p/245530#M198660 <HTML><HEAD></HEAD><BODY><SPAN>I was in the understanding that the CMIS standard didnt support aspects/mixins yet. However, i found the following on the Alfresco Wiki:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">All capabilities of CMIS SQL are supported (except join between Types). The Alfresco FTS language may be embedded in the CMIS SQL contains() predicate.<BR /><BR />Alfresco Aspects may also be queried as if they were tables and joined to Types by ObjectId.<BR /><BR />SELECT D.*, O.* FROM DOCUMENT AS D JOIN CM_OWNABLE AS O ON (D.ObjectId = O.ObjectId)</BLOCKQUOTE><SPAN>(</SPAN><A href="http://wiki.alfresco.com/wiki/CMIS" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/CMIS</A><SPAN>)</SPAN><BR /><BR /><SPAN>When i try this statement i get the error message "Joins are not supported", while in the Wiki text is stated that only joins between types are not supported.</SPAN><BR /><BR /><SPAN>What is the current state of aspects in the Alfresco CMIS implementation?</SPAN><BR /><BR /><SPAN>Kindest regards,</SPAN><BR /><BR /><SPAN>Koen Bonnet</SPAN></BODY></HTML> Tue, 28 Jul 2009 20:41:52 GMT kbonnet 2009-07-28T20:41:52Z CMIS Queries on Aspects https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-aspects/m-p/245530#M198660 I was in the understanding that the CMIS standard didnt support aspects/mixins yet. However, i found the following on the Alfresco Wiki:All capabilities of CMIS SQL are supported (except join between Types). The Alfresco FTS language may be embedded in the CMIS SQL contains() predicate.Alfresco Aspe Tue, 28 Jul 2009 20:41:52 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-aspects/m-p/245530#M198660 kbonnet 2009-07-28T20:41:52Z Re: CMIS Queries on Aspects https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-aspects/m-p/245531#M198661 <HTML><HEAD></HEAD><BODY><SPAN>Anyone??</SPAN></BODY></HTML> Mon, 24 Aug 2009 12:43:23 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-aspects/m-p/245531#M198661 kbonnet 2009-08-24T12:43:23Z Re: CMIS Queries on Aspects https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-aspects/m-p/245532#M198662 <HTML><HEAD></HEAD><BODY><SPAN>I have the same issue. Is this supported or not?</SPAN></BODY></HTML> Tue, 27 Oct 2009 14:35:20 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-aspects/m-p/245532#M198662 nicolasl 2009-10-27T14:35:20Z