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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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.

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 Jira Automation

New to Jira Automation - goodbye Cron (sort of), hello new project created trigger, new additions to

Hey Everyone! Simeon from the Automation team here. I'm delighted to share some new features and improvements that we are shipping to Jira automation (Cloud only). Firstly, @Sam Harding&nbsp...

2,854 views 10 23
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you