How do I auto log time taken for an issue to go from one status to the next?

Andreas Knecht Community Champion Oct 10, 2017

Is there a way to achieve auto time logging using this add-on? I want to automate time logging and tracking such that a “timer” starts when an issue transitions to “In Progress” and stops when it transitions to “Done”. At the end of every month, I can then run time reports for management.

1 answer

1 accepted

Accepted Answer
0 votes

This is a pretty advanced usage but it can be done with Automation for Jira.

It is possible to do this using 2 rules. The first rule stores the first date on the original transition and then the second rule calculates the time difference and logs the work on the second transition.
Your first rule would like:

  • On Issue transition
  • If the status = "In Progress"
  • Set an entity property on the current issue for key "timestamp_in_progress"
    {{#now}}toMinutes{{/}}

The second rule would like:

  • On issue transition
  • If the status = "Done"
  • Log work using the "Edit action" and this in the advanced section:
    {
      "update": {
        "worklog" : [
          {
            "add": {
              "timeSpent" : "{{#=}}{{#now}}toMinutes{{/}} - {{issue.properties.timestamp_in_progress}}{{/}}m"
            }
          }
        ]
      }
    }

This will add how many minutes elapsed between the 2 transitions.

Here's screenshots of the 2 rules:

rule1.png

rule2.png

Hi @Andreas Knecht

Thanks for detailed description of the rules. But it seems that time is not logged after first transition occurred, and we're seeing "No time logged" on issue page. 

Are these rules only calculating time after final transition to "Done"? 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

135 views 6 8
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you