You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have a project that has multiple initiatives (INT-1, INT-2 etc) associated. Under each initiative there is two or more epics. As an example:
INT-1 has EPIC-1 and EPIC 2
INT-2 has EPIC-3 and EPIC 4
Using automation I am trying to get the maximum actual end date of epics under initiatives and automatically assign it to "baseline date" field of each initiatives.
As an example -
Maximum Actual end date of of Epic 1 and 2 will be assigned as baseline date of INT-1.
Maximum Actual end date of of Epic 3 and 4 will be assigned as baseline date of INT-2.
and the loop goes on till there is end of initiatives.
Any support will be helpful.
Hi @Dwaipayan Dey -- Welcome to the Atlassian Community!
There are a few things to check for your rule, as you have shown it...
When you note the field "actual end" is that a custom field you added, or do you mean another field? Whatever your field is, please use this how-to article to learn if your field is supported by automation rules, and what the exact smart value name is: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/
Next, you do not show the JQL for your rule, and I suspect it has a problem. Let's clarify a bit...how are you trying to run this rule: triggered based on the Initiatives or something else?
If it is based on the initiatives, then:
Hi @Bill Sheboy , Thanks for your prompt reply.
Regarding your questions -
1. "Actual End" is a custom field added which can show only dates.
2. Trigger for this is - weekly scheduled run (Once in a week) or a manual run.
To Simplify here is the flow -
Scheduled Run/Manual Run -> search for initiatives -> search for epics under each initiatives -> group epics under each initiative -> get the max date (custom field - actual end date) from epics and apply it to "baseline date" (Custom field of initiative) of parent initiative -> Loop the process till all initiatives are updated with correct baseline dates.
Thanks for that information.
If your scheduled trigger is indeed using JQL to only find the Initiatives, using the Lookup Issues on the epics for each Initiative should work. As are reminder, the branch to parent is not needed.
What is not happening as you expect, as your rule could be: