Sending Automated Emails Based on Child Tickets

[Tim Zhu]

Hi, 

I'm looking to send a weekly email where I look through a set of Jira projects and query their child tickets.  Then based on which child tickets are closed or missing a target end date field, send an email (w/ formatting if possible?) to the assignees that match this query. 

Is there any documentation on how I can best do this? 

cc: @swilson as I think I saw you answer a question in this same relm. 

[Kristopher Perez]

If you can get your Query into a saved JQL filter, you can set a subscription to email you at whatever interval makes the most sense to you.

Check out these links:

• https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4/amp
• https://confluence.atlassian.com/jira064/receiving-search-results-via-email-720416706.html

if you need help refining the JQL, reply with some more specifics and I’m sure we can help get it written.

Kris

[Tim Zhu]

hi @Kristopher Perez thanks for sharing!

Is there a way to format the content of the email?  We want to automate these emails to send to leadership and they need more context than a list of issues.

[Tim Zhu]

hi @Kristopher Perez wanted to bump this.  Do you or anyone else in the community know if we can format that outgoing email?

[Kristopher Perez]

If you are looking for a more customized solution you can using Automation for Jora instead.

Could you give me some example text of what you would want the email to say and where the variable substitutions would be.

[Tim Zhu]

hi @Kristopher Perez ,

We are using jira tickets as team Projects w/ child tickets to signal product development lifecycle milestones (Concepting, Build, Testing, Launch) and a status field that shows the workflow of the ticket (on track, at risk, offtrack)

So an example weekly email would be something like:

=============================================

Here is a summary of projects in the next two weeks that will be going into testing and Launch:

Table:
Project 1 -> Testing
Project 2 -> Testing

Project 3 -> Launch
Project 4 -> Launch

Here are a list of projects that recently had a change in status:

Table 2:

Project 8 Ontrack -> At Risk

Project 9 At Risk-> Off Track

=============================================

And we would tailor the formatting and add different tables based on Jira queries.