Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How does jira collect activity history in sql?

Dmitrii September 12, 2021 edited

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?

1 answer

0 votes
Ismael Jimoh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 13, 2021

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.

Ismael Jimoh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 13, 2021

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

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira product discovery, jpd premium, product management, idea management, product discovery, jira premium, product planning, atlassian community, product development, roadmap planning, product prioritization, feature management

Introducing Jira Product Discovery Premium ✨

Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.

Learn more
AUG Leaders

Atlassian Community Events