topic How to make a CMIS query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207862#M160992 <HTML><HEAD></HEAD><BODY><SPAN>I a making a post for those who search to make a CMIS query because i've had a lot of trouble to find this info.</SPAN><BR /><BR /><SPAN>- First you need to make the files tha will be used by alfresco :</SPAN><BR /><SPAN>Three file : </SPAN><BR /><SPAN>- index.get.desc.xml :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;webscript&gt;<BR />&nbsp; &lt;shortname&gt;Test&lt;/shortname&gt;<BR />&nbsp; &lt;description&gt;a webscript To test CMIS query&lt;/description&gt;&nbsp; <BR />&nbsp; &lt;url&gt;/searchTest&lt;/url&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;authentication&gt;guest&lt;/authentication&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;transaction&gt;required&lt;/transaction&gt;&nbsp;&nbsp;&nbsp;<BR />&lt;/webscript&gt;<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></CODE></PRE><SPAN>In url you can put the name of the url you wish to use</SPAN><BR /><SPAN>- index.get.xml.ftl</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;#import "/org/alfresco/webscripts.lib.html.ftl" as wsLib/&gt;<BR />&lt;#import "/org/alfresco/cmis/atomentry.lib.atom.ftl" as entryLib/&gt;<BR />&lt;classes xmlns:cmis="<A href="http://www.cmis.org/2008/05" rel="nofollow noopener noreferrer">http://www.cmis.org/2008/05</A>" xmlns:alf="<A href="http://www.alfresco.com" rel="nofollow noopener noreferrer">http://www.alfresco.com</A>"&gt;<BR /> &lt;#assign rs = cmisresultset(resultset)&gt;<BR />&lt;#list rs.rows as row&gt;<BR />&lt;@entryLib.row row/&gt;<BR />&lt;/#list&gt;<BR />&lt;/classes&gt;<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></CODE></PRE><SPAN>- index.get.js</SPAN><BR /><SPAN>In the &lt;cmis:statement&gt; you have the request you can personalise it. Here you hav a request to get all documents that are not made by alfresco (System) and those who are not generated by Share ( "webpreview.swf" and "doclib.png")</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />script: {<BR />model.resultset = nodes;<BR />default xml namespace = '<A href="http://www.cmis.org/2008/05" rel="nofollow noopener noreferrer">http://www.cmis.org/2008/05</A>';<BR /><BR />var query="&lt;cmis:query xmlns:cmis='<A href="http://www.cmis.org/2008/05" rel="nofollow noopener noreferrer">http://www.cmis.org/2008/05</A>' &nbsp;&nbsp;&nbsp;xmlns:p='<A href="http://www.w3.org/1999/xhtml" rel="nofollow noopener noreferrer">http://www.w3.org/1999/xhtml</A>' &nbsp;&nbsp;&nbsp;xmlns:xsi='<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>' &nbsp;&nbsp;&nbsp;xsi:schemaLocation='<A href="http://www.cmis.org/2008/05" rel="nofollow noopener noreferrer">http://www.cmis.org/2008/05</A> CMIS.xsd '&gt;&nbsp; &lt;cmis:statement&gt;SELECT * FROM DOCUMENT&nbsp; WHERE NOT((CreatedBy = 'System') OR (Name = 'doclib.png') OR (Name = 'webpreview.swf')) &lt;/cmis:statement&gt;&nbsp; &lt;cmis:searchAllVersions&gt;false&lt;/cmis:searchAllVersions&gt;&nbsp; &lt;cmis:pageSize&gt;0&lt;/cmis:pageSize&gt;&nbsp; &lt;cmis:skipCount&gt;0&lt;/cmis:skipCount&gt;&nbsp; &lt;cmis:returnAllowableActions&gt;false&lt;/cmis:returnAllowableActions&gt;&lt;/cmis:query&gt;";<BR />var cmisQuery = new XML(query);<BR /><BR />&nbsp;&nbsp;&nbsp; // extract query statement<BR />&nbsp;&nbsp;&nbsp; model.statement = cmisQuery.statement.toString();<BR />&nbsp;&nbsp;&nbsp; if (model.statement == null || model.statement.length == 0)<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //status.setCode(status.STATUS_BAD_REQUEST, "Query statement must be provided");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break script;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // process search all versions (NOTE: not supported)<BR />&nbsp;&nbsp;&nbsp; var searchAllVersions = cmisQuery.searchAllVersions;<BR />&nbsp;&nbsp;&nbsp; if (searchAllVersions != null &amp;&amp; searchAllVersions === "true")<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //status.setCode(status.STATUS_INTERNAL_SERVER_ERROR, "Search all versions not supported");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break script;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // TODO: process allowableActions<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // process paging<BR />&nbsp;&nbsp;&nbsp; var skipCount = parseInt(cmisQuery.skipCount);<BR />&nbsp;&nbsp;&nbsp; var pageSize = parseInt(cmisQuery.pageSize);<BR />&nbsp;&nbsp;&nbsp; var page = paging.createPageOrWindow(null, null, isNaN(skipCount) ? null : skipCount, isNaN(pageSize) ? null : pageSize);<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; // perform query<BR />&nbsp;&nbsp;&nbsp; var paged = cmis.query(model.statement, page);<BR />&nbsp;&nbsp;&nbsp; model.resultset = paged.result;<BR />&nbsp;&nbsp;&nbsp; model.cursor = paged.cursor;<BR />&nbsp;&nbsp;&nbsp; <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>‍</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 /><SPAN>When the files are created then put them in "my alfresco"\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\webscripts\com\{a name as you wish}\</SPAN><BR /><SPAN>and refresh alfresco webscript.</SPAN><BR /><BR /><SPAN>Then if you go to : </SPAN><A href="http://{my" rel="nofollow noopener noreferrer">http://{my</A><SPAN> alfresco}:8080/alfresco/service/{url choosed in index.get.desc.xml }.xml you will have the result of you CMIS request.</SPAN></BODY></HTML> Mon, 06 Apr 2009 14:51:41 GMT pbertrand 2009-04-06T14:51:41Z How to make a CMIS query https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207862#M160992 I a making a post for those who search to make a CMIS query because i've had a lot of trouble to find this info.- First you need to make the files tha will be used by alfresco :Three file : - index.get.desc.xml :&lt;webscript&gt;&nbsp; &lt;shortname&gt;Test&lt;/shortname&gt;&nbsp; &lt;description&gt;a webscri Mon, 06 Apr 2009 14:51:41 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207862#M160992 pbertrand 2009-04-06T14:51:41Z Re: How to make a CMIS query https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207863#M160993 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><SPAN>I want to execute CMIS query in java. How can I do that, what could be the uri format ?</SPAN><BR /><SPAN>Please suggest something.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Pankaj</SPAN></BODY></HTML> Wed, 24 Mar 2010 05:04:07 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207863#M160993 pankajmi 2010-03-24T05:04:07Z Re: How to make a CMIS query https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207864#M160994 <HTML><HEAD></HEAD><BODY><SPAN>Hi pankajmi,</SPAN><BR /><BR /><SPAN>Do you know something about how to execute CMIS query in java?</SPAN><BR /><SPAN>Thanks a lot of</SPAN></BODY></HTML> Wed, 13 Jul 2011 10:35:43 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207864#M160994 albertogp 2011-07-13T10:35:43Z Re: How to make a CMIS query https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207865#M160995 <HTML><HEAD></HEAD><BODY><SPAN>I suggest you look at the Apache Chemistry project.&nbsp; That will hide all the detail of CMIS and give you a higer level Java or .Net API.</SPAN></BODY></HTML> Wed, 13 Jul 2011 10:38:53 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-make-a-cmis-query/m-p/207865#M160995 mrogers 2011-07-13T10:38:53Z