Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there an SQL query to get a list of all issues that belong to completed releases?

Cameron_Rosier
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 26, 2019

I am looking to write an SQL query that can retrieve a list of issues that exist within completed releases..

So far I can get a list of the completed releases like so:

SELECT projectversion.name, projectversion.description
FROM projectversion
WHERE released = 'true' and project = '<project_id>'
ORDER BY projectversion.sequence DESC;

 

I can also get a list of all of the issues within that project like so:


SELECT *
FROM jiraissue
WHERE project = '<project_id>';  

 

I am lost as to how to join the two of those tables and produce a list of issues that exist within table of completed releases.

 

If anyone has encountered something like this, please send help!

1 answer

0 votes
Tuncay Senturk _Snapbytes_
Community Champion
March 26, 2019

Hello Cameron,

Actually you did everything except joining those tables.

Try below SQL

SELECT jiraissue.issuenum, jiraissue.summary, projectversion.vname, projectversion.description
FROM projectversion, jiraissue
WHERE projectversion.released = 'true' and projectversion.project = <project_id>
AND projectversion.project = jiraissue.project
ORDER BY projectversion.sequence DESC;

Cheers

Suggest an answer

Log in or Sign up to answer