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

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments
SOLVED

Best Approach to get all the pages and their metadata, page properties information into a DB

Avatar

Level 4

Hi All,

        We have a requirement to fetch all the page urls and their metadata,page properties present in CQ author instance and store them in to a DB. What is the best approach to do this in CQ?

 

Regards

Nivas

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Can't you do the reporting inside AEM? Exporting all the stuff and doing then some reporting doesn't sound right to me.

Jörg

View solution in original post

3 Replies

Avatar

Level 6

Is this for analysis tool like Coremetrix?

The best approach, IMHO, would be to create a workflow that is triggerd on modify (create, update and delete) of a node, check if the change is on a node of the type Page and then write it to the database according to specification. Of course, you need to have a second workflow or service that sends all the pages to the workflow initially as a workflow payload.

The question I instantly have to ask is "what is a page"? Is "A page node in AEM" or is it "A URL on the site"?. The first one is easy to do, the second one demands a lot more.

 

/Ove

Avatar

Level 4

Hi, 

 Basically we need this information ( page url, metadata, page properties) for reporting and searching purpose. So we need an approach to get the complete information under /content folder into db along with their meta data and page properites. 

Avatar

Correct answer by
Employee Advisor

Can't you do the reporting inside AEM? Exporting all the stuff and doing then some reporting doesn't sound right to me.

Jörg