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.
Join now to unlock these features and more
I need a csv file which, among other info, shows me when activities were switched to "Done".
When exporting data as csv, all columns I need are perfectly filled, except the 'StatusCategoryChangedDate' which doesn't even show up in csv file. Since other data are shown perfectly, seems like that's still a bug.
I've seen two other similar topics here posted about two years ago with the same problem, but the only solution found on those is using the "Open in Microsoft Excel" option or exporting data as HTML. This doesn't solve my problem, since a direct link to a CSV file would be way more convenient in my automated reports.
Any help or ideas are very welcome.
Hi @André de Oliveira Águila Favoto -- Welcome to the Atlassian Community!
The statusCategoryChangedDate summarizes the movement through the workflow by statusCategory: to do, in progress, and done. If all you want is when issues reach "Done", have you tried to use Resolved instead? That field can be exported.
Great one, I hadn't noticed this column. I just tried, and it seems to be working.
It would be nice to trace the other status changes as well, but considering this limitation, the most important one is "Done" to monitor efficiency, produce burndown charts, etc.. So your suggestion solves the problem just fine.
Thanks so much!
Awesome, and I am glad that helped!
To see information on the specifics of the time-in-status, you could try Atlassian's interpretation of the Control Chart report for your board. There are some limitations on that chart, so if you want something better / different your options may be driven by what you want to build or purchase:
This issue has been around for years now -- why Atlassian makes us use their API or some third-party code to export a single column is beyond me.
Hi @André de Oliveira Águila Favoto , indeed you cannot export to CSV via the Export CSV function. As you noted export to Excel or Sheets should work but isn't an option for you. Is leveraging the APIs an option? I found this post (you may have already seen) that discusses this topic - Export-status-change-history-from-Jira-inc-From-To-Date .
Thanks a lot for the fast answer.
At first I was working with the APIs, which seemed to be the best option indeed, but then I saw I was limited to export only 100 issues per request, even setting maxResults as any higher value. Sadly, as stated here, it seems to be a limitation by Jira itself. Even with pagination, this rate turns out to be very slow (minutes over) when I try to see a history of some months (which here would be over 3K issues, easily).
The fastest option I found was requesting CSV files (which can have up to 1000 fields). By paginating the http requests I can get all available issues way faster than with the API.
The only problem I am facing in this approach is this missing column. I figured I would be able to solve this problem without external add-ons or rewriting too much code, as it seems to be a bug with only one specific field