Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

How to report on published status: "Published" or "Not Published"?

Avatar

Level 2

I am trying to create a pages report that will display the status of a page: either "Published" or "Not Published".

I know that the published status information is displayed in the authoring UI for a given page, as shown in the following screenshots:

 

published.png  not-published.png

 

Here is my base Query:

 

SELECT * FROM [cq:Page] AS s WHERE ISDESCENDANTNODE([/site/folder1/folder2/])

 

But I don't know how to build and display the "Published" status using the "ACS Commons Report Builder Text Column" component. Which page property or combination of properties need to be used?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Here is the sample query

 

SELECT * FROM [cq:Page] AS page
WHERE ISDESCENDANTNODE(page, '/content')
AND page.[cq:lastReplicated] IS NOT NULL
AND page.[cq:lastReplicationAction] = 'Activate'
ORDER BY page.[cq:lastReplicated] DESC


Arun Patidar

View solution in original post

3 Replies

Avatar

Community Advisor

@ncw3qwp You can refer to the replication API documentation to understand what status is set on the node when it is activated / deactivated. It will also let you tap into the last replication action as well. 

 

https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/operations/replicat...

 

Avatar

Correct answer by
Community Advisor

Here is the sample query

 

SELECT * FROM [cq:Page] AS page
WHERE ISDESCENDANTNODE(page, '/content')
AND page.[cq:lastReplicated] IS NOT NULL
AND page.[cq:lastReplicationAction] = 'Activate'
ORDER BY page.[cq:lastReplicated] DESC


Arun Patidar