CODEWITHSUNDEEP
jira
Pankaj Jaju
Pankaj Jaju

Reputation: 5471

Get JIRA issue status time

There is a status in my JIRA instance called "Ready For Test" at which the tester would validate and close the jira. I need to know the amount of time the JIRA is in that particular status since it was moved from "In Progress" to "Ready to Test".

Is there a JQL query that can do it? I need this time field to be exported to Excel as well so that I can name and shame people and ask them to close the JIRAs as soon as they can.

Upvotes: 1

Views: 3878

Answers (3)

Mehmet Aydoğdu
Mehmet Aydoğdu

Reputation: 96

As an alternative, you can use Status Time Jira app. It provides reports on how much time passed in each status.

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 by any field(eg. average in progress time by project, average cycle time by issue creation month). 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.

As a free solution, you can try the limited version Status Time Free.

Upvotes: 0

Pankaj Jaju
Pankaj Jaju

Reputation: 5471

Thanks @SilenyHobit for the idea. Here is what I've done:

  1. First installed JIRA Suite Utilities plugin (its FREE)
  2. Added a custom field called RFTDate (date type control)
  3. Added a post function in RFT transition to update RFTDate with current datetime

Voila!!!

Upvotes: 0

SilenyHobit
SilenyHobit

Reputation: 99

I don't think it is possible on clean Jira installation. There are two plugins I know providing this kind of functionality:

Time in Status - self-explanatory

Enhancer Plugin (sorry, can't post more than two links) - adds a configurable time in status custom field, bt if I remember it correctly, it can display value only after you leave the status.

These are both paid, so that can be an issue.

Another option (if you're not using OnDemand) is the Script Runner Plugin. This plugin will allow you to create your own workflow postfunctions so you can store the "Ready to Test" transition date to one custom field and either calculate time and write it to another custom field when leaving that status or write a scripted field that will calculate and display current time since entering status. This solution is free (not counting your time to implement the functions).

Upvotes: 2

Related Questions