topic Re: CMIS Query Property bounded in Aspect in Alfresco Archive

CMIS Query Property bounded in Aspect

stockbuyer — Thu, 19 Jul 2012 08:48:49 GMT

Hi all,I want to find a document that its description is "Testing", so I have created a query as belowtring queryStr = "SELECT * FROM cmis:document WHERE cmis:description LIKE 'Test%'";It will throw a CmisRunTimeException. I have already added the Aspect "cm:titled" to this document, any ideas?Bes

Re: CMIS Query Property bounded in Aspect

jpotts — Tue, 24 Jul 2012 14:57:05 GMT

Aspects are not supported by CMIS 1.0. To search for properties defined in an aspect in Alfresco, you must use a join. So to search the description field, the query would look like:

SELECT d.cmis:objectId FROM cmis:document as d join cm:titled as t on d.cmis:objectId = t.cmis:objectId  WHERE t.cm:description like '%Test%'‍

Jeff