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)
You need to join on customfield and customfieldvalue tables. "Sprint" is just another custom field.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.