How to compare aem author env pages and AEM Publish Env page | Adobe Higher Education
Skip to main content
Level 2
January 5, 2023
Répondu

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

Hi Team,

Please help fory below query.

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

Ce sujet a été fermé aux réponses.

3 commentaires

Ritesh_Mittal
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
January 6, 2023

Hi @sanjay91 ,

 

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

 

Thanks,

Ritesh Mittal

sanjay91Auteur
Level 2
January 6, 2023

I want compare number of pages in author and publisher

Level 3
January 6, 2023

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

sanjay91Auteur
Level 2
January 6, 2023

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. 

Level 3
January 6, 2023

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
Level 3
January 6, 2023

Hi Sanjay ,

 You can go with below approaches to compare or find count number of pages

1. Query builder

2. Site admin - parent page - count

3. Query debugger - localhost:4502/libs/cq/search/content/querydebug.html 

4. download package and compare content using beyond compare tool. 

 

sanjay91Auteur
Level 2
January 6, 2023

I want automation bro so if count is different so send remider mail to business owner