Transition when time in status is larger than a parameter

[Martina]

Hi all!

I've been trying to create a rule and I got stuck, was hoping to receive some help / feedback from the community.

This is what I want to do:

When an issue has been for longer than 3 weeks in a status, transition to the next status.

I already added the "time in status" field to the issue in the "description fields", but I don't know how to: 

1- track the time only for one status in the process

2- create a condition for when time in that status is longer than 3 weeks, transition to the next status

Thank you!!

[Valeriia_Havrylenko_SaaSJet]

Hi @Martina  👋 

1.  To track the time only for one status in the process, i guess Time Between Statuses (developed by my team) will be an option for you. You can track time only for one status in add-on as well. 

To detail the calculation conditions you should 

• select the first/last transition to/from status

Another add-on for this is Time in Status for Jira Cloud. Add-on allows you to measure and visualize the time spent in each status, such as "Open," "In Progress," "In Review," and "Closed," and provide 7 types of reports to help you identify areas for improvement. Add-on also developed by my team.

Add-ons have a 30-day free trial version and free up to 10 users. 

2. To create a condition for when time in that status is longer than 3 weeks, transition to the next status

You can do the following :

1. When : Scheduled issue (for example each day) and use the following JQL condition 

status = "ORDERED" and not status changed before 7d (add more conditions here
if wanted. You can even use 'during' to specify a period of time)

     2. Then fire up an action (like transition to the next status). 

Please, let me know if you have any questions

Hope it helps 😌
Valeriia

[Brandon Raymaekers]

Hi Martina

I'm not 100% sure what you mean, is it when an issue is in a status for multiple weeks or is not updated for 3 weeks in that status? 

If not updated you can always make an automation rule that checks every day: 

updated <= -21d every 1 Days and then transition it to the status of your choice.

if you need help with the time in status field this url will help: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Time-in-Status-in-Jira-What-is-it-and-how-to-track/ba-p/2275979#:~:text=You%20can%20activate%20the%20Days,administrator%20or%20Jira%2Dadministrator%20access.

Hope this helps,

Kind regards

Brandon Raymaekers

[Martina]

Hi @Brandon Raymaekers !

thanks for replying. I tried what you did and created the code below. However, it's moving to the next stage everyday at 9:00am (so it's not considering the "Issue matches JQL" condition. 

Any clue what could be wrong here?

[Bill Sheboy]

Hi @Martina 

You are missing the minus sign in that JQL that Brandon suggested, and so you are instead checking 21 days in the future.  :^)  Please try adding it.

Kind regards,
Bill

[Martina]

@Bill Sheboy Whoops thank you!!