Custom field + SLA + Calculation of running time in a status

[Loic]

Hello,

Here is what I want to achieve:

1- I made an SLA that calculates the time between STATUS A (Commande manuelle) and STATUS B. I set the timer at 1 minute in order to be breached the fastest possible.

It gives me the time in status A, but in hours, but I want it in Days.

So maybe with an automation, that will be triggered every day, I can get the HOURS converted in amount of DAYS. The automation rule will stop when the Status change for STATUS B.

2- I made a Custom field "Time in status A".  (issue.customfield_11843) in which the amount of Days will be presented.

Here the rule (That does not work):

Trigger: When:Schedule = Every 5 minutes (i put 5 minutes in order to test the rule) with JQL = status = "Commande manuelle"

THEN:

Edit issue Fields: Time in status 

I have put that formula to calculate the time in status: {{now.diff(issue.customfield_11843).days}}

Does not work. Would you think that its possible to do?

Thanks

[Vishal Biyani]

@Loic 

Hours to days

You will need to use a formula like this: {{#=}} {{issue.customfield_11843.asNumber}} / 24 {{/}}

if <your field> is not a number, then you will need to use .asNumber

Time in status formula

Try 

{{now.diff(issue.customfield_11843.asNumber).days}}

if this does not work please share the audit log to understand where the rule is failing.

Question

if you want to calculate the status for transition from Status A to Status B, why don't use monitor for status transition. 

On Transition to status A, save the time in custom field when the issue came in status A

On Transition to status B, calculate the time difference.

[Loic]

Thanks for the answer. What you propose in your Question, will not give the result that I need.

I want like a timer when a issue stays at at Status A. So it's not a static data it change all the time as time goes by (Date now - Date Stamp when transition to status B).

So for that, I guess that I need a Schedule in the automation (like each day). But it does not work, and it gives me a warning.

Each 5 minutes (for testing)

when status is on: Evaluation non débutée

Edit that field:

Customfield_11893 = Time in status

[Loic]

EDIT: customfield 11893 = Time stamp when issue transition to statuts EVALUATION NON DÉBUTÉE

[Vishal Biyani]

@Loic 

The reason rule is not working is, Scheduler needs either a JQL or lookup query post the scheduler is triggered.

in the current set-up if condition has nothing to act on as no issues have been fetched.

Therefore, first a JQL query needs to be finalized based on which scheduler can get the issues that it needs to act on.

Timer like functionality is not available out of the box in JIRA.