topic CMIS Query and custom properties in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-query-and-custom-properties/m-p/188574#M141704 <HTML><HEAD></HEAD><BODY><SPAN>Hi everybody,</SPAN><BR /><BR /><SPAN>I have created a custom model, and now I'm trying to perform queries CMIS SQL to find custom contents.</SPAN><BR /><SPAN>This is the query I have performed:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />SELECT myModel_customProperty<BR />&nbsp;&nbsp;&nbsp;FROM myModel_customContentType<BR />&nbsp;&nbsp;&nbsp;WHERE (IN_TREE('myFolder'));<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>This query works, but now I want to find custom contents with the property in the where clause. These are</SPAN><BR /><SPAN>the queries that I performed, but both of them do not work:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />SELECT *<BR />&nbsp;&nbsp;&nbsp;FROM myModel_customContentType<BR />&nbsp;&nbsp;&nbsp;WHERE (IN_TREE('myFolder') AND (myModel_customProperty = 'x'));<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><PRE class="language-none line-numbers"><CODE><BR />SELECT *<BR />&nbsp;&nbsp;&nbsp;FROM myModel_customContentType<BR />&nbsp;&nbsp;&nbsp;WHERE (IN_TREE('myFolder') AND (myModel_customProperty LIKE 'x'));<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Can any one help me? I have not found so much information about CQL queries, just in CMIS standard.</SPAN><BR /><BR /><SPAN>Thanks in advance,</SPAN><BR /><SPAN>Jose.</SPAN></BODY></HTML> Mon, 02 Mar 2009 11:15:50 GMT josekdiz 2009-03-02T11:15:50Z CMIS Query and custom properties https://connect.hyland.com/t5/alfresco-archive/cmis-query-and-custom-properties/m-p/188574#M141704 Hi everybody,I have created a custom model, and now I'm trying to perform queries CMIS SQL to find custom contents.This is the query I have performed<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ELECT myModel_customProperty&nbsp;&nbsp;&nbsp;FROM myModel_customContentType&nbsp;&nbsp;&nbsp;WHERE (IN_TREE('myFolder'));‍‍‍‍‍This query works, but now I want to find custom cont Mon, 02 Mar 2009 11:15:50 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-and-custom-properties/m-p/188574#M141704 josekdiz 2009-03-02T11:15:50Z Re: CMIS Query and custom properties https://connect.hyland.com/t5/alfresco-archive/cmis-query-and-custom-properties/m-p/188575#M141705 <HTML><HEAD></HEAD><BODY><SPAN>Now Alfresco CMIS implementation support CMIS Query on Custom Content Type only on the HEAD trunk of Alfresco source code (Alfresco 3.2).</SPAN><BR /><SPAN>Have you tried to download the latest source code?</SPAN><BR /><BR /><SPAN>Hope this helps.</SPAN></BODY></HTML> Tue, 05 May 2009 09:29:05 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-and-custom-properties/m-p/188575#M141705 openpj 2009-05-05T09:29:05Z