Workflow duration based automation

[Rachel Soyode]

I'm trying to create an automation to change the colour of tickets that have been in a column for an extended duration. 

i.e. in review code, if the ticket has been there for over a week then it's orange and over a sprint it's pink and more than 2 sprints it's dark red. 

I can't figure out where time based/workflow based automations sit in the automation tool. 

Any help would be greatly appreciated! Thanks 

[Marc - Devoteam]

Hi @Rachel Soyode 

There are no time/workflow based actions in the automation tool.

You would need to use conditions, based on JQL statements.

example on a JQL:

status = "particular status" and status was "particular status" before startOfDay(-7)

This will give all issues in "particular status" now and also a week ago

[Trudy Claspill]

Adding to this, the above query would get you an issue that is currently in that status now, and was in that status more than 7 days ago, but it doesn't ensure that the issue stayed in that status for those 7 days.

If you want to ensure the status has not been changed for the past 7 days you would need to do this:

status = "particular status" and not status CHANGED after startOfDay(-7)

I'm not sure how to accomplish this requirement:

over a sprint it's pink and more than 2 sprints it's dark red. 

The CHANGED operator can help you figure if an issue status has remained unchanged over a period of time, but not over a series of sprints. You would have to know the dates associated with the current and last sprints, and it is quite challenging to get information for the sprints to which an issue has been assigned.