Smart values for jira time tracking

Question

I'm setting up an automation in Jira and I need the smart value or somehow get the value of the "Time tracking" field from Jira and not the history work log, because the field also considers the sum of the time records of the tasks/ sub-tasks, and I need it.

I'm currently using {{timetracking.timespent}}, but it only returns the work log of the story and not the sum of the work log of the tasks in that story either.

Is there any way to solve this problem?

Dan Tombs · Answer

Hi @Lara Sousa

@Laurie Sciutti has attached a good YouTube video.

I wrote an article which explains how you can sum up story points to any point in the hierarchy. While it talks of story points I actually started this use case with time spent etc. you would just need to replace the queries for time spent instead of story points.

https://community.atlassian.com/t5/Automation-discussions/Rolling-up-story-points-further-then-an-epic/m-p/2390431#M310

Laurie Sciutti · Answer

You might also try using the "lookupIssues" smart value...

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues

Laurie Sciutti · Answer

Hi @Lara Sousa ~ this might help:  How to sum up story points from sub-tasks to parent issue using Jira automation - YouTube