You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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.
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.
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.