Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Send mails: CQL automation

Tobias Schweiger January 21, 2024

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!! 

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 21, 2024

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events