Create Automation for updating Parent Due Date

Pritam Rakshit

Hello,

I am looking to create an automation where it will query Due Date of all child EPICs of a Scenario and then update the Due Date of the Scenario based on the Due date which the last among all the EPICs.

Eg: We have 4 EPICs with below dates, then the Scenario due date will be set as 8/3/2024 which is the last due date among all the EPICs.

 

EPIC 1 - 7/5/2024

EPIC 2 - 7/20/2024

EPIC 3 - 8/3/2024

Bill Sheboy

Hi @Pritam Rakshit -- Welcome to the Atlassian Community!

What have you tried thus far to solve this need?

 

If you have a rule which is not working as expected, please post images of your complete rule and the audit log details, and explain what is not working.  Those will provide context for the community to offer suggestions.

 

If you have not yet started a rule, I encourage you to try to do so.  Successfully using automation rules requires learning and experimentation.  When one only uses rules provided by others without understanding them, they are often not able to maintain and improve the rules.

To get you started on your rule, I recommend first confirming which version of Jira you are using: Cloud, Server, or Data Center.  These versions have different automation capabilities.

There is Lookup Issues action that would help do this with Jira Cloud, but that action does not contain the Due Date field for the Data Center version yet.  Here is the suggestion to add more fields for Data Center lookups: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

Your question is tagged with "Data Center", and so if you are using that version, you may need to use the Send Web Request action to call the REST API issue search with JQL.  Then you can access the Due Date field to find the maximum one in the web request response.  Here is a how-to article to get you started with that method: https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

Kind regards,
Bill