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
Renjith Pillai Community Champion Jan 20, 2013

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.


Renjith Pillai Community Champion Jan 20, 2013

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,825 views 12 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot