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

Forum|Forum|3 years ago
January 5, 2023
3 replies
2350 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

Hi ,

If you are running query in publish server after login it should work .

Also try query builder

Step 1: Go to the below mention URL. Adjust the domain according to your domain name.

http://localhost:4502/libs/cq/search/content/querydebug.html

Step 2: Put the following query in the "Query Builder Debugger" section

type=cq:Page

path=/content/sample/en/en_us

p.limit =-1