Automation for jira list issues in current sprint when started in a slack/teams message

[Martin Poirier (MTL AUG Leader)]

Question on automation for jira.

How I do a automation that get all the issues from the current sprint (sprint started trigger) and send the list of issues in that sprint in a slack message.

Those kind of automation will only send the message slack for each issue which is not what I Want.

[Nick Menere]

Hi Martin,

Whether you can do this comes down to whether you are running in Cloud or Server.

In Server there is an option to process the issues in bulk on the branch. Simply select that option and then use this in the Slack Message:

{{#issues}}
{{key}} - {{summary}}
{{/}}

In Cloud, we don't currently support bulk processing due to the fact, by its nature, it is more less efficient (it has to do remote calls instead of calls directly to the DB).

Hope that helps.

Cheers,
Nick [Automation for Jira]
Co-founder

[Martin Poirier]

Ah ya I was forgetting the trigger in bulk.

So it finish with this (sprint.startDate or endDate has no documentation on your website btw)

Issues in the sprint : *{{sprint}}* - Start date :{{#sprint.startDate}}
 format="dd/MM/yyyy"
{{/}}
{{#issues}} 
<br><a href="https://URLjira/jira/browse/{{key}}">{{key}}</a>-{{summary}} <br>
Created: {{#created}}
 format="dd/MM/yyyy"
{{/}}
{{/}}

 Thanks!

Martin

[Nick Menere]

Awesome to hear!

You may be better off you using:

Issues in the sprint : *{{sprint}}* - Start date :{{sprint.startDate.format("dd/MM/yyyy")}}
{{#issues}} 
<br><a href="{{toUrl}}">{{key}}</a>-{{summary}} <br>
Created: {{#created}}
 format="dd/MM/yyyy"
{{/}}
{{/}}

p.s. we just hired a tech writer yesterday so expect some awesome changes coming to our docs!

Cheers,

Nick

[Greg Bailey]

Hello,

Related question if I may.

Is it possible to access the sprint name in an email with the sprint issues in an attached XLS?

Im being asked to send an XLS of issues in a sprint on sprint start.  To do this I am using the 'Issues in Sprint'  branch and setting it to process the issues in bulk.  In that branch I have a send XLS action.  There's no problem getting all of the issues in the XLS that is sent, but Im unable to access the actual sprint name to use it the email subject and body.  I've tried the smart value of '{{smart value}}' but it does not resolve and ends up literally as '{{smart value}}' in email.  And unfortunately using '#cfValue(${issues.get(0)} 10005)' isn't reliable due to, unfortunately, issues may have multiple sprints in the sprint field so that is not an option.

Any help is greatly appreciated.

Thanks in advance,

Greg