Set up Jira automation to add a date/time field to Epic once a child has moved to "In Progress"

Nate Ballantyne March 7, 2024

I need to add a new date/time field to an epic one any child issue has been moved to "in progress", this is only to be added once as it will be used to identify at what point in time work on an epic officially started.

I'm struggling putting a rule together for this so any help would be appreciated!

2 answers

1 accepted

0 votes
Answer accepted
Nate Ballantyne March 7, 2024

This was actually a lot more straight forward than I thought! I'd like to also figure out how I can update all child issues retroactively.

Screenshot 2024-03-07 at 11.28.18.png

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

Hi @Nate Ballantyne -- Welcome to the Atlassian Community!

Well done answering your own question!  For your second question, what do you mean by:

I'd like to also figure out how I can update all child issues retroactively.

For example, do you want to:

  1. update all existing epics which are not yet completed
  2. update child issues of epics in some manner
  3. something else?

Kind regards,
Bill

Nate Ballantyne March 7, 2024

Hey Bill!

I mean for all epics that already have child issues that have already moved to “in progress”, (or could be completed) how do I capture the date that happened against an epic

Like Bill Sheboy likes this
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

Thanks for clarifying, and this is really two problems to solve:

  1. how to do that for child issues for which none are completed yet
  2. how to do that for child issues for which at least one is completed already

 

For a scenario like this where one wants to retroactively set a field value, a scheduled trigger rule with JQL to scan the Epics (and their child issues) can help.  The rule can be enabled until all "caught up", and then disabled.

 

For #1 above, the rule could use the lookup issues action to gather the child issues which are "in progress" for the trigger epic, and then use the minimum value of the Status Category Changed Date.  For example with:

{{lookupIssues.statuscategorychangedate.toDate.min}}

 

Case #2 is a challenge, as the date / time when the first child issue moved to "in progress" is in the issue history, and that is not easily accessible by a rule.  I recommend not trying to solve that with automation rules and instead set those manually.

Nate Ballantyne March 7, 2024

This is great, thank you! Will certainly be looking into the first one 😁

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events