How to report on published status: "Published" or "Not Published"? | Community
Skip to main content
Level 2
February 2, 2024
Solved

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

  • February 2, 2024
  • 2 replies
  • 841 views

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:

 

  

 

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?

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 arunpatidar

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

2 replies

Harwinder-singh
Community Advisor
Community Advisor
February 2, 2024

@blue-dog 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/replication.html?lang=en#replication-api

 

arunpatidar
Community Advisor
arunpatidarCommunity AdvisorAccepted solution
Community Advisor
February 4, 2024

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
yashp0808
Level 3
February 5, 2024

This should work!