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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

In which database table we can find the history of an JIRA issue

I want to find out the history of an issue in database.In which table this is present.

2 answers

1 accepted

2 votes
Answer accepted

You should avoid reading the database directly, as it's generally a very bad thing to do.  What are you actually trying to acheive?  There is almost certainly a better way to do it than reading the database.

But to answer it: changegroup is a change, with the individual changes of fields, as well as non-fields such as status, logged in changeitem.  You may want to read jiraaction too for comments, or if you have a very very old dataset.  There are then some other things logged in other places, but that should cover 95% of what you want to look at

I have changed assignee of an issue... Where can I find the change in Assignee name in database....

Like rickdg likes this

I already told you where the field changes are logged.

For those of you who, like me, stumbled on this page first and still want an answer: https://confluence.atlassian.com/jirakb/how-to-obtain-issue-change-history-from-database-933695139.html

 

tl;dr: a union of changegroup (for linking to groups of changes and issues), and changeitem. Join on changegroup.id = changeitem.groupid if necessary.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Bitbucket Smart Commits vs. Genius Commits - What's the difference?

If you already heard about Smart Commits in Bitbucket, know that you just stumbled upon something even better (and smarter!): Genius Commits by Better DevOps Automation for Jira Data Center (+ Server...

130 views 0 2
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