How to write a JQL to list issues whose status is not changed to the next within 10 minutes?

[Akshay Aggarwal]

I want to create a filter which i can subscribe to monitor the TAT breach guidelines in my company. I want all the issues which haven not been transitioned to one status from the other within 10 minutes of getting created. I want the list on a weekly basis.

[Mehmet A _Bloompeak_ · Accepted solution]

Hi @Akshay Aggarwal ,

It is not possible out-of-the-box in JQL. You can calculate it by coding which parses issue history rest api json for each issue. Or you can search for marketplace apps which does the same for you.

You can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

[Akshay Aggarwal]

Hi @Mehmet A _Bloompeak_ 

The report in Status Time Free shows only the time of the status in which the issue is currently in and not of all the statuses it transitioned before the current status. Is there a way possible wherein i can get to know the status transition time to each status in my workflow and not just the current status??

[Mehmet A _Bloompeak_]

Yes it is possible. Can you send your screenshot to support@bloompeak.io so that we can discuss there further?

[Emre Toptancı _OBSS_]

Hello @Akshay Aggarwal 

Our team at OBSS built Time in Status for this exact need. It is available for Jira Server, Cloud and Data Center.

Time in Status mainly allows you to see how much time each issue spent on each status so you can see status times for each status separately. You can combine statuses in any way into consolidated columns to see metrics like Ticket Age, Cycle Time or Lead Time.

You can Sort and Filter your report based on those status times so you can easily find issues that stayed in a given status for more than 10 minutes.

You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the total InProgress time per Epic, or average resolution time per issuetype). 

  

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions. Sort and Filter according to report values.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
• Export your data as XLS, XLSX or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets (released for cloud, server&DC gadget coming soon)

https://marketplace.atlassian.com/1211756

EmreT

[Jack Brickey]

Hi Akshay, I am wondering if you cannot simply look for breached this week issues? You could create a report for met vs. breached and use the time component to show lat 7 days. Example below...

[Akshay Aggarwal]

Hi @Jack Brickey 

Kindly guide me on how to create such a report.

[Zoryana Bohutska _SaaSJet_]

Hi @Akshay Aggarwal 

The report that Jack has shown is for SLAs tracking for tickets from Jira Service Management. 

For Jira Software, you can track SLA time using third-party tools like SLA Time and Report.

Using it, you can set conditions for the SLA timer according to your statuses and set escalation for overdue issues (notification, status, or priority changes) 

Then in the SLA Report, you can filter the issue list by SLA status. For your case - all exceeded. 

And as a result, you will get the list of issues that have not been transitioned to one status from the other within 10 minutes.

I hope it will help you

Regards