JIRA status mapping in Database

[harshit raj]

Hello Folks,

Hope everyone is sound and happy. :) 

Since Time in Status for JIRA server is not available for further licensing, I want to fetch the details of Workflow status and time in status for issues related to a project.

Reason why I want to know- Since I am managing many projects where SLA based productivity and incentives are in place. So I want to know how much time in each workflow an issue is present through JIRA Database. 

Please let me know if anybody is having any idea or suggestions on how to do it.

Thanks in advance. 

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

I would strongly recommend that you invest in an app to do this.  The database is the worst possible thing to try to look at for reporting (of any type, not just the time in status).

If you must look at the database, then you need to look at the changeitem and changegroup tables - changeitem will be logging "status changed from X to Y", and changegroup will give you the date and time of the change.  You'll also need to look at the created date/time of the issue itself if you want to report on time in the first status.