Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JIRA status mapping in Database

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. 

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 26, 2023

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.

Suggest an answer

Log in or Sign up to answer