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)
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.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot