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

JIRAISSUE table column descriptions



I would like to know where can i find description of JIRA table columns, for example there is a column called RESOLUTION in JIRAISSUE table, i could find values like 10000 or 10001 etc, but if i want to know description for these values where can i find them. 

Version i am referring to is (server version)

  • v8.13.1

thank you

2 answers

1 accepted

1 vote
Answer accepted
Hana Kučerová Community Leader Mar 10, 2021

Hi @Nagappan Murugappan ,

resolutions are in resolution table:

select id, pname, description from resolution
1 vote

Stop reading the database, it's the worst possible way to look at Jira data.

Hi Nic


Thanks for your feedback, its not for looking at the data, but based on resolution and resolution dates, we do create certain customized reports. 

Suggest an answer

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

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

164 views 1 6
Read article

Atlassian Community Events