It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Update EPIC date from latest SPRINT in the epic

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

 

2 answers

0 votes
Leo Community Leader Sep 05, 2019

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

@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 Community Leader Sep 05, 2019

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

Like siva likes this

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

Screenshot at Sep 10 11-40-47.png

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

Cheers,

John 

@John McKiernan 

Thanks John, 

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

will reachout once i try a few tweaks..!

Like John McKiernan likes this

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

314 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you