Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to write a JQL to find issues status Not changed for more than one week?

Beaky Chan December 8, 2015

I want to find out any JIRA issues that the status has not being changed for more than a week. I tried below but it crashed my Kanban board with timeout issue

status="In Progress" AND not status changed after -1w

3 answers

1 vote
James Strangeway
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 8, 2015

Try just doing the following

not status changed -1w

 

0 votes
wasperlab
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 8, 2020

project=XXX AND not updated >= -7d and status not in(Accepted,Discarded,Deleted,Deployed)

dave
Contributor
March 3, 2021

Updated does not mean that status hasn't changed. That's not what's being asked. I can add a comment and the issue has been updated.

0 votes
Kian Stack Mumo Systems
Community Champion
December 8, 2015

You could try this JQL: 

 

status="In Progress" and NOT status changed BEFORE 1w 

Beaky Chan December 11, 2015

I am using Jira v6.3.12 but this JQL doesn't work. If I use this query in my Kanban board, it even timeout the whole board.

Suggest an answer

Log in or Sign up to answer