JQL to show all issues that have been in development longer than 2 weeks

[Felipe Seiber]

I'm looking for a way to create a filter that will list all tasks that have been in development for more than 2 weeks. 

I have tried creating a new filter "in development for 2 weeks”" doing the following:

status changed to "In Development" before -14d  AND status = "In Development"

However, I have noticed that if you move something into development, then move out back out, then move it back in to dev 2+ weeks later it will still show up as “in development for 2 weeks”.

Is there any way to have this filter show only tasks that have remained in the "In Development" status for 2 weeks and not count previous status changes?

[Felipe Seiber · Accepted solution]

I ended up using the following:

status changed to "In Development" before -14d  AND status was not "Ready for Development" after -14d AND status = "In Development"

that at the moment seems to be working as I expect. 

[Alexey Matveev]

Hello,

I think your JQL query should be like this:

not status changed from "In Development" after -14d  AND status = "In Development"

[Felipe Seiber]

This does not work as it returns tasks that have been moved to development within 2 weeks. I'm looking for a list of results that only displays all tasks that have remained in the "In Development" Status for OVER 2 weeks. 

thanks, 

[Alexey Matveev]

Are you sure that you did not forget the NOT before the status word?

This JQL query will show you all tickets which were NOT moved from the In Development status and right now the status is In Development

[Felipe Seiber]

YES, I included the "NOT" before the status. 

[Piotr Bojko]

Not sure if you want to use the filter only for data retrieval or some dashboard gadget or something else. 

You can use Smart QL app from atlassian market - it provides SQL instead of JQL for jira and a virtual view Steps with period for each step. It should do the trick. Such SQL query you can place on a dashboard as a table or chart then.

[Sid]

status ="In Development" AND updatedDate <= -14d 

[Felipe Seiber]

This doesn't appear to work either. Doing a manual check multiple tasks are missing from the list that have been in development over 2 weeks. 

It seems this omits anything that has been updated in less than 2 weeks so items that went to QA and back to development again are omitted. (This is a clarification error on my part)