Send mails: CQL automation

[Tobias Schweiger]

Hello,

I have an automation rule that searches outdated pages (for example that have not been edited in the past year) and requests the author via email to update their page. The problem is that an author can have several pages and will therefore get several emails. However, we want to set a rule with CQL that only sends 1 email to each author if they have an outdated page, and not 1 email per outdated page.

Thank you!! 

[Bill Sheboy]

Hi @Tobias Schweiger -- 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 Jira Cloud automation features.  Please verify / test what I suggest to learn if it can work with Confluence automation.  With that out of the way...

1. Does Confluence automation have an advanced branch, which allows iterating over a smart value list?  If so...
2. Does Confluence automation have a Lookup Pages action, operating on CQL?  If not, I believe it does have a Send Web Request action which could call the REST API function to search with CQL for pages.

If the advanced branch is available (point #1), a list (point #2) could be iterated over using the distinct function to find the unique authors.  Once inside the branch, the CQL could be used again with the unique author 

Kind regards,
Bill