Due to the fact that there are no methods for getting the activity history in Jira data center, I need to collect it from the postgres tables. But I cannot understand how Jira collects it? What tables are used to store history?
Hi @Dmitrii
I will recommend having a look at the Jira database Schema: https://developer.atlassian.com/server/jira/platform/database-schema/ provided by Atlassian as the activity might need multiple tables to make sense out of.
One table that sticks out from memory is the changeitems table.
See the accepted answer here as it seems you are trying to do something slightly similar: https://community.atlassian.com/t5/Jira-questions/How-can-I-map-changegroup-changeitem-and-jiraissue-tables/qaq-p/660959
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.
Learn moreOnline forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.