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
It looks like you're new here. Sign in or register to get started.
