Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

List the pages which got activated on a particular day

Avatar

Avatar
Validate 1
Level 2
Arun_007
Level 2

Likes

4 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Arun_007
Level 2

Likes

4 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
Arun_007
Level 2

19-03-2018

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,

Replies

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,111 likes

Total Posts

3,145 posts

Correct Reply

1,072 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,111 likes

Total Posts

3,145 posts

Correct Reply

1,072 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

19-03-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

Avatar

Avatar
Validate 1
Level 2
Arun_007
Level 2

Likes

4 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Arun_007
Level 2

Likes

4 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
Arun_007
Level 2

19-03-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.

Avatar

Avatar
Validate 1
Level 10
edubey
Level 10

Likes

274 likes

Total Posts

1,502 posts

Correct Reply

392 solutions
Top badges earned
Validate 1
Give Back 50
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Validate 1
Level 10
edubey
Level 10

Likes

274 likes

Total Posts

1,502 posts

Correct Reply

392 solutions
Top badges earned
Validate 1
Give Back 50
Give Back 5
Give Back 3
Give Back 25
View profile
edubey
Level 10

19-03-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

Avatar

Avatar
Validate 1
Level 7
Hemant_arora
Level 7

Likes

92 likes

Total Posts

290 posts

Correct Reply

54 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 50
View profile

Avatar
Validate 1
Level 7
Hemant_arora
Level 7

Likes

92 likes

Total Posts

290 posts

Correct Reply

54 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 50
View profile
Hemant_arora
Level 7

20-03-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

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,111 likes

Total Posts

3,145 posts

Correct Reply

1,072 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,111 likes

Total Posts

3,145 posts

Correct Reply

1,072 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

20-03-2018

You need to check that property on the versioned nodes (which live under /jcr:system), not on the current pages in /content. Therefor a simple query does not help. You need to traverse the version history of each of the nodes which was affected.

And before you start to implement code, you should validate the algorithm manually.

Jörg