Update EPIC date from latest SPRINT in the epic

[siva]

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 >?

[John McKiernan]

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 

[siva]

@John McKiernan1 

Thanks John, 

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

will reachout once i try a few tweaks..!

[Leo]

Hi @siva,

You can try out custom listener for the event "SprintClosedEvent" if you use ScriptRunner plugin and update the epics Updated Date through listener script

Regards,

Leo

[siva]

@Leo 

Thanks for the prompt response,

YES..!! we do use ScriptRunner Plug in.

and let me elobrate the whole scenario.

A.  I need to update the (End date) of the EPIC with the end-date of the Sprint.

REQUIREMENT :

1. When the last story in an EPIC is Closed, the END DATE of sprint in which the story is.

should be updated in the EPIC ( end date)

Any Possible way with Script.??

[Leo]

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