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

[cesar_theobaldo]

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

[chris.reyes]

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.

[nathan_beck]

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

[Zoryana Bohutska _SaaSJet_]

Hi @cesar_theobaldo 

Do you want to export data about when issues statuses were changed?

[cesar_theobaldo]

Hi, @Zoryana Bohutska _SaaSJet_ , thanks for replying!

That´s exactly what a I need. ! All the other fields are exported on my generated *.CSV file. 
But the especific one date da issue status changed, does not show on the *.CSV File. and it is crucial for my KPI´s.

Can you give me any hint to solve theses situation?

Thanks a Lot again.
Cesar Theobaldo

[Zoryana Bohutska _SaaSJet_]

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.