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

13 replies
2416 views
Translate All

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.

U

user1576Accepted solution

Level 3

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

Adobe Champion and Community Advisor

Hi @sanjay91 ,

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

Thanks,

Ritesh Mittal

Translate

S

sanjay91Author

Level 2

I want compare number of pages in author and publisher

Translate

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

Translate

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.

Translate

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

Translate