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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.