topic Re: How to count documents in each sites in Alfresco Archive

How to count documents in each sites

janaka1984 — Fri, 14 Oct 2016 12:12:29 GMT

Hi,i have used search.luceneSearch("TYPE:\"cm:content\" AND PATH:\"//app:company_home/st:sites//*\" "); . but it returned total documents of sites.i need to filter documents count per each sites and also need to filter it according to dates.please give me hintsRegardsjanaka

Re: How to count documents in each sites

angelborroy — Fri, 14 Oct 2016 12:21:41 GMT

You can try with http://localhost:8080/alfresco/s/api/solrstats/site/{site-id} but it does not allow to filter according dates

Re: How to count documents in each sites

kaynezhang — Fri, 14 Oct 2016 13:12:49 GMT

I don't think you will get what you need just by query statements

Webscript api/solrstats/ can only collect statistics under a site( by the way this webscript allow to filter according startDate and endDate parameter).

I think you need do some custom development using solr-fts-alfresco language and SolrStatsService.

Re: How to count documents in each sites

douglascrp — Thu, 20 Oct 2016 14:40:55 GMT

Angel Borroy I didn't know this webservice.

It seems to be really useful.

Thank you for sharing it.

Re: How to count documents in each sites

janaka1984 — Fri, 21 Oct 2016 04:58:27 GMT

hi,

i used following url. but it does only return documents in repository (out side of folder). how can read all documents in all site's document library at once?

AlfConstants.PROXY_URI +"slingshot/doclib/doclist/documents/node/alfresco/company/home";

Best Regards

Janaka

Re: How to count documents in each sites

kaynezhang — Fri, 21 Oct 2016 08:41:38 GMT

try http://localhost:8080/alfresco/s/slingshot/doclib/doclist/documents/node/alfresco/sites/home

Re: How to count documents in each sites

janaka1984 — Fri, 21 Oct 2016 09:13:55 GMT

it does return as follow. but i couldn't see any details of document. this url is same as i provided in upper comment

{

"totalRecords": 13,

"startIndex": 0,

"metadata":

{

"repositoryId": "b6170285-f0d5-4c43-a9df-74ea45d06696",

"container": "workspace://SpacesStore/c7070144-e864-4443-bf25-3179d6385886",

"parent":

{

"nodeRef": "workspace://SpacesStore/c7070144-e864-4443-bf25-3179d6385886",

"permissions":

{

"userAccess":

{

"create": true,

"edit": true,

"delete": true,

"cancel-checkout": false,

"permissions": true

}

"onlineEditing": false,

"itemCounts":

{

"folders": 0,

"documents": 0

}

"items":

[

]

}

Re: How to count documents in each sites

kaynezhang — Fri, 21 Oct 2016 09:51:29 GMT

try to add filter =all parameter

http://localhost:8080/alfresco/s/slingshot/doclib/doclist/documents/node/alfresco/sites/home?filter=all

Re: How to count documents in each sites

janaka1984 — Fri, 21 Oct 2016 11:09:22 GMT

thanks kayne zhang it is working