We extensively use subtask feature of JIRA and now have couple of where Standard Issue type is around 6k and if i include subtask it is more than 50K. I can get subtask info in excel easily howver the view is limited to 1k in JIRA so it would be difficult to have all the subtask and you can imgine that i have export couple of time to get all 50k subtask in excel and these may lead to human error.
Is this data somewhere stored in sql server DB where i can fetch data directly.
Like for comment info in JIRA there is JIRAaction table which has all this info. I'm able to retrive all the info driectly by sql server which has simplified by task.
Sub-tasks are still issues in their own right.
I avoid the use of SQL because you have to build an understanding of the data structure for it to be useful, and you shouldn't really run it on an active Jira database - there's the risk of constructing queries that cause overloads and take your Jira out. (and it also makes "clever" developers think they can write to it - which is wrong because it breaks it)
Anyway, your query starts with jiraissue - you'll need to select by issue type (join to the issue type table to read the type names), then join that to the other tables you need if you want versions, components, custom fields, user names or the parent issue id (that's 9 other tables to start with - you can see why I say it's easy to construct overloading SQL statements)
You might find it easier to question why you are exporting? Then come up with a better solution.
Still curious as to why you need to export by the way. There may be a better solution.
Oh, and tables, you'll want to look at https://developer.atlassian.com/display/JIRADEV/Database+Schemafor the full schema and how some of the bigger stuff hooks together. Bear in mind the schema varies between versions of Jira (but not hugely)
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs