Get all issues in a Sprint

[Wes]

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 = <dbo.project.pkey> AND issuetype = <dbo.issuetype.pname> AND Sprint = "Sprint 2.1"

(I don't have profiler permissions)

[JamieA]

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

[Gerald Zaks]

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.