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