Sending Automated Emails Based on Child Tickets

Question

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.

Tim Zhu · Answer

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.

Kristopher Perez · Answer

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 · Answer

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