nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Automation sending resume email of all watched jira with due date near or past

albanoandrea

Hello,

we would like to create an automation to send every day an email with the resueme status:

list of all the Jira assigned with due date near or past
list of all the Jira watched with due date near or past

For the first point we could use the automation in the library named When a task is near due → send email reminder.

So, for the second point we have tried to modify the automation to get the dinstinct watchers in the For each: smart value step

{{lookupIssues.watchers.distinct}}
{{lookupIssues.watchers.split(",")}}

We did several attempt trying to look at the documentation and at other post, but there seems to be no way to get dinsinct watchers and then send a single mail to all the user with the list of Jiras.

Probably we need to completely change the automation principle, do anyone have an idea on how we could do it?

Accepted answers

All comments

Bill Sheboy

Hi @albanoandrea

For a question like this, please post images of your complete rule and the audit log details showing the rule execution. Those will provide context for the community to offer suggestions. Thanks!

Until we see those...

I am guessing you are using an advanced branch to iterate over the watchers:

Each watchers field in your issues is a list, and distinct alone could produce the distinct combination of selected watchers across the issues.
Instead please try first to merge all of the watchers into a single list, and then use distinct.
Within your branch you can then use lookup issues to select the issues for that watcher.

Kind regards,
Bill

albanoandrea

Hi @Bill Sheboy
so here some more details.

This is the starting rule:

Where For each: Smart Value is

And I'me trying to substitute it with something like

And then

albanoandrea

In particular the result of this rule is that I get several email for every different group of watchers:

if there is at least a Jira with only me as watchers in the related email I get the right list of Jira near to due date.
Here what I get when there is 1 jira with just me watching and another with another watcher:

albanoandrea

Thank you @Bill Sheboy ,

any idea on how I could create the list of all watchers?

Bill Sheboy

You can do this in two steps, as I do not believe this is possible in one step...

action: create variable, to save the arrays of watchers for each issue
- name: varWatcherList
- smart value: {{lookupIssues.watchers}}
action: create variable, to convert the arrays to a list and then get the distinct users
- name: varMergedWatcherList
- smart value: {{varWatcherList.remove("[").remove("]").remove(" ").split(",").distinct}}

That last line removes the square brackets from the arrays, and then splits the text field on commas...which converts it to a list. Now the distinct function can be used.

Once you have tested to confirm this works as you expect, you can use the smart value expression (or the varMergedWatcherList variable split again on commas) as the source for your Watcher, advanced branch.

albanoandrea

Thank you @Bill Sheboy
I think that now I'm very near, I just need last thing that I don't understand.

Going step by step, in the first phase I'm creating the variables as you suggested.

After each step I'm sending an email to me to verify that the variables are ok.

Since there are 3 jiras with 2 different watcher only, the variable varWatcherList is an array with 3 elements.

After the second step the 2 watcher are correctly extracted.

In the second part of the jira I want to dinstict the watcher.

For every watcher I send to me this email, but the emailAddress and displayName is empty

Here the result for the 2 watchers.

So, what I miss is to extract the email address because the last step is this:

And emailAddress is always empty.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud