Dynamic Dates

[Alice Rischer]

Hi everyone,

I'm keen to build a search filter that helps me isolate issues that haven't changed status in the past two weeks or longer (i.e. an issue has been in a column for two weeks or more.)

I'm new to JQL and am getting a bit lost with dynamic dates, but have managed to write the following. Will this return the results I want? I want to exclude issues in some statuses, as below.

project = [PROJECTNAME] AND issuetype = Story AND NOT status changed during (-14d, now()) AND status != Planning AND status != "To Do" AND status != Archived

To build on this, I'm wanting to find out how to see how long, on average, issues spent in which columns over the past year. Is there a way to filter this in JQL?

Thanks for your help!

[Deleted user · Accepted solution]

Hi @Alice Rischer

The JQL you mentioned should work just fine. You can tune it a little by doing this -

project = [PROJECTNAME] AND issuetype = Story AND NOT status changed during (startofDay(-14d), now()) AND status not in (Planning, "To Do", Archived)

The second part to your question on bringing a report on how long issues have spent in the available statuses isn't really possible using just a JQL or JIRA Out of the box. If you are willing to look at MarketPlace Add-ons to help with this, easyBI  is an option as explained here. Scriptrunner can also help if you would like to have a scripted/calculated field to track the number of days in a status for each issue.

Hope this helps!

Thanks

Kalyani

[Alice Rischer]

Thanks for your help with the JQL! Really helped Kalyani.

It's a shame that we can't generate a report about how long an issue has been in a particular status, but there may potentially be a way around this with card customisation.

Thanks again!

[Patrick Costello]

There are several add ons that do this, Time in Status - Free will give you this information