Export transition information?

I have a team that wants to see how many issues were in a particular status after a date that they have in a custom field. Specifically, what issues were in the Test status after the "Test Date" for the issue. There's currently no way to find that out, I don't believe. The info in the Transitions tab would be useful to find this out, I think, but I don't see a way to export this with search results. Is this possible?



4 answers

1 vote

Hello, I think Exporter App will fit you, it allows you to export issues' transition log to Excel and it works both on Server and Cloud.

You can find it here: https://marketplace.atlassian.com/plugins/com.deiser.jira.exporter/cloud/overview


Hey Kim,

   Are you asking if you can see what issues were in the test status when it surpassed the 'Test Date', regardless of its current status in JIRA?

Yes, that's what they'd like. How many items were in that status beyond the date they should have been. Whether they were in that status when the date passed or if they were moved to that status after the date passed. Does that make sense?

I would look at Script Runner, I know you can pull attribute out of fields with the plugin, and you should be able to filter based on the transition history, and the script runners tool.

I have Script Runner....not sure I saw that as an option to use for JQL? Is this something that can be done via JQL or is it something I'll have to create as an admin?

You can run a query inside a groovy script. Or use the expand=history parameter with the rest API 

So, this is again an admin function, not something the user can query on their own with simplicity like the rest of JQL?

I think this question is repeated few times in this forum

Pulling time in status report from JIRA Suite Utilities?


and my suggestion is try with Better Excel Plugin for JIRA and it will help you to export the data that you need.

This isn't available for JIRA Cloud. Are there other alternatives?

You could try Advanced Export (full disclosure: I'm the author).

It will export all the changes to selected fields (status field in this case). You can then postprocess results in spreadsheet or other custom tool to extract the info you need.

In this case you'd simply:

1) export changes to Status field

2) in spreadsheet: filter out all the rows with change date  after selected date

3) and out the remaning rows, calculate how many were in 'Test' status.

If you have any other special requirements - let me know.

Here's documentation.

Tomasz, you look to have to only solution I've found so far that works with Jira Cloud. However only a small subset of our users would access this. Can pricing be limited to a group or must it be all active users?

Add-ons have to be licenced at the same tier as your largest application (e.g. if you have 25 Software users, 100 Core users and 5 SD Agents, then you need to buy at 100)

Thanks Nic. As you see @Michael Babboni, I don't have any control over that.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Marketplace Apps

Marketplace Spotlight: Marketing apps for Confluence to keep your teams working on the same page


117 views 0 3
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