It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage


Hello Team,

any body please can help on this

i want small help regarding db tables on below

I want the DB tables details while we are transition of issue which tables we can see updates. like moving from To-do to In progress and then In progress to done etc

We are using postgres(Type-postgres72) database with version-9.5.10

our jira version is 7.9.2

Kindly request you to share the db tables names


1 answer

0 votes

It depends heavily on what data the issue has on it and what is configured for the issues.

I would strongly recommend NOT looking at the database for this.  It's complex, messy and hard to read.

Could you tell us why you are asking?  What are you trying to achieve here?  If we know that, we can almost certainly give you a much better (easier, faster and less complex) way to do it than listing 2/3rds of the Jira database and explaining the fifty or so tables you might have to read.

Hello @Nic Brough _Adaptavist_ 


This data is requested by other team in our project so we have to provide this data 

Like whenever we are moving transitions like from TODO to INPROGRESS and then INPROGRESS  to DONE etc   in jira UI

In database while doing this transitions/status change which tables are updated this changes or in database these entries(transition changes) are effects which tables are stored this updates

so kindly request you to provide this db tables or provide any relevant to this 





tom lister Community Leader Mar 02, 2019

Hi @Santhosh Vegolam 

Have you at web hook functionality and REST API to communicate with other apps?

Hello @tom lister 


Thanks for quick response


we have webhook with slack application also RESTAPI



tom lister Community Leader Mar 02, 2019


that will get you a more reliable way to watch events than any database polling

more info here

Hello @tom lister 


i am not looking for this link/information exactly  i want db tables while transitions/status change in jira like whcih tables stored or updated in database while performing workflow status change in jira UI

if any please provide 


i hope any database feels same and not sure but we are using postgreSQL 9.5.10



tom lister Community Leader Mar 02, 2019

I'll give you a quick starter for 10, but I won't have time to go down into any details on this forum

If you know your issue id look in the jiraissue table which will show you the current status

the status name will have to beg looked up in the jira status table.

with an issue id you can find a record of changes on the change group table

the change group is linked to change items which records the exact changes done. This is one of more byzantine bits of jira data. To find a transition , you need to look for the last change group that contains an item that changed the issue status

if you want to then retrieve details of custom fields attached to the item you will have to unpick customfield, customfieldoptions, customfiledvalues

Comments are buried in the jiraaction tables

I can feel PTSD coming on just thinking of going back in there.

REST API - you'll thank me for that advice one day

Hello @tom lister 


Thanks for your valuable time on this


I got your provided information  will more helpful to me 


Thank u so much and i will appreciate your help

i will let you know if any more on this


Thanks once again @tom lister 




Tom has given you some of the tables that could be affected by a transition.  There are another 30-50 that could be updated on top of those, and you're missing any mention of the workflow stuff.

Again, please, don't bother with the database, do it properly with REST or Jira's UI.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,481 views 12 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you