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
Hello Trudy,
thank you so much, it works.
Best regards,
Roman
You're welcome.
In the future, you may want to post questions in the Questions board rather than the Discussion board.
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.
Good point, @Johnny Hermann
I have constructed other rules that detect a change in the parent epic of an issue and then execute some "recalculation" actions against both the original parent Epic and the new parent Epic.
If a child issue is removed from its Epic, the Start and Due dates on that Epic may need to be reset.
If a child issue is added to an Epic, the Start and Due dates on that Epic may need to be reset.
Hello @Trudy Claspill can you explain how did you execute this "resets" in terms of automated functions in jira?
Thank you
Hi @Trudy Claspill Thanks for the automation. We need to a similar kind of automation, we need to print earliest planned dates among all subtasks on story level when story transitioned to a particular status.
Hello @C S Seshagiri
Welcome to the Atlassian community.
If you have a question about automation I suggest that you post it in the Questions area so that more people will see it.
https://community.atlassian.com/t5/Jira-questions/qa-p/jira-questions
The only people who see new post on existing topics are the people that watch the topic.
Additionally when asking about automation rules it is important that you post a copy of the rule you have tried to construct and provide details of how it is not operating in the way you want.
If this Discussion thread is relevant to your question, include a link to it when you post your Question.
Thanks @Trudy Claspill !! To add on, i bumped into frustration when dealing with the Due Date field if i syntax reference it as "Due date" (with a space) . I found out it is probably an internal Jira engine problem in referencing to the Due date field. When coding it in automation , what worked is "Duedate" (Without the space!)
The JQL for Lookup Issues :
"Epic Link" = {{issue.key}} and "Duedate" is not empty ORDER by "Duedate" asc
The JQL for Edit issue fields for for Due date :
{{lookupIssues.last.Duedate}}
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
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.
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!)
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.
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Jira Administrator
Configure Jira Software, Jira Core, or Jira Service Management, including global settings, permissions, and schemes.
Managing Jira Projects Cloud
Learn to create and configure company-managed projects in Jira Software and partner effectively with Jira Admins.
Learning Path
Become an effective Jira Software Project Admin
This learning path is designed for team leaders who configure Jira Software projects to match a team's processes.