topic Recherche fulltext via CMIS in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/recherche-fulltext-via-cmis/m-p/193644#M146774 <HTML><HEAD></HEAD><BODY><SPAN>Bonjour,</SPAN><BR /><BR /><SPAN>Je voudrais faire une recherche fulltext via CMIS sur Alfresco 4.0d. J'ai fait des tests aujourd'hui sur une application Java qui utilise opencmis-client en version 0.6.0.</SPAN><BR /><SPAN>J'ai essayé de faire une requête CMIS avec la clause CONTAINS.</SPAN><BR /><BR /><SPAN>Voici mon code Java :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />List&lt;Document&gt; documentList = new ArrayList&lt;Document&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />// build query<BR />ObjectType type = session.getTypeDefinition(BaseTypeId.CMIS_DOCUMENT.value());<BR />PropertyDefinition&lt;?&gt; objectIdPropDef = type.getPropertyDefinitions().get(PropertyIds.OBJECT_ID);<BR />String ObjectIdQueryName = objectIdPropDef.getQueryName();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />String queryString = MessageFormat.format(QUERY_SEARCH_DOCUMENTS, ObjectIdQueryName, type.getQueryName(), term);<BR />System.out.println("Query : "+queryString);<BR /><BR />// execute query<BR />ItemIterable&lt;QueryResult&gt; results = session.query(queryString, false);<BR />for (QueryResult qResult : results) {<BR />&nbsp;&nbsp;&nbsp;String objectId = qResult.getPropertyValueByQueryName(ObjectIdQueryName);<BR />&nbsp;&nbsp;&nbsp;System.out.println("objectId : "+objectId);<BR />&nbsp;&nbsp;&nbsp;Document document = (Document)session.getObject(objectId);<BR />&nbsp;&nbsp;&nbsp;documentList.add(document);<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>J'obtiens l'erreur suivante :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />Searching documents containing 'test'…<BR />Query : SELECT * FROM cmis:document WHERE CONTAINS('test')<BR />Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisConnectionException: Parsing exception!<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.parse(AbstractAtomPubService.java:531)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:147)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:557)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(CollectionIterator.java:48)<BR />&nbsp;&nbsp;&nbsp;at fr.virage.service.impl.CMISRemoteServiceImpl.searchDocuments(CMISRemoteServiceImpl.java:110)<BR />&nbsp;&nbsp;&nbsp;at fr.virage.Main.searchDocuments(Main.java:52)<BR />&nbsp;&nbsp;&nbsp;at fr.virage.Main.main(Main.java:40)<BR />Caused by: com.ctc.wstx.exc.WstxParsingException: Unrecognized XML directive; expected CDATA or comment ('&lt;![CDATA[' or '&lt;!–').<BR /> at [row,col {unknown-source}]: [89,17]<BR />&nbsp;&nbsp;&nbsp;at com.ctc.wstx.sr.StreamScanner.constructWfcException(StreamScanner.java:605)<BR />&nbsp;&nbsp;&nbsp;at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:461)<BR />&nbsp;&nbsp;&nbsp;at com.ctc.wstx.sr.BasicStreamReader.nextFromTreeCommentOrCData(BasicStreamReader.java:3285)<BR />&nbsp;&nbsp;&nbsp;at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2822)<BR />&nbsp;&nbsp;&nbsp;at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1019)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.next(AtomPubParser.java:650)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.skip(AtomPubParser.java:633)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parseElement(AtomPubParser.java:380)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parseEntry(AtomPubParser.java:295)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parseFeed(AtomPubParser.java:256)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AtomPubParser.parse(AtomPubParser.java:120)<BR />&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.parse(AbstractAtomPubService.java:529)<BR />&nbsp;&nbsp;&nbsp;… 7 more<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>J'ai essayé également d'autres requêtes et obtenus différentes erreurs</SPAN><BR /><SPAN>SELECT cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId FROM cmis:document WHERE CONTAINS('test')</SPAN><BR /><SPAN>SELECT * FROM cmis:document WHERE CONTAINS('TEXT:"test"')</SPAN><BR /><SPAN>SELECT * FROM cmis:document D WHERE CONTAINS(D, 'test')</SPAN><BR /><SPAN>…</SPAN><BR /><BR /><SPAN>Quelle syntaxe faut-il utiliser ?</SPAN><BR /><SPAN>Faut-il utiliser l'extension CMIS d'Alfresco pour utiliser la clause CONTAINS ?</SPAN><BR /><SPAN>Y a-t-il un paramétrage à faire pour authoriser la recherche fulltext via CMIS ?</SPAN><BR /><SPAN>Y a-t-il une autre manière de procéder ?</SPAN><BR /><BR /><SPAN>Merci d'avance pour votre aide.</SPAN></BODY></HTML> Thu, 14 Feb 2013 18:23:17 GMT mlagneaux 2013-02-14T18:23:17Z Recherche fulltext via CMIS https://connect.hyland.com/t5/alfresco-archive/recherche-fulltext-via-cmis/m-p/193644#M146774 Bonjour,Je voudrais faire une recherche fulltext via CMIS sur Alfresco 4.0d. J'ai fait des tests aujourd'hui sur une application Java qui utilise opencmis-client en version 0.6.0.J'ai essayé de faire une requête CMIS avec la clause CONTAINS.Voici mon code Java :List&lt;Document&gt; documentList = ne Thu, 14 Feb 2013 18:23:17 GMT https://connect.hyland.com/t5/alfresco-archive/recherche-fulltext-via-cmis/m-p/193644#M146774 mlagneaux 2013-02-14T18:23:17Z Re: Recherche fulltext via CMIS https://connect.hyland.com/t5/alfresco-archive/recherche-fulltext-via-cmis/m-p/193645#M146775 <HTML><HEAD></HEAD><BODY><SPAN>Ce paragraphe vous aide-t-il ? </SPAN><BR /><A href="http://wiki.alfresco.com/wiki/Full_Text_Search_Query_Syntax#Embedded_in_CMIS_contains.28.29" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Full_Text_Search_Query_Syntax#Embedded_in_CMIS_contains.28.29</A><BR /><BR /><SPAN>Vous n'avez semble-t-il pas escapé les quotes, à minima. </SPAN></BODY></HTML> Fri, 22 Feb 2013 13:05:11 GMT https://connect.hyland.com/t5/alfresco-archive/recherche-fulltext-via-cmis/m-p/193645#M146775 rguinot 2013-02-22T13:05:11Z