Get all issues in a Sprint

Question

I am attempting to query the JIRA SQL Server database. I'd like to find all of the issues for a given Sprint. I believe I should be looking at the jiriaissue and AO_60DB71_SPRINT tables. I'm trying to write SQL that generates the same output as the following filter from our JIRA site: project = AND issuetype = AND Sprint = "Sprint 2.1" (I don't have profiler permissions)

Gerald Zaks1 · Answer

I have the same question, but this answer is not enough to know the specific column(s) to join.  I tried a number of value from a test case I have and I still get no worthwhile results.  I wish someone had a schema of the DB.

JamieA · Answer

You need to join on customfield and customfieldvalue tables. "Sprint" is just another custom field.