Update all logged work from from all types of issues downwards an epic into an epic field
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:
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)
The value for the work log: {{#=}}{{lookupIssues.timeSpent.sum}}/3600{{/}}
2.- When the work logged is in a subtask from an epic child:
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!!