Problem
To fetch the values „Affects version“ or „Fixed Version“ from the JIRA Database via SQL, the use of different relations/tables is necessary
Solution – Lösung
You can use the ASSOCIATION_TYPE=’IssueVersion‘ for Affects version and ASSOCIATION_TYPE=’IssueFixVersion‘ to get the Fixed version
The next example shows how to retrieve Affects Version for Issue-ID AT-15:
SELECT projectversion.id, vname, project_key.PROJECT_KEY+'-'+CAST(jiraissue.issuenum AS varchar(max)) as pkey, ASSOCIATION_TYPE
FROM projectversion, nodeassociation, jiraissue, project_key
WHERE SINK_NODE_ID = projectversion.id
AND SOURCE_NODE_ID = jiraissue.id
AND project_key.PROJECT_ID=jiraissue.PROJECT
AND ASSOCIATION_TYPE='IssueVersion'
AND project_key.PROJECT_KEY+'-'+CAST(jiraissue.issuenum AS varchar(max))='AT-15'