Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Look up issues Smart value time tracking

Hi Admins,

I using look up issue smart value in an automation which makes team daily report on the performed tasks. I use
{{#lookupIssues}} _<{{url}}|{{key}} {{summary}}>_ {{"\n")}}{{/}}
and get alert:

(for example)
GPDN-1 Common lib utils for plugins: converters, etc. In Progress
GPDN-2 Support to clients with message Done

Now i would like to display information about the time spent on these tasks. Can you help me with it?

1 answer

1 vote

Hi @Victoria Kramarenko and welcome to Community!

You can use several different smart values:

  • {{issue.timetracking.timespent}} to get time spent in a pretty format such as 1d 4h
  • {{issue.timetracking.timespentseconds}} to get time spent in seconds such as 43200
  • {{#=}}{{issue.timetracking.timespentseconds}}/60/60{{/}} to get time spent in hours such as 12

Hope this helps,

- Manon

Hi Manon!
It should be continued of string {{#lookupIssues}} _<{{url}}|{{key}} {{summary}}>_ {{"\n")}}{{/}}, right?
Sory, but i 
can't figure it out by myself.

I use lookup issues function

worklogAuthor = *account id* AND worklogDate >= -1day

and then create variable

{{#lookupIssues}} _<{{url}}|{{key}} {{summary}}>_ {{"\n")}}{{/}}

fo sending a message with variable value in Slack.

I tried replace variable with

{{#lookupIssues}} _<{{url}}|{{key}} {{summary}}>_ {{"\n")}}{{/}} {{#=}}{{issue.timetracking.timespentseconds}}/60/60{{/}}

and it didn't work

Can you try this one?

{{#lookupIssues}} _<{{url}}|{{key}} {{summary}}>_ {{"\n")}} {{#=}}{{timetracking.timespentseconds}}/60/60{{/}}{{/}}
Like Victoria Kramarenko likes this

Thank you!
It works for all time spent, but should only display the task time for today

I don't think you can get time spent today out-of-the-box, you would need an app like Tempo Timesheets to get that value. Are you using Tempo?

Suggest an answer

Log in or Sign up to answer
Site Admin

Atlassian Community Events