topic Re: How to get how many folders and sub folders are present in a site ? in Alfresco Forum

How to get how many folders and sub folders are present in a site ?

raju_gonda — Thu, 25 Jul 2019 06:48:26 GMT

can anyone help me in this..

Re: How to get how many folders and sub folders are present in a site ?

yash_patel_c2 — Thu, 25 Jul 2019 08:00:40 GMT

Hi,

You can use lucene search for searching all the content of type cm:folder for that particular site and then just get the length of the result.

var result = lucene.search("-----Your Query----");

var a = result.length;

Thanks,

Yash

Re: How to get how many folders and sub folders are present in a site ?

kintu_barot — Thu, 25 Jul 2019 08:40:50 GMT

You can use the following javascript code and execute it in a recursive way.

var site = companyhome.childByNamePath("Sites/<site-name>/documentLibrary");
var count = site.children.length;

The above code will give you the number of children present in documentLibrary.

You can use the same to get the subfolders.

Regards,

Kintu

ContCentric

Re: How to get how many folders and sub folders are present in a site ?

raju_gonda — Thu, 25 Jul 2019 08:54:16 GMT

I don't know javascript, can you pls give me the code with recursive logic and also give me the URL pattern for this

Re: How to get how many folders and sub folders are present in a site ?

raju_gonda — Thu, 25 Jul 2019 10:08:36 GMT

Hi Yash..!!

I have no idea about lucene search can tell me the alternate way for getting folders and sub folders

Re: How to get how many folders and sub folders are present in a site ?

kintu_barot — Thu, 25 Jul 2019 11:17:42 GMT

Use the following code:

var site = companyhome.childByNamePath("Sites/test/documentLibrary");
var children = site.children;
var numberOfChildren = site.children.length;
var count = 0;
for (var index = 0; index < numberOfChildren; index++) {
      if(children[index].isContainer){
          c = children[index].children.length;
          count = count + c + 1;
      } else {
          //uncomment following line if you want to count the document as well
          //count = count +1;
      }
}
logger.log(count);

I hope you know where to use it.

Note: replace the 'test' with your site name.

Regards,

Kintu

ContCentric

Re: How to get how many folders and sub folders are present in a site ?

raju_gonda — Thu, 25 Jul 2019 12:32:11 GMT

It is giving wrong count

Can you once check?

Re: How to get how many folders and sub folders are present in a site ?

kintu_barot — Thu, 25 Jul 2019 12:46:50 GMT

It counts 'documentLibrary' folder as well.

And it is for two levels only, you can use it recursively.

Regards,

Kintu

ContCentric

Re: How to get how many folders and sub folders are present in a site ?

raju_gonda — Fri, 26 Jul 2019 10:43:38 GMT

Hi Kintu Barot,

Thanks for your answer.

if we don't know the how many levels in a particular site, how can we write recursive logic..?

Re: How to get how many folders and sub folders are present in a site ?

abhinavmishra14 — Fri, 26 Jul 2019 13:06:40 GMT

Re: How to get how many folders and sub folders are present in a site ?

afaust — Tue, 30 Jul 2019 05:47:06 GMT

Please, never recommend using the luceneSearch operation. That operation is a legacy holdover from Alfresco 2.x/3.x. Lucene is no longer the primary search language, and since Alfresco 4.x has not received any of the various performance improvements that have been accorded to FTS / CMIS. Ideally, only ever use the generic query() operation and specifically use the "fts-alfresco" or "cmis-strict"/"cmis-alfresco" query languages.

Re: How to get how many folders and sub folders are present in a site ?

yash_patel_c2 — Tue, 30 Jul 2019 05:50:43 GMT

Thanks for the clarification!