JIRA JQL - Find issues with more than X days in Status

Question

I want to show all issues where it has been in a current status for more than X days - is this possible?

We have this workflow: Registered => Analyze => Planned ... etc. The ticket can be in Registered for 3 weeks and it can be 3 weeks in Analyze without any problems.

Currently I am using this JQL to show tickets that have been more than 3 weeks in Analyze:

project = MyProject AND status = Analyze AND created <= -6w

This is wrong due to so many reasons and it does not look at the time in the current transition state - nor does it take in to account that it can be pushed back from Planned to Analyze and then allow a new 3 weeks analyze period.

Is the above possible to filter in JIRA? I don't have the possibility to use the JIRA REST interface - only the builtin JQL.

I am running with JIRA version 6.4.5.

Answer 1

You should be able to get there using the JQL CHANGED operator. Its documentation is available here.

Your query would look something like this:

project = MyProject AND status = Analyze AND status CHANGED BEFORE -3w

Answer 2

 project = MyProject AND status = Analyze and not status changed during (-xd,now())