Create a javascript of java backed webscript. Write search query that will take siteshortname and object type (your custom content type, custom folder type, cm:content, cm:folder etc.) and performs a search and returns the count.
There is a high level code which you can implement in your java backed webscript:
Query would be something like:
String countQuery = 'PATH:"/app:company_home/st:sites/cm:' + search.ISO9075Encode(siteShortName) + '//*" AND TYPE:"'+type+'"';
Where siteShortName and type you will pass for getting the related results.
You will below sample method to get the count and use it whereever you want:
long countResult = getObjectCount(countQuery);
public long getObjectCount(String query) {
SearchParameters searchParameters = new SearchParameters();
searchParameters.setQuery(query);
searchParameters.setLanguage(SearchService.LANGUAGE_LUCENE);
searchParameters.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);
searchParameters.setMaxItems(Integer.MAX_VALUE);
searchParameters.setMaxPermissionChecks(Integer.MAX_VALUE);
ResultSet results = null;
long objectCount = 0;
try {
results = searchService.query(searchParameters);
if (null != results) {
objectCount = results.getNumberFound();
}
} catch (AlfrescoRuntimeException alfException) {
LOGGER.error(alfException.getMessage(), alfException);
} finally {
if (results != null) {
results.close();
}
}
return objectCount;
}
For javascript you can refer below sample and customize as per your need:
<webscript>
<shortname>Count Files/folder</shortname>
<description>
Counts Objects of given type
Parameter name : {type}
Example : custom:contentType, cm:content, cm:folder etc.
Parameter name : {siteShortName}
Example : test-site
</description>
<url>/countObjects?type={type}&siteShortName={siteShortName}&skipCount={skipCount}&maxCount={maxCount}</url>
<format>any</format>
</webscript>
function main(){
var siteCount = [];
var type = args["type"];
var siteShortName = args["siteShortName"];
var skipCount = (args["skipCount"]==null || args["skipCount"]==undefined)?0:args["skipCount"];
var maxCount = (args["maxCount"]==null || args["maxCount"]==undefined)?100000:args["maxCount"];
var countQuery = 'PATH:"/app:company_home/st:sites/cm:' + search.ISO9075Encode(siteShortName) + '//*" AND TYPE:"'+type+'"';
logger.log("CountQuery: "+countQuery);
var page = {
skipCount : parseInt(skipCount),
maxItems : parseInt(maxCount)
};
var searchQuery = {
query : countQuery,
language : "lucene",
page : page
};
var nodes = search.query(searchQuery);
var nodeCount = nodes.length;
siteCount[siteShortName] = nodeCount;
model.siteCount=siteCount;
}
main();
<html>
<head>
<title>Count of a given type</title>
</head>
<body>
<h4>Count of the given objects</h4>
<b>Count Query:</b> <#if query??>${query}<#else>-</#if><br/>
<hr/>
<#if siteCount?is_hash_ex>
<table border="1">
<tr>
<th align="center">Site Short Name</th>
<th align="center">Count</th>
</tr>
<#assign keys = siteCount ?keys>
<#list keys as key>
<tr>
<td align="center">${key}</td>
<td align="center">${siteCount [key]}</td>
</tr>
</#list>
</table>
</#if>
</body>
</html>
~Abhinav
(ACSCE, AWS SAA, Azure Admin)
