Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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. 

2 answers

1 accepted

1 vote
Answer accepted
John Funk Community Leader Mar 08, 2021

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

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! 

Like John Funk likes this
John Funk Community Leader Mar 08, 2021

Great! Glad that worked for you!

@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 Community Leader Mar 09, 2021

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. 

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

Like John Funk likes this

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

Like # people like this

@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 Community Leader Mar 10, 2021

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

Like # people like this

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events