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 Epic Start and Due Date to earliest/latest Child Dates

Roman Kastner

Hi,

I want to have an automation to do the following:

The type of trigger does not really matter (manually or field value change is possible), but it should be executed on an Epic.

The automation should get the earliest Start Date of all child Issues under an Epic.

Then the Epics Start Date should be updated with this earliest Start Date.

Analogously I will need the functionality for the Due Date.

A screenshot and possible queries would be much appreciated!

Thanks in advance

Comments

Trudy P Claspill

Hello @Roman Kastner

Welcome to the Atlassian community.

You could use the Field Value Changed trigger to monitor the Start Date and Due Date fields for changes.

You would follow that with an Issue Field Condition to confirm that the issue is not an Epic or a subtask.

You would follow that with a For Branch / Related Issues / Epic (parent) step

Within the branch you could use the Lookup Issues action to retrieve all the child issues of that Epic via JQL where the field you monitored in the Trigger (Start Date, or Due Date) is not empty, and order the results by that field so that the first issue listed would have the date you want to copy to the Epic.

i.e.: "Epic Link" = {{issue.key}} and "Start Date" is not empty ORDER by "Start Date" asc

You would add an Advanced Compare Condition to confirm that there was at least 1 issue in the result set.

- First Value: {{lookupIssues.size}}

- Condition: greater than

- Second value: 0

The next step would be to update the Epic's Start Date field with the Start Date value from the first issue in the results set using the Edit Issue action.

- Field to update: Start Date

- Value: {{lookupIssues.first.Start Date}}

Repeat the Lookup Issues, Advanced Compare, and Edit Issue actions for the Due Date field.

Screen Shot 2023-05-09 at 4.27.57 PM.png

Roman Kastner

Hello Trudy,

thank you so much, it works.

Best regards,

Roman

Trudy P Claspill

You're welcome.

In the future, you may want to post questions in the Questions board rather than the Discussion board.

Johnny Hermann_4o2cv9

Consider other triggers that affect membership as a child of the Epic, including Epic Link changes, and creation of issues directly as a child of an Epic.

RXAVIER

Hello Guys,

First of all thank you for sharing all this options.

Even though I'm struggling to use this automation for the field "Target End" from advanced roadmaps.

I'm using the input by JSON following this: "fields": {
"customfield_13603" but I receive the feedback that this is an unknown custom field.

Can you help me out to find which expression should I use for JSON regarding the "Target End"?

Thanks in advance

Trudy P Claspill

@RXAVIER

Welcome to the Atlassian community.

Please post you request for assistance in on of the Questions boards, such as this one.

https://community.atlassian.com/t5/Jira-questions/qa-p/jira-questions

Describe your scenario and provide images of the rule you have created. Show the output in the Audit Log. If you are using JSON to edit fields then show the details of those steps.

If this Discussion post is relevant to your question, add a link to it in your post.

RXAVIER

Thank you @Trudy P Claspill , already did it here!

Erich Heerdt

This is very helpful! However, wouldn't you want to change Due Date to sort DESC so it grabs the highest value, or alternatively use the last item in the lookup.Issues?

(I changed mine to DESC (just for dueDate) and it works perfectly. Thanks to everyone helping out with this questions its very useful!)

Trudy P Claspill

Yes, if you want the latest Due Date you would need to either sort the Lookup Issues results on Due Date DESC and get the first item in the results or if you used ASC you would need to get the last item in the list rather than the first.

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

epic

automation

due-date