How to sum up logged work

Denis_7nuibu

Hi together,

is there any way to consolidate spent time in an epic.

1st Problem

I tried to branch the automation by using For epic (parent) and inserted "{{issue.subtasks.aggregatetimespent.sum}}" but that always reply 0. Even if I see by using the Rest Api that there is a value in it.

2nd Problem

Even if I have the summarized time spent. Where to store it? I want to have it visible in the time tracking field available in my epic.

 

So I want to realize by automation the checkbox Jira introduced for standard issue types "Including Subtasks" but here as "Including standard issue types"

 

//edit 02.11.2021

I tried even more potential smart values, and all reply "0". I tried it now with the action Lookup issues, and for Story Point sum it works.

 

All reply 0:

{{lookupIssues.worklog.timeSpentSeconds.Sum}}

{{lookupIssues.aggregatetimespent.sum}}

{{lookupIssues.timespent.sum}}

{{lookupIssues.timetracking.timeSpentSeconds.sum}}

 

Denis_7nuibu

I found a solution but it's quite hacky.

 

I use the action "Send web request" with the following values:

.../rest/api/latest/search?jql=%22Epic+Link%22%3D{{issue.epic link}}&fields=aggregatetimespent

Headers:

• Field1: Authorization
• Field2: Basic base64encoded_e@mail.de:API_TOKEN (you must encode e@mail.de:API_TOKEN as base64 string)

HTTP method: GET

Web request body: empty

Wait for response:

•  Delay execution of subsequent rule actions until we've received a response for this web request -> "check"
• Continue running the rule even if the request response is not successful (i.e. non-200 response) -> "false"

 

After a successful request you can use the following statement to sum up all aggregates timespent of standard issue types except epic. So it's only working for items like story, bug, ...) But that's no problem because you can check include subtasks in the standard issue type and then the value is included in aggregatetimespent.

{{webhookResponse.body.issues.fields.aggregatetimespent.sum}}

 

Quite hacky and sadly you need login credentials from a user for that. But I didn't found any other way, because I can't access aggregatetimespent by smart value.