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 May 8, 2020

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

dave 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
TAGS
AUG Leaders

Atlassian Community Events