How to get list of components in AEM? | AEM Community Blog Seeding

[kautuk_sahni]

How to get list of components in AEM? by Rashidjorvee

Abstract

How to get list of components in AEM?
We can get the list of components based on the project path or component group in AEM. SQL Query is powerful to filter out the component nodes and this can be easily used in the query tool of crx/de and export the results in a spreadsheet.

Below is the JCR-SQL2 query to get the list of all the components in AEM.

SELECT * FROM [cq:Component] AS s WHERE [componentGroup] IS NOT NULL AND ISDESCENDANTNODE([/apps/aem-sample-project/components])

Read Full Blog

How to get list of components in AEM?

Q&A

Please use this thread to ask the related questions.

[B_Sravan]

Instead of query, for this use case, one can use http://localhost:4502/libs/wcm/core/content/sites/components.html for a better user/author experience.

the search filters come in handly as well.

[raju-komari]

Hi Sravan,

Thanks for the update, but above (OOB ) one is not giving full list where list size is not getting increased even we scroll down, may be UI issue.

Better to use SQL2 Query to get list if component's under specific path 

SELECT * FROM [cq:Component] WHERE ISDESCENDANTNODE([/apps/abcproject/components])