List the pages which got activated on a particular day | Community
Skip to main content
A
Arun_007
Level 2
March 19, 2018

List the pages which got activated on a particular day

  • March 19, 2018
  • 2 replies
  • 5934 views

Hi All,

Am running on AEM 6.1 SP2-CFP11.

We had a scenario:

The author has de-activated (by mistake) and activated the parent node of the content page which has 200+ child pages.

The problem is we need to identify what are all the pages which got activated newly during this bulk activation and deactivate them again.

Can someone please help me with the better solution to address this scenario? We don't have the error logs/replication logs since this happened a month ago.

Note: We have a workflow created which activates/deactivates the bunch of child nodes when a parent node is activated/de-activated.

Thanks,

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    joerghoh
    Adobe Employee
    joerghohAdobe Employee
    Adobe Employee
    March 19, 2018

    By default the replication creates a new version of a page.

    * For each of these pages:
    ** Identify the version which has been created by this replication action

    ** Check the replicationStatus property on that version

    ** if (replicationStatus == DEACTIVATED):

    *** The page was deactivated when this mistake happened

    ** if (replicationStatus not present):

    *** The page has never been activated

    ** (if (replicationStatus == ACTIVATED):

    *** The page was activated at that time

    You should probably validate this approach in some test environment :-)

    Good luck!

    Jörg

      A
      Arun_007Author
      Level 2
      March 19, 2018

      Hi Jörg, Thanks much for spending your time to answer my problem.

      Am trying to implement your solution, can you please help me with a sql2 query or a query builder params, which gets me the replication status of a page? - Am struggling here.

      Thanks,

      Arun.

        edubey
        edubey
        Level 10
        March 20, 2018

        You can use something just like this ( below one only for pages which are activated )

        path=/content/project

        type=cq:Page

        group.p.or=true

        group.1_property=jcr:content/cq:lastReplicationAction

        group.1_property.value=Deactivate

        group.2_property=jcr:content/cq:lastReplicationAction

        group.2_property.operation=not

          Hemant_arora
          Hemant_arora
          Level 8
          March 20, 2018

          SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/we-retail]) and s.[cq:lastReplicated] >= '2018-03-20T14:37:27.530+05:30'

          you can also add another and clause to find between two dates

            Terms & ConditionsAccessibility statement

            Loading footer...