I would like to retrieve our backlog items for a particular project from the database (SQL Server in our case). What is the SQL query for getting this from SQL Server Management Studio?
Secondarily, I would also like to get the sub-tasks associated for issues. I am familiar with the two tables jiraissue and jiratype (in the jiraschema), but I'm missing the information to link sub-tasks to parent issues.
Thanks for any help!
