Need help with Automatization

Question

My trigger works on changing the task status. After which it should edit the task's custom field. I need the custom field to indicate the time it was in the "Sold" status. I don't understand how to implement this correctly.

Bill Sheboy · Answer

Hi @Лёня Криволапов

It seems you are duplicating your question from here:

https://community.atlassian.com/t5/Automation-questions/Need-help-calculating-time-in-each-status/qaq-p/2934650

Kind regards,
Bill

Лёня Криволапов · Answer

Thank you very much for the answer, I did it a little differently. My task was to display the time spent in each status approximately like this (3 days 2 hours 11 minutes). I created a trigger that, with any change in status, wrote it down in the custom field "Last status change". Command: {{now}}

I created a trigger and a custom field for each state, but got stuck on the calculation.

Command:
{{issue.Time of entry into new status.diff(now).days}} days {{issue.Time of entry into new status.diff(now).hours.mod(24)}} hours {{issue.Time of entry into new status.diff(now).minutes.mod(60)}} minutes

The output is (1 days hours minutes) shows only days

Please tell me where I went wrong.
And I apologize that my screenshots are in Russian, I hope this does not interfere.

Jovin · Answer

Hey @Лёня Криволапов

There are a couple of ways to achieve this, I'll only cover the one that doesn't involve using APIs and parsing information like that.

* Setup a new custom field (you can name it differently):* Date Sold: The date the task entered the sold status

* Setup the workflow to populate this information:* Create a Post Function on all transitions INTO Sold* Choose Update Issue Custom Field and then choose "Date Sold"
* Set the value to %%CURRENT_DATETIME%%

* Update your existing automation rule to now calculate the difference:* Set the field "Time in Sold" (or whatever you've named it) to be the smart value below, note the the minutes|hours|days|weeks indicates you should choose the appropriate time span you want to use
* {{now.diff(issue.Date Sold).minutes|hours|days|weeks}}