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.

Get started Tell me more

Atlassian Community about banner

4,459,205

Community Members

Community Events

176

Community Groups

Community
Products
Jira
Jira Core Server
Questions
How to write a JQL to find issues status Not changed for more than one week?

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

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

Try just doing the following

not status changed -1w

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

0 votes

You could try this JQL:

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

Jira Core Server

TAGS