<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic CONTAINS clause in CMIS Query in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/contains-clause-in-cmis-query/m-p/278665#M231795</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm trying to use CONTAINS clause in A CMIS Query to make a fulltext search (I want to get all documents containing a specific word).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm working on Alfresco 4.0d.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Here is the code of my CMIS client (I'm using OpenCMIS client 0.6.0) :&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;List&amp;lt;Document&amp;gt; documentList = new ArrayList&amp;lt;Document&amp;gt;();&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;BR /&gt;// build query&lt;BR /&gt;ObjectType type = session.getTypeDefinition(BaseTypeId.CMIS_DOCUMENT.value());&lt;BR /&gt;PropertyDefinition&amp;lt;?&amp;gt; objectIdPropDef = type.getPropertyDefinitions().get(PropertyIds.OBJECT_ID);&lt;BR /&gt;String ObjectIdQueryName = objectIdPropDef.getQueryName();&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;BR /&gt;String queryString = MessageFormat.format(QUERY_SEARCH_DOCUMENTS, ObjectIdQueryName, type.getQueryName(), term);&lt;BR /&gt;System.out.println("Query : "+queryString);&lt;BR /&gt;&lt;BR /&gt;// execute query&lt;BR /&gt;ItemIterable&amp;lt;QueryResult&amp;gt; results = session.query(queryString, false);&lt;BR /&gt;for (QueryResult qResult : results) {&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;String objectId = qResult.getPropertyValueByQueryName(ObjectIdQueryName);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;System.out.println("objectId : "+objectId);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;Document document = (Document)session.getObject(objectId);&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;documentList.add(document);&lt;BR /&gt;}&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm getting the following errors :&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;Searching documents containing 'test'…&lt;BR /&gt;Query : SELECT * FROM cmis:document WHERE CONTAINS('test')&lt;BR /&gt;Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisConnectionException: Parsing exception!&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.parse(AbstractAtomPubService.java:531)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:147)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:557)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(CollectionIterator.java:48)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at fr.virage.service.impl.CMISRemoteServiceImpl.searchDocuments(CMISRemoteServiceImpl.java:110)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at fr.virage.Main.searchDocuments(Main.java:52)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at fr.virage.Main.main(Main.java:40)&lt;BR /&gt;Caused by: com.ctc.wstx.exc.WstxParsingException: Unrecognized XML directive; expected CDATA or comment ('&amp;lt;![CDATA[' or '&amp;lt;!–').&lt;BR /&gt; at [row,col {unknown-source}]: [89,17]&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ctc.wstx.sr.StreamScanner.constructWfcException(StreamScanner.java:605)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:461)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ctc.wstx.sr.BasicStreamReader.nextFromTreeCommentOrCData(BasicStreamReader.java:3285)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2822)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1019)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.next(AtomPubParser.java:650)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.skip(AtomPubParser.java:633)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parseElement(AtomPubParser.java:380)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parseEntry(AtomPubParser.java:295)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parseFeed(AtomPubParser.java:256)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parse(AtomPubParser.java:120)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.parse(AbstractAtomPubService.java:529)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;… 7 more&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I've tried different queries and got different errors.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Which syntax should I use ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Do I have to use Alfresco CMIS extension to use CONTAINS clause ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thx in advance for your help.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 14 Feb 2013 18:18:10 GMT</pubDate>
    <dc:creator>mlagneaux</dc:creator>
    <dc:date>2013-02-14T18:18:10Z</dc:date>
    <item>
      <title>CONTAINS clause in CMIS Query</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/contains-clause-in-cmis-query/m-p/278665#M231795</link>
      <description>Hello,I'm trying to use CONTAINS clause in A CMIS Query to make a fulltext search (I want to get all documents containing a specific word).I'm working on Alfresco 4.0d.Here is the code of my CMIS client (I'm using OpenCMIS client 0.6.0) :List&amp;lt;Document&amp;gt; documentList = new ArrayList&amp;lt;Document&amp;amp;</description>
      <pubDate>Thu, 14 Feb 2013 18:18:10 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/contains-clause-in-cmis-query/m-p/278665#M231795</guid>
      <dc:creator>mlagneaux</dc:creator>
      <dc:date>2013-02-14T18:18:10Z</dc:date>
    </item>
    <item>
      <title>Re: CONTAINS clause in CMIS Query</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/contains-clause-in-cmis-query/m-p/278666#M231796</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Your code works on my machine running with OpenCMIS 0.6 against Alfresco 4.0d using the AtomPub binding and the following service URL: &lt;/SPAN&gt;&lt;A href="http://localhost:8080/alfresco/cmisatom" rel="nofollow noopener noreferrer"&gt;http://localhost:8080/alfresco/cmisatom&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;You do not need the extension to use the contains clause. Your code works on my machine both with and without the extension.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Jeff&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Feb 2013 23:11:00 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/contains-clause-in-cmis-query/m-p/278666#M231796</guid>
      <dc:creator>jpotts</dc:creator>
      <dc:date>2013-02-21T23:11:00Z</dc:date>
    </item>
  </channel>
</rss>

