ISSUELABELS

Column

ISSUEID

LABEL

Type

BIGINT

VARCHAR

Indexed

x



Example:


Count not resolved issues with the "Git_commit" label


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 '