Automation when there has been no change on a ticket after period of X days

[andrew.bassett]

Hey community - looking to get some form of rule / automation to put tickets into a stale / aged state when there has been no change to the ticket in e.g. the last 30 days. 

Looking at project automation options, this doesn't seem to be in place. 

I do know you can create a step in a workflow where a lack of action can move into a status, but was wondering if there could be a form of alerting on issues not touched for a while without changing the workflow status. 

[John Funk · Accepted solution]

Hi Andrew

You can base it on a JQL condition that looks something like:

project = ABC and status = "In Progress" and status changed to "In Progress" before startOfDay(-5)

That query would show cards in the In Progress status for more than 5 days

[andrew.bassett]

Added a filter to my Kanban board with the JQL - worked well, just changed to last updated. Should have figured this out for myself - thanks for the help! 

[John Funk]

Great! Glad that worked for you!

[Katherine Lisman]

@John Funk , I tried this with a different status and I need assistance. I would like to know when an issue was not moved out of the "Open" status in 3 or more days. Basically, I want to be sure that we change the status of the issue within 3 days and if not, then I want to create a notification that the ticket has been sitting open for 3 days. 

I used:

project = "Access Control" AND status = Open and status changed to Open before startOfDay(-3)

And I get no issues returned. I only have two open, so not sure I'm actually meeting the criteria. Do you have any suggestions for how I can test?

Thank you!

[John Funk]

Hey Katherine,

To test it, drop the -3 to -2 and see if anything shows up. And if not, then to -1. 

If things show up as you drop them, then you know it is working. And you also know that you just don't have any that are more than 3 days old. 

Once you are sure the JQL is correct, then you can create a Scheduled Trigger in Automation for Jira to send an email each day for the issues that are over the limit. 

[Katherine Lisman]

Thank you, @John Funk ! I may wait a day or two before trying. I'll post back here with my results.  

[Katherine Lisman]

@John Funk ! It worked!!  THANK YOU SO MUCH!!!  :o)  

[Damian.Ligudzinski]

HI, I'm completely new to JIRA. What is the "trigger" before I apply this JQL rule?

[John Funk]

Hi @Damian.Ligudzinski  - Welcome to the Atlassian Community!

Can you be more specific in your question? 

[Damian.Ligudzinski]

@John Funk - Thank you.

I want to highlight tasks in the current sprint that were not updated for the past 12 days. I understand I need to use JQL condition but I'm not too sure how to set it up. I was referring to a "trigger" based on the image below. I don't know how the "rule details" should look like on the left side of the image.

[John Funk]

It looks like you have the rule set up correctly, it's just the JQL that you need to get right. You will need something like project = ABC and updated < startOfDay(-12)

[Damian.Ligudzinski]

Thanks @John Funk I have this JQL running well for ALL tickets in my backlog. But I want the rule to run in my correct sprint "P050 Sprint 10". How can I add it to my JQL rule? (I have zero coding experience)

[John Funk]

Try adding AND Sprint = "P050 Sprint 10" to the end of your JQL. Then click the Validate query link to see if it is returning what you think it should. 

[Damian.Ligudzinski]

It worked! Thank you so much @John Funk 

[John Funk]

Great!

[Michael Gomes]

@John Funk Hi John, I am new to Jira and currently learning it. Is there a way to trigger for example an issue that has been assigned to someone but has not been touched for a couple of days? Please advice. In the mean time I am trying the steps above to see if I can figure it out my self. 

Thank you in advance

[John Funk]

Hi Michael - Welcome to the Atlassian Community!

First, it is always best to create a new question so more people will see it. Otherwise, only the people on the thread will see the question and there are less people to help. 

Having said that, you can try a JQL like:

project = ABC and updated < startOfDay(-3)

This will show issues that have not been updated in the last 3 days for project ABC