How to change timespent with an automation rule?

[Markus Döring]

I'm using JIRA Time Tracking and want to change timespent / timeestimate in an automation rule.

When using Edit Issue with the following JSON, i get the error message 'unknown field ignored' when the rule is executed:

{
   "fields": {
      "timeestimate": "0"
   }
}

How can I solve this?

[Nick Menere]

Hey Markus,

Thanks for using Automation for JIRA.

The time tracking fields aren't straight forward. The reason you are getting that message is the timetracking is a conglomerate field (represents multiple values) - timeestimate is just part of the parent field.

To change the estimate you have use the following format in advanced:

{
    "fields": {
        "timetracking": {
              "originalEstimate": "10",
              "remainingEstimate": "5"
        }
    }
}

I tested out with the following rule and it worked:

image2016-12-23 12:30:16.png

Hope this helps.

Cheers,
Nick

[Markus Döring]

Thanks, that brings me forward one step in settinh original and remaining estimate.

I still cant set the Logged Work (timespent).

Error: Setting the Time Spent directly is not supported. (timetracking)

Thanks for help!

[andreas]

Hi Markus,

You can add worklog with the following JSON: 

{
  "update": {
    "worklog" : [
      {
        "add": {
          "timeSpent" : "6m"
        }
      }
    ]
  }
}

Please ensure that the "Log Work" field is on the appropriate edit screen in JIRA.

Here's an example rule:

Project automation - Your Company JIRA 2016-12-23 16-20-17.png

Cheers,

  Andreas

[andreas]

You can also combine the two:

{
"update": {
    "worklog" : [
      {
        "add": {
          "timeSpent" : "6m"
        }
      }
    ]
  },
    "fields": {
        "timetracking": {
              "originalEstimate": "10",
              "remainingEstimate": "5"
        }
    }
}

[Markus Döring]

That works for me.

Thanks a lot!

[Anthony Wijnen]

@Nick Menere thanks for your answer.

I'm also using JIRA automation and have configured it as to set the remaining estimate to 0 once the issue transitions to a certain state.

For that I use the following the "Edit field" action and in the "advanced" section I pass on following JSON:

{
   "fields": {
    "timetracking": {
      "remainingEstimate": "0"
    }
  }
}

However this updates both the remaining and the original time estimate – while it's important for us the original stays in tact.

Any suggestions on how to change only the remaining estimate?

Thanks in advance,

Anthony

[Nick Menere]

Hey Anthony,

to do this you will need to set the original to the current value (weird but that is how the Atlassian Rest api works):

{
   "fields": {
    "timetracking": {
      "remainingEstimate": "0",
      "originalEstimate": "{{timetraking.originalEstimate}}"
    }
  }
}

Hope that helps,

Cheers,

Nick

[SebPolytech]

Hello @Nick Menere,

Actually, when I try to do this on issue with 2 decimals (i.e original estimate = 0.61h), it converts it to a 1 decimal value (0.6h). Do you know if there's a way to have the exact same value?

Please do not ask why we are using such accuracy in our estimation, I'm already fighting with my management for that :)

Btw, there is a typo in your answer : 

timetraking.originalEstimate -> timetracking.originalEstimate

Thanks & Regards.

[Nick Menere]

Apologies Sébastien, this reply slipped through.
I believe this is Jira that is rounding this.

Can use the value:

{{#debug}}
{
  "fields": {
    "timetracking": {
      "remainingEstimate": "0",
      "originalEstimate": "{{timetracking.originalEstimate}}"
    }
  }
}
{{/}}

That should tell us whether we are passing the right value and Jira is doing the rounding. This will log the value in the audit log.

If Jira is doing the rounding we may have to resort to converting this to minutes but that will not be pretty. E.g.

{{#debug}}{{#=}}{{timetracking.originalEstimate.replace("h", "* 60 +").replace("m", "")}}{{/}}m{{/}}

(I haven't tested the above.....)

Hope that helps.

Cheers,

Nick [Automation for Jira]
Co-founder

[Priyanka]

Hello, @Nick Menere  @Markus Döring  I want automation for JIRA rule to update a field "efficiency" with the value  ORIGINAL ESTIMATE - TIME SPENT. Can anyone help here?

Regards

Priyanka 

[Alexander Pappert]

Hi,

I need to remove the logged work.

Is there a similar Option to set it to zero?

{ "update": { "worklog" : [ { "add": { "timeSpent" : "6m" } } ] } }

{ "timeSpent" : "0m" } did not work

also { "timeSpent" : "-6m" } did not work

[Michael Mityushin]

I created a template rule for adding LogWork, but the actor is specified, and every time this rule is triggered, LogWork is written to the actor and not to {{initiator.key}}.
How can I change the value of the actor field to {{initiator.key}}, or currentUser()?

[André Bunte]

Hi @Nick Menere ,

I created my rule as descripted above:

{
   "fields": {
    "timetracking": {
      "remainingEstimate": "0",
      "originalEstimate": "{{timetracking.originalEstimate}}"
    }
  }
}

 But I still get the same message like @Markus Döring
 'unknown field ignored' when the rule is executed.

[Jack Daniel Morilla]

here is what I did:

{
"fields": {
"timetracking": {
"originalEstimate": "{{issue.timetracking.originalEstimate}}",
"remainingEstimate": "0m"
}
}
}

[Markus Döring]

Using the flowing Plugin:

https://marketplace.atlassian.com/plugins/com.codebarrel.addons.automation/cloud/overview

[Ignacio Pulgar]

Do you mean through a JIRA Service Desk automation rule, or through calling the API?