How to compare aem author env pages and AEM Publish Env page

Forum|Forum|3 years ago
January 5, 2023
3 replies
2351 views

Hi Team,

Please help fory below query.

How to compare aem author env pages and AEM Publish Env page like ''content/mysite/ under pages

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 user1576

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager-blogs/how-to-find-or-count-all-pages-in-aem-project-aem-community-blog/ba-p/388479

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-results-count-using-query-builder-aem-community-blog-seeding/m-p/388786

Ritesh_Mittal

Community Advisor and Adobe Champion

Hi @sanjay91 ,

Do you mean visual comparison of HTML pages on author against publish?

Thanks,

Ritesh Mittal

S

sanjay91Author

Level 2

I want compare number of pages in author and publisher

H

Harishv31

Level 3

Hi ,

You can write sql query to find the number of pages in both environment.

select * from [cq:PageContent] AS s where s.[cq:lastReplicated] IS NOT NULL AND ISDESCENDANTNODE(s,[/content])

And also try custom reports for your requirement.

https://aem.redquark.org/2019/06/create-custom-reports-in-aem-component.html

Thanks

S

sanjay91Author

Level 2

Hi Haris,

I am writing same code

cq:PageContent] AS s where s.[cq:lastReplicated] IS NOT NULL AND ISDESCENDANTNODE(s,[/content])

But I can get all author page count but i did not count publish page and also when I was putting hole url in query got error message so how to connect url https and port number in query.

H

Harishv31

Level 3

My Requirement is compare publisher page count and author page count if find page number is not equal so send the mail. but my problem is same time count page number author and publisher.

In the query builder ,you can query and get Json query link and use in the java code to call the link and return the results to compare.

http://localhost:4502/bin/querybuilder.json?p.limit=-1&path=%2fcontent%2fwe-retail%2fus%2fen%2fmen&type=cq%3apage (add authorization)

"success":true,"results":17,"total":17,"more":false,