topic Re: How to use CONTAINS on metadata ? in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/how-to-use-contains-on-metadata/m-p/23925#M10412 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>CMIS&nbsp; CONTAINS() by default matches only content.</P><P>If you are using the public API it is possible to change this default.</P><P>There is an example <A _jive_internal="true" href="https://community.alfresco.com/people/andy1/blog/2017/06/28/query-templates-in-share-and-the-public-api#jive_content_id_Search_public_API" rel="nofollow noopener noreferrer">here</A>.</P><P></P><P>You can specify the field in the query. Beware, the CMIS specification is quite limited but we support any Alfresco full text search expression in CONTAINS() - the CMIS specification is a sub-set that assumes you mean content.</P><P></P><P>SELECT * FROM my:medatas WHERE CONTAINS('my:type=TYPE1')</P><P></P><P>Andy</P></BODY></HTML> Thu, 07 Sep 2017 09:29:49 GMT andy1 2017-09-07T09:29:49Z How to use CONTAINS on metadata ? https://connect.hyland.com/t5/alfresco-forum/how-to-use-contains-on-metadata/m-p/23924#M10411 Hello,I try to use the function CONTAINS in my query but I can not to get my documents with it.SELECT * FROM my:medatas WHERE my:type='TYPE1'works fine. While the query <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 my:medatas m WHERE CONTAINS(m, 'TYPE1')works (no exceptions) but I have not any documents.I want to use this functio Wed, 30 Aug 2017 13:02:06 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-use-contains-on-metadata/m-p/23924#M10411 berguiz 2017-08-30T13:02:06Z Re: How to use CONTAINS on metadata ? https://connect.hyland.com/t5/alfresco-forum/how-to-use-contains-on-metadata/m-p/23925#M10412 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>CMIS&nbsp; CONTAINS() by default matches only content.</P><P>If you are using the public API it is possible to change this default.</P><P>There is an example <A _jive_internal="true" href="https://community.alfresco.com/people/andy1/blog/2017/06/28/query-templates-in-share-and-the-public-api#jive_content_id_Search_public_API" rel="nofollow noopener noreferrer">here</A>.</P><P></P><P>You can specify the field in the query. Beware, the CMIS specification is quite limited but we support any Alfresco full text search expression in CONTAINS() - the CMIS specification is a sub-set that assumes you mean content.</P><P></P><P>SELECT * FROM my:medatas WHERE CONTAINS('my:type=TYPE1')</P><P></P><P>Andy</P></BODY></HTML> Thu, 07 Sep 2017 09:29:49 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-use-contains-on-metadata/m-p/23925#M10412 andy1 2017-09-07T09:29:49Z