What is the right SQL query against the JIRA database to see the field edit history?

Nathan Given

Hi,

I'm trying to use SQL queries recreate the information that shows up in the "ALL" tab on the JIRA issue details view and I'm having a hard time figuring out the SQL for when a field changes.

Has anyone found this information in the JIRA database?  (6.3.8)

Thanks~!

Volodymyr Krupach @BrizoIT

Hi Nathan!

Here are samples with history tables: https://developer.atlassian.com/jiradev/jira-architecture/database-schema/database-change-history

Here you can find DB schema: https://developer.atlassian.com/jiradev/jira-architecture/database-schema Please use JIRA61_db_schema.pdf. It should match schema for JIRA 6.3.

 

 

https://developer.atlassian.com/jiradev/jira-architecture/database-schema