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

This widget could not be displayed.

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.

https://marketplace.atlassian.com/plugins/com.atlassian.jira.ext.charting

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.

nk

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.

https://studio.plugins.atlassian.com/wiki/display/GRV/Script+Runner

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

198 views 1 3
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