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

Cameron_Rosier

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!

Tuncay Senturk _Snapbytes_

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