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

Question

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_2pr07j · Answer

@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.

Loic_9eb2s6 · Answer

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

Loic_9eb2s6 · Answer

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