Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Automation to roll up Sprint End date and Story Points to Epic (Parent)

Devender Singh October 11, 2023

Hi All, I am trying to create an automation to roll up Last Sprint End date to the Epic as End Date and Sum of child story points.

In Automation Log the rule runs without errors, however no change in Feature.

For Testing purpose I have manual trigger, however I plan to change it to scheduled once every day.

NOTE: This is JIRA Server edition

JIRA Automation Feature Roll up.png

3 answers

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 11, 2023

Hi @Devender Singh 

As @Tim C noted, you were trying to use the {{lookupIssues}} smart value and the Lookup Issues action is not available for your version of Jira Server.

Two other possible work-arounds for your scenario are:

  • Create JQL to gather the issues needed, and call a REST API function with the JQL to search for them...using the Send Web Request action.  Then you can get the value from the response.
  • Use the bulk-handling issues feature (e.g., scheduled trigger or branches) with the {{issues}} smart value.  As you want this value to edit an issue, you will need to structure the rule in such a way that you can branch to the issue which needs an edit, and/or use multiple rules.

There are other community posts on doing what you ask, and so if you search you may find additional details on these techniques.

Kind regards,
Bill

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 4, 2023

Hi @Devender Singh 

I am following up to check if the responses answered your question.

Thanks!

0 votes
Colton.Kosicek October 11, 2023

Can you use variables in your older version?  You can set the trigger to be daily but will cost you an automation to potentially run for every issuetype if you don't have exit loops so it will burn through a lot more unnecessary cycles.  i use sprint change as i have multiple cascading automations in the same automation that trigger. 

Sprint value changes on story - update story due date and now check the "parent" due date and update based on the child's oldest.  This stops it from having to care about every child issue in the same automation and just checks if the change on the child would impact the parent.

I have a very similar automation that updates the level 2 parent in our environment as well
automationVariable.JPG

MinusTwoWeeks 

{{DueDatebasedonSprint.minusweeks(2)}}

AutomationPart2.JPG

0 votes
Tim C
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 11, 2023

Hi @Devender Singh 

I think you're missing the important step to actually do the "lookupissues" action.

If you're triggering from the Epic itself - then you'll need to use JQL to find the items which sit under the epic .... e.g.

"Epic link" = {{issue.key}} 

If you also want to include sub-tasks in your results then you'll need something like this ...

Screenshot 2023-10-11 145055.png

I hope this helps?

Devender Singh October 11, 2023

I do not see that option. We are on server Jira v8.22.2 is the reason ?

Tim C
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 11, 2023

Yeah, apologies ... looks like this feature is only available on:

  • In Automation For Jira (A4J) 9.0.1 and in Jira 9.11.0 (or Jira Service Management 5.11.0)
  • Only for Data Center customers (The Server license does not include this feature)

To benefit from this feature you can:

  • either upgrade A4J to the latest version on any Jira DC version from 8.20.0, via the Settings > Manage Apps > Manage Apps* page
  • or upgrade Jira to 9.11.0 (or Jira Service Management to 5.11.0)

More info ...

https://jira.atlassian.com/browse/JIRAAUTOSERVER-53?focusedId=3333220&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-3333220 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events