Automation to update parent start/end dates based on earliest/latest child dates

Question

Has anyone successfully created Automation to update the parent issues start and end dates based on earliest and latest child issues dates. We use Initiatives, Epics and Tasks. We would like to have the start and end dates of parent Epics and Initiatives be updated to show their start and end date as the earliest start date and latest end date of child issues. And if the date of a child issue is updated, the automation update the parent Epic and Initiative if applicable.

Jeff Cumbie · Answer

Thanks Bill. We are using Jira Server v8.22.6 and Automation v.7.4.1.

I'm completely new to Automation and only gotten a feel for Jira about a month ago.

Bill Sheboy · Answer

Hi @Jeff Cumbie -- Welcome to the Atlassian Community!

When do you need to complete this and what version of Jira Server, automation are you using?

I ask, because the lookup issues action just got added for server, and that would make doing this much easier as you could use JQL to gather the issues and then use min and max on the date fields.  Please look here to learn more: https://jira.atlassian.com/browse/JIRAAUTOSERVER-53

A work-around would be to use JQL and call the REST API functions with a webrequest to gather all relevant issues, producing a list of issues.  Then min and max can similarly be used on the date fields.

Kind regards,
Bill

Laurie Sciutti · Answer

Hi @Jeff Cumbie ~ we've done something similar in that we update due dates based on a given release date in the parent.  The following should help get you started...