How to report on published status: "Published" or "Not Published"? | Adobe Higher Education
Skip to main content
B
Blue-Dog
Level 2
February 2, 2024
해결됨

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

  • February 2, 2024
  • 2 답변들
  • 841 조회

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?

이 주제는 답변이 닫혔습니다.
최고의 답변: 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 답변

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 Advisor답변
    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! 

        약관 및 조건Accessibility statement

        Loading footer...