Weekly email reporting the status of related tasks.

[Nikolaos Vlachos]

Hello Everyone, 

I am looking to create an automation that will automatically send an email every week with the status of the related task for each story. I am having some issues trying to find a way to display the related tasks for each story and the status both for the story and the task. So far I have managed to reach the point that I can report the Issue Key for the story and the Summary but not able to add the related tasks. 

I am attaching what I have so far. Any help will be appreciated.

[Magdalena Zhisheva · Accepted solution]

Hi @Nikolaos Vlachos ,

For status you can try to use {{issue.status.name}}

For linked issues may be this one: {{issue.issuelinks.outwardIssue.key}} 

Hope it helps!

[Nikolaos Vlachos]

Hi @Magdalena Zhisheva ,

I added your suggestion to the content section and it doesn't display anything unfortunately. Is there anything I need to do with the lookup first? 

[Magdalena Zhisheva]

Hi @Nikolaos Vlachos , 

I just tested on my side and it's working without any lookup.

In the trigger you need to put a specify via JQL for which issues you need to have a list with their linked issues , i.e.

"project = XXX and issuetype = Story"

In send email action I used this and got email for each ticket part of the JQL:

"Issue Key: {{issue.key}}
URL: {{issue.url}}
Status: {{issue.status.name}}
Linked issues: {{issue.issuelinks.outwardIssue.key}} {{issue.issuelinks.inwardIssue.key}} 

Hope it helps!

[Nikolaos Vlachos]

Hi @Magdalena Zhisheva 

It almost works. Now I am getting the linked issues and the status of the story. But not in one email I got 67 emails :) .

Is there also a way to display the status of the linked issues?

Thank you for your help 

[Magdalena Zhisheva]

Hi @Nikolaos Vlachos ,

To achieve that DO NOT use the check the JQL search in the trigger.

Then Add the lookup action, where you can put the search, i.e. 

"project = XXX and issuetype = Story"

In the email action use this:
"List of issues:

{{#lookupIssues}}
<a> Issue Key: {{key}} </a>
URL: {{url}}
Status: {{status.name}}
Linked issues: {{issuelinks.outwardIssue.key}} - {{issuelinks.outwardIssue.status.name}}
{{issuelinks.inwardIssue.key}} - {{issuelinks.inwardIssue.status.name}}
{{/}}

[Nikolaos Vlachos]

Thank you very much @Magdalena Zhisheva  that worked. I just need to fix how it displays them. 

Thank you again. 

[Magdalena Zhisheva]

Hi @Nikolaos Vlachos ,

Glad it worked :)