Send mail with all issues if sprint starts

[Patrick]

Hello together,

I thought, I could create an automation task to send an e-mail if a sprint starts. The content of the mail, should be all issues of the current started sprint. I stuck on the last part... I didn't find a way, to get all affected issues. Is there any way?

Hopefully thanks for ur help and kind regards

[Patricia Francezi · Accepted solution]

Good day @Patrick 

Check the Lookup issues action 

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues

This would bring you the issues related to your JQL, and the variable can be used to fulfill the emai 

I hope this helps. 

[Patrick]

@Patricia Francezi thanks for ur answer. Yesterday I found this lookup too, but its still empty. 

I Just tried it with the example:

{{#lookupIssues}} * {{key}} {{/}}

its empty ... the sprint of my test project, contains three issues.

[Patricia Francezi]

Please paste your JQL. 

[Patrick]

@Patricia Francezi there is no JQL:

[Patricia Francezi]

Thats the point

When using {{lookupissues}} you need to search them using JQL

An example https://www.atlassian.com/software/jira/automation-template-library/rules#/rule/1357105/25938007

After looking up for issues using the action "Lookup issues", you will add the variable with fields in your send email action.

If you dont know how to find the issues in youre open sprint here is the reference

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-openSprintsopenSprints--

the JQL you need to put in your lookup issue action is: 

sprint in openSprints()

[Patrick]

Ahhhh that's the point 🙈thank you! This would help me.