For a customer I need to create monthly reports that shows, among other things, how much time an issue is spending in the different statuses (TO DO, In progress, Closed etc.). More specifically, the customer wants to see, how long it takes from the time when they create the issue, and to the time when we "take" the case and start working on it.
I was quite surprised to find out that you can not get this in Jiras default reporting tools. I have searched for relevant Add-Ons, but most reporting tools is very pricy, and I'm not even sure whether they offer this functionality or not. Isn't this a normal metric to want from a report?
However I found David Bevins Jira Rest Client Dot Net api. Unfortunately this api doesn't give me the opportunity to extract the relevant data (timestamps, activity etc.)
So now I have turned to Jiras rest api, and I am trying to set up a program in .NET to do it. This guy did exactly the same. As you see in his SO question, the returned JSON is a mess. Collecting all the right data will require a lot of work. So before I go further I want to know if anyone has done this before and how you did it?
Any help is appreciated.
Jira has not this option by default and there is not simple way to solve it programatically.
However it is possible to get this data (but you have to use probably 3 or 4 tables from database):
1) create jira add-on and parse data there
2) use Home Directory Browser (https://marketplace.atlassian.com/plugins/info.renjithv.jira.plugins.sysadmin.homedirectorybrowser/server/overview) for getting data and then parse it in you own program
On Atlassian Marketplace is a plugin exactly for this functionality and it works very well, there are filters, time range and some export options:
https://marketplace.atlassian.com/plugins/com.obss.plugin.time-in-status/server/overview
you can tried the trial version for free.