Update all logged work from from all types of issues downwards an epic into an epic field

Aarón Palazón Barber March 14, 2024

Hello world! I spent a lot of time developing this issue because there is a lot of information about sum logged work into an epic and there are some problems when the work logged is edited o deleted from epic children or epic children subtasks. I have found a great solution and for me and it is quite simple to implement if you use a custom field from an epic to have this all logged work updated so I want to share it. I hope it will be useful for all of you. The automation has to be divided in two cases: 


1.- When the work logged is in an epic child: 

JiraRuleChildren.png

The JQL for lookup the issues is: project = YOURPROJECT AND (issuetype = Sub-task AND parentEpic in ({{triggerIssue.Epic Link}}) or "Epic Link" = {{triggerIssue.Epic Link}})

The Edit issue field: (here you have to select your own custom field)

JiraLookupIssues.png

The value for the work log: {{#=}}{{lookupIssues.timeSpent.sum}}/3600{{/}}

2.- When the work logged is in a subtask from an epic child:

JiraRuleSubtasks.png

The JQL for lookup the issues is: project = YOURPROJECT AND (issuetype = Sub-task AND parentEpic in ({{triggerIssue.parent.Epic Link}}) or "Epic Link" = {{triggerIssue.parent.Epic Link}})

The edit issue field: is the same as shown before with the same value.

 

I hope it helps!!

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events