nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Felipe Seiber

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.

All comments

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,

Sid_kvhzt3

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

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.

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)

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.

Felipe Seiber

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server