Smart values for jira time tracking

[Lara Sousa]

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]

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]

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

[Laurie Sciutti]

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

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