...
ISSUEVERSIONS | |||
|---|---|---|---|
Column | ISSUEID | VERSIONID | RELATION |
Type | BIGINT | VARCHAR | VARCHAR |
Indexed | x | x |
|
...
How
...
to
...
get
...
all
...
the
...
versions
...
and
...
their
...
issues
...
of
...
a
...
given
...
project
...
(id=10000)
...
and
...
their
...
release
...
status
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT |
...
|
...
P.NAME AS PROJECT, |
...
KEY(JQL.ISSUEID) 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 |
...
|
...
|
...
JQL ON |
...
JQL. |
...
ISSUEID = IV.ISSUEID |
...
WHERE |
...
P.ID=10000 |