topic List all folder, subfolders, & files via webscript in Alfresco Forum

List all folder, subfolders, & files via webscript

tlapinsk — Tue, 24 Oct 2017 17:01:23 GMT

Hey Alfresco Community, I've done a fair bit of research, but haven't been able to find the right answer. I am trying to create a webscript that will grab all folders, subfolders, and files in a JavaScript webscript (JSON response).Currently, my model looks like this:// search for folder within Alfr

Re: List all folder, subfolders, & files via webscript

kalpesh_c2 — Wed, 25 Oct 2017 07:08:41 GMT

Hi tlapinsk‌

You can use lucene search to get sub files and folders by path. Below is the sample code that you can use by replacing path as per your folder.

var folder = search.luceneSearch("+PATH:\"/app:company_home/cm:Test_x0020_Folder//*\" AND 
              (TYPE:\"cm:content\" OR TYPE:\"cm:folder\")");‍‍‍‍‍‍

Thanks,

Kalpesh

ContCentric

Re: List all folder, subfolders, & files via webscript

calvo — Wed, 25 Oct 2017 07:28:03 GMT

Hi,

In this link you can find a concept test to list folders contained in a given folder.

Maybe you can modify this code to adapt it to your requirements.

netic360: :: Alfresco. Crear webscript para listar carpetas

Regards,

clv

Re: List all folder, subfolders, & files via webscript

tlapinsk — Wed, 25 Oct 2017 16:10:10 GMT

Hi Kalpesh Patel‌ and calvo _‌

Thank you so much for the responses. I ended up creating a macro in Freemarker (per the advice of this stackoverflow response).

Here the the code that I am using the elicit a JSON response:

{"corporates" : [
     <@recurse_macro node=folder depth=0/>
     ]
}

<#macro recurse_macro node depth>
     <#list node.children?sort_by(["properties","name"]) as child>
          {
          "Name" : "${child.properties.name}",
          "URL" : "${child.url}",
          "serviceURL" : "${child.serviceUrl}",
          "shareURL" : "${child.shareUrl}",
          "ID" : "${child.id}",
          "Type" : "${child.typeShort}"
          },
          <#if child.isContainer>
          {
               <@recurse_macro node=child depth=depth+1/>
          }
          </#if>
     </#list>
</#macro>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I will be modifying it further to return more readable JSON and then using AJAX to call/parse the JSON from a second webscript.

If you have any tips on using AJAX to make calls between web scripts, please let me know!

Cheers.

Re: List all folder, subfolders, & files via webscript

andy1 — Thu, 26 Oct 2017 07:55:33 GMT

Using a query, as suggested, is a much better solution than walking the tree.

Someone is going to put lots of children in a folder and structure in the hierarchy and then what?

Regards

Andy

Re: List all folder, subfolders, & files via webscript

tlapinsk — Thu, 26 Oct 2017 16:43:59 GMT

That is a great point. Even if it recursively walks the tree, it'll become slow and bloated over time.

I've implemented the lucene query as suggested, but having trouble displaying the returned content in an organized fashion. Ideally I would like it to look generally like this:

Folder 1

Subfolder
- doc 1
- doc 2
- doc 3
doc 1
doc 2
doc 3

Folder 2

Subfolder 1
- doc 1
- doc 2
Subfolder2
- doc 1
- doc 2
doc 1
doc 2
doc 3

Folder 3

Subfolder 1
- doc 1
doc 1
doc 2

‌ do you have any tips for organizing it in this fashion?

Re: List all folder, subfolders, & files via webscript

emerald911 — Tue, 03 Apr 2018 14:39:42 GMT

tlapinsk‌,hi did you solve trouble related with displaying the returned content in an organized fashion?

Re: List all folder, subfolders, & files via webscript

tlapinsk — Tue, 03 Apr 2018 22:24:35 GMT

‌ thanks for following up. I was able to get all of the content returned and organized. I ended up using two web scripts to achieve the results we wanted. One to hold content and another to make AJAX calls to grab the content.

Re: List all folder, subfolders, & files via webscript

emerald911 — Wed, 04 Apr 2018 06:52:47 GMT

‌, can you give any clue how did you form the structure? Was it one lucene query and then formatting of content or it was multiple queries one by one to build it? Best Regards