nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Nate Ballantyne_pru1c4

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!

Accepted answers

Nate Ballantyne_pru1c4

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

All comments

Nate Ballantyne_pru1c4

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

Bill Sheboy

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:

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

Kind regards,
Bill

Nate Ballantyne_pru1c4

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

Bill Sheboy

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

how to do that for child issues for which none are completed yet
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_pru1c4

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation