topic Re: COUNT nodes in Alfresco Forum

COUNT nodes

nonets — Thu, 25 Apr 2019 09:19:38 GMT

We're launching queries like that: TYPE:"ts:FolderSet" and ANCESTOR:"workspace://StoreSpaces/234230..."We need to count how many nodes are matching above condition instead of getting a list of nodes.We're launching this query using /share TFS-Alfresco queries.Any ideas?

Re: COUNT nodes

afaust — Thu, 25 Apr 2019 10:51:24 GMT

Yeah. Since this type of query will have to use the SOLR index, simply use the "numberFound" attribute contained in the search response / result set. That gives you the total number of nodes matching that query (that the current user is allowed to see). You can always set the "maxItems" parameter for search to 1, so you don't get a lot of results back (can't set it to zero though).

Re: COUNT nodes

nonets — Thu, 02 May 2019 08:23:37 GMT

I don't quite figure out how to get this "numberFound" field.

I've tried something like that, but I don't see the number of nodes.

Re: COUNT nodes

afaust — Thu, 02 May 2019 08:29:44 GMT

You cannot from the Node Browser tool. You need to access the low-level ResultSet obtained by searching via the SearchService#query (Java) or Search#query (JavaScript) API operations. Alternatively, if you are looking for the whole number without permission checks (you are checking as admin after all), you can simply do a database query or check the SOLR index (schema browser) via its admin UI.