AEM-ACS-Common Report tools. | Community
Skip to main content
tushaar_srivastava
tushaar_srivastava
Level 6
January 11, 2023
Solved

AEM-ACS-Common Report tools.

  • January 11, 2023
  • 1 reply
  • 705 views

Hi All,
I need to get a report where It will look of all the pages and generate a report of Image components are under Custom Container Component.
Example:  I have a page under /content/pages/en_us/test
and inside that page I have custom container : I have a page under /content/pages/en_us/test/jcr:content/custom_container.
And inside that custom container I have the Image component like /content/pages/en_us/test/jcr:content/custom_container/image

But If I have to fetch the list of all the Images component under a container what could be the soultion for this.

 

I came across ACS-Common-Report tool [http://localhost:4502/apps/acs-commons/content/report] , and created a custom report, now I need help here How to do the configurations to fetch the Images under custom container.


Any Suggestion/guidance ?

 

Thanks

 

@kautuk_sahni  @arunpatidar  @briankasingli @santoshsai  @krati_garg 

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 arunpatidar

Hi,

You need to write join queries for that, one of the example is 

 

SELECT parent.* FROM [cq:Page] AS parent INNER JOIN [nt:base] AS child ON ISCHILDNODE(child,parent) WHERE ISDESCENDANTNODE(parent, '/content/mfHTL63') AND child.[sling:resourceType] = 'mfHTL63/components/structure/page' AND name(child) = 'prelogin'

 

1 reply

arunpatidar
Community Advisor
arunpatidarCommunity AdvisorAccepted solution
Community Advisor
January 11, 2023

Hi,

You need to write join queries for that, one of the example is 

 

SELECT parent.* FROM [cq:Page] AS parent INNER JOIN [nt:base] AS child ON ISCHILDNODE(child,parent) WHERE ISDESCENDANTNODE(parent, '/content/mfHTL63') AND child.[sling:resourceType] = 'mfHTL63/components/structure/page' AND name(child) = 'prelogin'

 

Arun Patidar
    Terms & ConditionsAccessibility statement

    Loading footer...