Issue Versions

Owned by Pablo Beltran (Unlicensed)
Last updated: Oct 08, 2018
1 min read

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

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