Update EPIC date from latest SPRINT in the epic

Question

1. Need to update the epic date with the last date of the last sprint completed.

is it possible to automate that date of the epic is updated with the last completed

sprint date ( in the EPIC).

any possibility with automation or script achieve this >?

siva_xx9qs1 · Answer

@John McKiernan1

Thanks John,

im working on a extended scenario , this is one part.

will reachout once i try a few tweaks..!

John McKiernan1 · Answer

Hey Siva,

apologies for only getting to your question now. John from Automation for Jira here. This should be possible without scripting so you should have two good options to consider.

I have attached a screenshot of what your rule might look like below.

The smart value you will need for the 'edit issue' action at the end is: {{issue.sprint.enddate.jiraDate}}

I hope that helps but let me know if you have any issues with it!

Cheers,

John

Leo_e8op2r · Answer

Hey @siva

I haven't written any script like this, but this is possible I guess( may be you need to write quite huge script)

you can put this script in custom listener or in post-function of Closed transition of Story workflow so that every story closed event/action your script will execute

I'm not a efficient code writer, but your code may flow like below

1. Get the epic value of currently closed story

2. Run a JQL in script to find out the child issues of that particular Epic

3. Check whether all issues of epic is in Final/Closed state

4. If TRUE

4.1 Get the sprint value of currently closed story from sprint field

4.2 Get the End date of the sprint

4.3 update Epic's End Date

5. Else

5.1 Exit

BR,

Leo