Fetching folder paths in ACS Reports | Community
Skip to main content
A
Asritha
September 5, 2023
Solved

Fetching folder paths in ACS Reports

  • September 5, 2023
  • 2 replies
  • 858 views

Hi Team,

I want to fetch all folder paths under /content/dam/project of primaryType sling:Folder and nt:folder.

 

I have generated a custom ACS Commons Reports, in which I used this query SELECT * FROM [sling:Folder] AS folder WHERE ISDESCENDANTNODE('/content/dam/project');

I am not getting the fully generated report with this query, some folders are not included in the report which has primaryType as sling:Folder. So to avoid that, is there a way to set depth level of 7 on the result?

for example: we have paths like "/content/dam/project/level1/level2/level3/level4/level5/level6/level7", And I want all paths with this depth "/content/dam/project/level1/level2/level3/level4" and all folders under level 3 like "/content/dam/project/level1/level2/level3/a1",  "/content/dam/project/level1/level2/level3/a2" 

 

Any help through this is welcome.
Thanks.

@arunpatidar  @lukasz-m  @kautuk_sahni 

@SivakumarKanoori @Fanindra_Surat @Jagadeesh_Prakash @krati_garg @iamnjain @somen-sarkar @bajancherry @sunil_kumar_ @shelly-goel @Ganthimathi_R @davidjgonzalezzzz @krishna_garikapati  @Shubham_borole @milind_bachani @krishna_sai @manjunathdj  

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by aanchal-sikka

Hello @asritha 

 

You have mentioned that few sling:Folder are not listed. Can you please verify once, if your query is using a proper index.

If not, you might be receiving inconsistent results. 

 

Please try creating an index and verify the results.

 

Also, there is a predicate in querybuilder.

  • property.depth : The number of additional levels to search under a node. eg. if property.depth=3 then the property is searched till 3 level from base node. It is mostly used for nested search.

You can execute and check for its SQL equivalent in query logs

 

2 replies

EstebanBustamante
Community Advisor and Adobe Champion
EstebanBustamanteCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 5, 2023

Try the below query:

SELECT * FROM [nt:folder] AS folder WHERE ISDESCENDANTNODE('/content/dam/project') AND (folder.[jcr:primaryType] = 'sling:Folder' OR folder.[jcr:primaryType] = 'nt:folder')

This query selects all nodes of type "nt:folder" under "/content/dam/project" and filters them based on their primary type to include only those with "sling:Folder" and "nt:folder" as their primary types.

Esteban Bustamante
    A
    AsrithaAuthor
    September 5, 2023

    Hey,

    I wanted sling:Folder as primaryType and I was looking for a way to add depth of 7 on the folder paths.

      aanchal-sikka
      Community Advisor
      aanchal-sikkaCommunity AdvisorAccepted solution
      Community Advisor
      September 5, 2023

      Hello @asritha 

       

      You have mentioned that few sling:Folder are not listed. Can you please verify once, if your query is using a proper index.

      If not, you might be receiving inconsistent results. 

       

      Please try creating an index and verify the results.

       

      Also, there is a predicate in querybuilder.

      • property.depth : The number of additional levels to search under a node. eg. if property.depth=3 then the property is searched till 3 level from base node. It is mostly used for nested search.

      You can execute and check for its SQL equivalent in query logs

       

      Aanchal Sikka
        Terms & ConditionsAccessibility statement

        Loading footer...