topic CMIS contains for folders? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-contains-for-folders/m-p/310575#M263705 <HTML><HEAD></HEAD><BODY><SPAN>I can't seem to return any results with the following query (testing through Workbench) :</SPAN><BR /><PRE class="language-none line-numbers"><CODE>SELECT * FROM cmis:folder where CONTAINS('Contracts')<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>That should return at least one folder - including the sample app folders.&nbsp; My intent is to search any indexed properties of cm:folder, of course.</SPAN><BR /><BR /><SPAN>This query returns one of the sample folders:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>SELECT * FROM cmis:folder where cmis:name like '%Contracts%'<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>So why doesn't the CONTAINS clause work for folders???&nbsp; It works fine for documents.&nbsp; I have tried various searches, but using CONTAINS with cmis:folder never returns any results.</SPAN><BR /><BR /><SPAN>Thanks for any insight.</SPAN><BR /><SPAN>-AJ</SPAN></BODY></HTML> Fri, 13 Nov 2015 14:40:27 GMT aweber1nj 2015-11-13T14:40:27Z CMIS contains for folders? https://connect.hyland.com/t5/alfresco-archive/cmis-contains-for-folders/m-p/310575#M263705 I can't seem to return any results with the following query (testing through Workbench) <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 * FROM cmis:folder where CONTAINS('Contracts')‍That should return at least one folder - including the sample app folders.&nbsp; My intent is to search any indexed properties of cm:folder, of course.This query Fri, 13 Nov 2015 14:40:27 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-contains-for-folders/m-p/310575#M263705 aweber1nj 2015-11-13T14:40:27Z Re: CMIS contains for folders? https://connect.hyland.com/t5/alfresco-archive/cmis-contains-for-folders/m-p/310576#M263706 <HTML><HEAD></HEAD><BODY><SPAN>The contains() predicate encapsulates the full-text capability of a CMIS repository. Individual folder objects don't have any content to full-text index which is why contains does not work on folders.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Mon, 16 Nov 2015 22:43:27 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-contains-for-folders/m-p/310576#M263706 jpotts 2015-11-16T22:43:27Z