How to report on published status: "Published" or "Not Published"? | Community
Skip to main content
B
Blue-Dog
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
Harwinder-singhCommunity 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
      yashp0808
      Level 3
      February 5, 2024

      This should work! 

        Terms & ConditionsAccessibility statement

        Loading footer...