ISSUEVERSIONS | |||
---|---|---|---|
Column | ISSUEID | VERSIONID | RELATION |
Type | BIGINT | VARCHAR | VARCHAR |
Indexed | x | x |
|
Example
How to get all the versions and their issues of a given project (id=10000) and their release status
SELECT
P.NAME AS PROJECT, I.KEY AS ISSUE, IV.RELATION, V.NAME AS VERSION, V.RELEASED
FROM
PROJECTS P
INNER JOIN
PROJECTVERSIONS V ON V.PROJECTID=P.ID
INNER JOIN
ISSUEVERSIONS IV ON IV.VERSIONID = V.ID
INNER JOIN
ISSUES I ON I.ID = IV.ISSUEID
WHERE
P.ID=10000