Export transition information?

[Kim Wall]

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?

[david]

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

Cheers

[Nuwan]

I think this question is repeated few times in this forum

Pulling time in status report from JIRA Suite Utilities?

https://answers.atlassian.com/questions/145234

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

[RichieS]

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

[Tomasz Kustrzynski]

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.

[Michael Babboni]

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?

[Nic Brough -Adaptavist-]

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)

[Tomasz Kustrzynski]

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

[MattS]

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

[Kim Wall]

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

[Anthony Kelley]

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?

[Kim Wall]

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?

[Anthony Kelley]

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.

[Kim Wall]

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?