Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL Time in status reports

Jira Query Language (JQL) is widely used to search for information about Time in Status in Jira. Сustomets utilize JQL queries to gain insights into issue lifecycles, track progress, and optimize workflows. 

I'm sure you use jira time in status JQL in your work as well. Today's article will remind you of common jira query time in status.

giphy

JQL queries for Time in Status also aid in performance analysis and reporting. Users can generate Jira time between status custom reports and metrics to measure team and individual performance, track progress, and identify areas for improvement. These insights support you to identify bottlenecks in Jira.

        1. Issues that have been in development per month during a year.

status changed to "In Development" during ("2021-08-01 ", "2021-08-31 ")

       2. Issues changed to the ”Closed” status between five and two weeks before my current time:

status changed to closed after -5w before -2w

       3Issues with status "Resolved" in Service Desk Project between 01 January 2022 - 31 December 2022.

project = SD AND status = Resolved AND resolution is not EMPTY AND createdDate >= startOfYear(-1) AND createdDate <= endOfYear(-1) ORDER BY created ASC

       4.  Issues Resolved and/or Closed by a particular user

status WAS Done BY "user_name"

       5. Issues that have been in a particular status for a specific duration:

status = Open and not status changed after -2w

       6. Issues in X project with issue type x that were transitioned to status X between date and date

Project = Negotiations AND status CHANGED TO "Accepted" and (updated >= "2022/12/26" and updated <= "2022/12/30")

       7. Issues which has historically had a status of "Ready for Deployment" and now are in status "Ready for Deployment"

Status was "ready for deployment" AND status = "Ready for deployment"

       8. Issues which has status "ready for deployment" and had status "ready for deployment"

Status was "ready for deployment" or Status = "Ready for deployment"

       9. JQL for Filter by date and status

updatedDate >= -5d OR status != DONE

       10. JQL Cycle Time 

If you want to set card colours on the board, you'll have to make some tradeoffs. Let's assume you have a decent workflow that encourages you to move tickets from left to right through the board, then you can use the a simple set of conditions like this:

Resolution = Unresolved AND Status changed to "In Progress" BEFORE -5d (card colour -> yellow)
Resolution = Unresolved AND Status changed to "In Progress" BEFORE -10d (card colour -> orange) 
Resolution = Unresolved AND Status changed to "In Progress" BEFORE -15d (card colour -> red)

The Resolution = Unresolved part is optional. But apart from that, it is only a matter of playing with the amount of days you want to use to define colours and putting your different rules in the right order.

_______________________

giphy

Also, for enhance your reports, I suggest you try Time in Status (developed by my SaaSJet team) with 7 types of status time reports 

Here are all of them:

  • Time in Status,
  • Assignee Time,
  • Average Time,
  • Status Entrance Date,
  • Status Count,
  • Transition Count,
  • Time in Status per Date.

I am pleased to offer you a 30-day trial of Time in Status. Furthermore, our add-on is free for up to 10 users, allowing you to evaluate its effectiveness in your service processes.

3 comments

Comment

Log in or Sign up to comment
Geremy Santos Acosta
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 4, 2024

Hi, i'm trying to view in the Time in Status Report only a specific issue type. How can i filter by?

Like # people like this
Valeriia_Havrylenko_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 5, 2024

@Geremy Santos Acosta got it! 

Unfortunately, there is no way you can find it with the native gadget, but I did it with the add-on.

I've created a Status group for Cycle time and then filtered issues by JQL inside the add-on by query issuetype = Story 

Знімок екрана 2024-03-05 о 16.12.03.png

Hope it helps 😊

Like # people like this
Geremy Santos Acosta
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 6, 2024

This one works! Thanks

Like # people like this
TAGS
AUG Leaders

Atlassian Community Events