Does anyone know what the JQL field Jira uses to show high cycle times on a board? I want to highlight items that have been in progress for more than x days to the team on their board by using a quick filter, and want to know the field Jira uses to pull in a quick filter.
While Jira does store data on transitions in the database, there isn't a JQL field in native Jira that tracks that specific time in status per se. There are some 3rd party apps for Jira Cloud that you could use to store that data in a custom field if you like, in turn I believe this would be something you could then search via JQL. I know that there are two popular options, among others, you can find in Marketplace such as
If you're not looking for an add-on/plugin/app here, you could instead try to hack this out with some JQL, but I have to note that there are some limitations here. For example, you could use a JQL filter such as
not status changed during (-10d, now()) AND resolution is empty
This could quickly show you issues that have not changed status in the last 10 days for example, but excluding issues that have a resolution value set. The catch here is that any issue could be quickly transitioned back to a different state and then moved back again and it would reset this counter, so you might miss some issues that have been transitioned but were sitting in a particular status previously for a while.
I hope this helps.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events