Issue Labels

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

ISSUELABELS

Column

ISSUEID

LABEL

Type

BIGINT

VARCHAR

Indexed

x


Example:

Count not resolved issues with the "Git_commit" label

Example 1
SELECT
 COUNT(*) AS "Number of issues with the label"
FROM 
 JQL
   JOIN
 ISSUELABELS IL ON IL.ISSUEID = JQL.ISSUEID
WHERE
 JQL.QUERY = ' labels = Git_commit AND resolution is EMPTY '