Problem
The version strings of custom field, that can select multiple versions, shall be selected
Approach – Ansatz
The table projectversion can be used to connect to CustomFieldValue.NUMBERVALUE
Solution – Lösung
SELECT pk.PROJECT_KEY+'-'+CAST(a.issuenum AS varchar(max)) as issue, pv.vname FROM project_key pk INNER JOIN jiraissue a ON pk.PROJECT_ID=a.PROJECT INNER JOIN CustomFieldValue b ON a.ID=b.ISSUE INNER JOIN customfield c ON b.CUSTOMFIELD=c.id INNER JOIN projectversion pv ON pv.ID=b.NUMBERVALUE WHERE c.CFName = 'LUA Version(s)' --AND pk.PROJECT_KEY+'-'+CAST(a.issuenum AS varchar(max)) ='NDS-4352' ORDER BY 1