Does JIRA 4.1.1 query search support extraction of time spent from "Transitions" field in a issue

Hello JIRA Team,

I have been a dedicated user of JIRA 4.1.1 from the past 2+ years, and had a query which needed your help.

Currently in my JIRA setup, under the list of activities, i have the following tabs

a. All (complete set)

b. Comments

c. Work Log (to track time)

d. History (complete history of transactions between owners of the case)

e. Activity

f. Transitions (a display field where the time is recorded for each transition of the case: say from open to i progress, etc)

Now my requirement is to use "front-end" query option to extract the time taken for the case to move from "open" to "in progress" state.

I did dig around a bit of documentation on JQL queries, but couldnt find the required answer.

Do you know if such option exists? Would you be kind enough to share that knowledge with me?

1 answer

1 accepted

0 votes
Accepted answer

Transitions tab comes from the JIRA suite utilities plugin.

There is not direct way, while you have the following choices

  1. Use script runner and add a calculated field which can show the difference of time between days (some code which you can refer to write the field)
  2. If it is for a trend analysis of how issues are being closed, you can use the Average Time in Status gadget.

Hello Renjith,

Thank you for the answer.

for sure, i am not looking for Gadget plugin, for i need this report (time taken to move between different states) in excel format. I cant quite rely on the jira database (which is a more suitable place to extract such data), as i dont have access to it.

Do you know, if creating custom fields (with date type) on the specific case, can help capture the transition time?

Thank you.


Add a standard date time customf field and get it updated in the post function during the transition if you are just looking for the date in which it has happened. If you are looking at finding the difference in time between two statuses, then use scripted field.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,712 views 17 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you