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!
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There are several add ons that do this, Time in Status - Free will give you this information
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.