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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.