How to make a automation rule which copy the most recently created page among child pages?

[hasungjoo]

How to make a automation rule which copy the most recently created page among child pages?

When Monday 9 am every week, make "week 6" named child pages copy from "week 5" page. 

is it possible to make by automation rule?

[Trev Angle]

Hi @hasungjoo, this is Trevor from the Confluence automation team. Here's a rule that I think would work for you:

This rules runs every Monday at 9 AM, finds pages which were published within the last 8 days that have a certain parent page, and then publishes a copy with the title "Week of 6/24/24" (for example). So the rule assumes that no more than one page gets published each week under the parent.

Here's the CQL that I used to configure the "related entities" branch component: type = page AND parent = 92405761 AND created >= now("-8d")

You would just replace the number there with the ID of your parent page.

Another approach you could consider is having a single template page that gets copied every week. Then your CQL would be even simpler: type = page AND id = 123456 (where the number is the ID of your template page)

[hasungjoo]

Thanks @Trev Angle , 

[Bill Sheboy]

Hi @hasungjoo -- Welcome to the Atlassian Community!

First thing, I am not using Confluence automation rules, and so my suggestions are based on what I know about automation rules in general.  With that out of the way...

I do not believe there is a "lookup pages" rule action to use CQL to find the pages, and so identify the most recent one.

However I hypothesize a rule could use the Send Web Request action to call the Confluence REST API to get the pages in your space, identify the most recently created one, and then use that for the copy page action.

Kind regards,
Bill

[hasungjoo]

Thanks!