Start and finish date of an epic with the max date of the tasks related

[Angelica Hernandez]

Hello,

For a project I want to set the start and finish date of each epic considering the max date of the tasks related. 

I really appreciate ideas to set a rule.

Regards

[Bill Sheboy · Accepted solution]

Hi @Angelica Hernandez 

Are you asking how to do this with Automation for Jira rules?  If so...

I can think of a simple way to do this which does not handle all possible scenarios, and a more complicated way: The simple way assumes Start Dates only get earlier for tasks, not later, and that Due Dates only get later, not earlier.

With the simple way, you use one automation rule.  In my example below, I assume you mean Due Date as I do not see a Finish Date field in my Jira instance.  If you have a Finish Date field in your Jira instance, please substitute that field name.

• Trigger: field value change for either Start Date or Due Date by an Edit operation
• Condition: issue type is not epic
• Branch: on epic (parent)
  
  • Advanced Compare Condition: {{triggerIssue.Start Date}} is not empty
  • Advanced Compare Condition: {{triggerIssue.Start Date}} is less than {{issue.Start Date}} (the epic)
  • Action: edit Start Date to the {{triggerIssue.Start Date}}
• Branch: on epic (parent)
  
  • Advanced Compare Condition: {{triggerIssue.duedate}} is not empty
  • Advanced Compare Condition: {{triggerIssue.duedate}} is greater than {{issue.duedate}} (the epic)
  • Action: edit DueDate to the {{triggerIssue.duedate}}

The more complicated way uses two rules and can handle the dates changing in either direction, earlier or later.  Please let me know if you want me to post that information.

Best regards,

Bill

[Angelica Hernandez]

@Bill Sheboy , thank you so much! is Exactly what I needed.

Thank you for your complete responde, very useful 

[Bill Sheboy]

I am glad to hear that helped you.  Please consider marking this question as answered; that will help others in the community find solutions faster.  Thanks!

[Omer Agami]

Hi @Bill Sheboy 

How would you adjust that to the complicated solution that handle changing to earlier and later?

[Bill Sheboy]

Hi @Omer Agami 

Since this question was posted in April 2021, Atlassian has improved the Lookup Issues action to include all fields.  It is now much easier to find the min/max and update the parent epic, and eliminate any edge cases.  Here is an example for start date:

• trigger: start date changes for an issue
• condition: issue is a child of an epic
• action: lookup issues with JQL to find all sibling issues with the same parent
• branch: on the parent
  • action: edit the parent's start date to {{lookupIssues.Start date.min}}

Kind regards,
Bill

[Omer Agami]

Hi @Bill Sheboy 

Thanks a lot for the idea, I understand the logic of the flow. 

I wanted to ask if I have a few epics in a version (and of course I want every epic to be presented with its dates), I didn't understand how to generate the action section, how to refer to the proper JQL.

Thanks a lot!

[David Ashlock]

Hi @Omer Agami , here is what I used:

parent = {{triggerIssue.parent}}

[Игорь Титов]

@Bill Sheboy 

Hello! I've used your latest example! its working 

But sometimes I have an error, because some issues have no parent.

How could I avoid this situation? 

I think this should be mentioned in the action section 

• action: lookup issues with JQL to find all sibling issues with the same parent

But I do not know how to write a query correctly. 

[Bill Sheboy]

Hi @Игорь Титов 

This is a very old thread, and so I recommend creating a new question.  That will ensure the maximum number of people see it to offer suggestions.  When you post your question, please include images of your complete rule and the audit log details showing the rule execution.  Those will provide context to help explain what you are observing.

Until we see that...

From the example rule I suggested earlier, there is a condition to check if the trigger issue has a parent before proceeding.  Did you include that condition in your rule?

Kind regards,
Bill

[Игорь Титов]

Hi! 

This is my rule now 

And my error