Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Component Instances Report: Need component and count of those across content tree

aem-explorer
Level 2
Level 2

I need a report which would list

 

Component 1: 45

Component 2: 78

Component 3: 87

 

Where these are <component>:<instances>

 

There is a acs commons component instances report, but that is per component. What query/report should I use to get this kind of data as output?

 

1 Accepted Solution
vanegi
Correct answer by
Employee
Employee

You can write a custom logic using JCR API to get the count of the component.

If you want to find the components, then get the list of component names from apps and write a search query for each of the component name. Just a simple JCR Query that would find items containing property jcr:primaryType being cq:Component within /content would work. Depending on what the content structure of your site is, the following XPath query can be used:

 

/jcr:root/content/mysite//*[jcr:primaryType='cq:Component'])
would get you the number of all components in the mysite content tree.

 

https://helpx.adobe.com/experience-manager/using/querying-experience-manager-data-using1.html

https://helpx.adobe.com/experience-manager/using/programmatically-accessing-cq-content-using.html

 

 

 

View solution in original post

2 Replies
SundeepKatepally
Level 5
Level 5

Query builder or xpath or sql2 is not as flexible as RDBMS  SQL . As far as i know with a single query we cannot get what your are expecting . Only way is get at the component level using a simple query-builder or sql2 query.

 

vanegi
Correct answer by
Employee
Employee

You can write a custom logic using JCR API to get the count of the component.

If you want to find the components, then get the list of component names from apps and write a search query for each of the component name. Just a simple JCR Query that would find items containing property jcr:primaryType being cq:Component within /content would work. Depending on what the content structure of your site is, the following XPath query can be used:

 

/jcr:root/content/mysite//*[jcr:primaryType='cq:Component'])
would get you the number of all components in the mysite content tree.

 

https://helpx.adobe.com/experience-manager/using/querying-experience-manager-data-using1.html

https://helpx.adobe.com/experience-manager/using/programmatically-accessing-cq-content-using.html

 

 

 

View solution in original post