The beauty of web scripts is that you can override any part of a web script that you want or add new things, like new views to an existing web script. So I tried adding a JSON response template to the extensions folder in the same folder structure as the out of the box CMIS query web script but the override didn't work. I didn't drill into the reason why, but maybe it is the same problem you were seeing.In any case, in Alfresco 4 there is a new root object that can help you out here. The root object is called "cmis". So, I created an entirely new web script. What I'm showing you here below is quick and dirty. It could be beefed up significantly, but I'll let that be up to you.The descriptor (org/alfresco/example/cmisquery.get.desc.xml):<webscript>
<shortname>Example cmis query web script</shortname>
<description>
<![CDATA[
Executes a CMIS query statement against the contents of the Repository.
]]>
</description>
<url>/example/cmis/query?q={q}</url>
<args>
<arg>
<shortname>q</shortname>
<description>query statement to execute</description>
</arg>
</args>
<authentication>user</authentication>
</webscript>
The controller (org/alfresco/example/cmisquery.get.js):var query = args.q;
var cmisConnection = cmis.getConnection();
var cmisSession = cmisConnection.getSession();
var results = cmisSession.query(query, false);
model.query = query;
model.results = results.iterator();
The view (org/alfresco/example/cmisquery.get.json.ftl:{"query": "${query}",
"results": [
<#list results as res>
{"name":"${res.getPropertyValueByQueryName('cmis:name')}",
"id":"${res.getPropertyValueByQueryName('cmis:objectId')}"
}<#if res_has_next>,</#if>
</#list>
]
}
You can put these in your classpath under $TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/templates/extension or you can add them to the repository under Data Dictionary/Web Scripts Extensions.Either way, once you deploy and refresh the web scripts index, you can enter a URL like this:http://localhost:8080/alfresco/s/example/cmis/query?format=json&q=select%20cmis:name,cmis:objectId%2...
And you'll see a result like this:{"query": "select cmis:name,cmis:objectId from cmis:document where cmis:name ='testwhitepaper'",
"results": [
{"name":"testwhitepaper",
"id":"workspace://SpacesStore/9a007b6a-261a-4d6d-9e34-ded4430ba1ab;1.0"
},
{"name":"testwhitepaper",
"id":"workspace://SpacesStore/3356ff7d-4172-4bd5-a826-adfa541e6ad2;1.0"
}
]
}
Look at the original OOTB CMIS query web script for ideas on paging and other things you could do to beef this up.Hope that helps,Jeff
