Is there a way to export the field statusCategoryChangedDate to csv file like other fields?

Question

I Have the following filter:
issuetype = Story AND project = NPAMGA AND status in (DONE, Done) AND "Epic Link" = NPAMGA-1300 ORDER BY summary DESC, statusCategoryChangedDate DESC, updated DESC, statusCategory ASC, created DESC, issuetype DESC, status DESC

All fields are generated on CSV file, except statusCategoryChangedDate, wich is essential for me measuring de time using that Date.

Is there a way to export da specifc date as the other fields?

Thanks
Cesar Theobaldo

nathan_beck · Answer

Great workaround for what should be a straightforward issue to resolve.

chris.reyes · Answer

The easiest work-around I've found is to create your filter, add the StatusCategoryChangedDate field to that filter and then export to HTML.  From there, I open the HTML in my browser, select and copy all the cells in that table, and then paste into an empty sheet in Excel.

I'm using it right now to help calculate velocity for my different teams.

Zoryana Bohutska _SaaSJet_ · Answer

Hi@cesar_theobaldo

I don't know any built-in solutions in Jira, but you can consider third-party tools from Atlassian marketplace like Issue History.

It lets you view and export all kind of changelogs for issues you need (including status changes). There are you can monitor who made changes and when.

Hope it will help you.