Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,800
Community Members
 
Community Events
168
Community Groups

issue looping in email with #{{issues}} tag and other criteria such as status

I have an email report consisting of issues resulting from a JQL query.

I'm being asked to separate this list by status into different tables in the email.

I'm wondering if there is a way to apply some form of conditions to the issues loop to restrict to a specific status and then do that as many times as needed to get the separated status tables.

the loop right now is basic as shown below. But can I somehow restrict each loop to a specific status?

{{#issues}}
<tr style="border: 1px solid black;">
<td style="border: 1px solid black; padding:5px 10px 5px 5px; "><a href="{{toURL}}">{{key}}-{{Summary}} </a></td>
<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{status.name}}</td>
<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{assignee.name}}</td>
<td style="border: 1px solid black; padding:5px 10px 5px 5px; ">{{updated.format("yyyy-MM-dd")}}</td>

</td>
</tr>
{{/}}
</table>  

 Any help or suggestions would be appreciated.

Thanks in advance,

Greg

4 answers

You can use Notification Assistant for Jira for this. We support JQL bounded tables as a common email type.

0 votes

Hi @Greg Bailey 

How about this approach:

  • copy your JQL for the issue list, adding a clause to select a status (or status category), for example: ... AND status = NotStarted
  • use the Lookup Issues action to grab the items using the JQL
  • use the Create Variable action to parse the items into markup.  For an example...
    • Create Variable named myIssuesNotStarted
    • Value is: 
<ul>{{#lookupIssues}}<li><a href="{{url}}">{{key}} - {{summary}}</a></li>{{/}}</ul>
  • Repeat for each status (or status category) of interest
  • Create your email to reference the variables, such as {{myIssuesNotStarted}} as you wish.

I tried this with three sections showing the Todo, In Progress, and Done issues listed.

Best regards,

Bill

Thanks so much @Bill Sheboy

 

I'm out of the office today, but this will be top of my list tomorrow AM.

 

Regards,

Greg

Like Bill Sheboy likes this

Color me sad... 
we are on Jira Server, not Cloud and the lookup issues action is not available for server.

Back the drawing board.  ;-(

 

btw here's the ticket to bring lookup issues to the server version.  Please add votes! 

Greg, sorry that I missed you were on server version.

I wouldn't hold out for the server version getting that soon.  Atlassian is stopping sales of that product soon (Feb 2021) and will sunset after that (Feb 2024):

https://confluence.atlassian.com/support/atlassian-support-end-of-life-policy-201851003.html

__Bill

Hi Hana,

Thanks for that.  I had a feeling it may be the case this was not possible.

yeah, the emailed report is already sorting by status so we at least have that.  And no we don't want to send multiple emails. ;-)

 

Thanks for the response,

Greg

0 votes
Hana Kučerová Community Leader Nov 05, 2020

Hi @Greg Bailey ,

unfortunatelly, I don't think this is possible.

What about to sort the issues by status, would it help a little bit?

The second possibility I can see is to send more emails, for each status one email, but that's not very nice solution.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Atlassian Automation

Jira Automation: Sum Up Story Points Roundup (Initiatives -> Epics -> Story/Tasks -> Subtasks)

Hi Everyone, In this roundup we combine all the jira automation rules to sum up story points across different issue types. We start from the lowest level, summing up story points from sub-tasks t...

3,098 views 10 9
Read article

Atlassian Community Events