...
ISSUELABELS | ||
|---|---|---|
Column | ISSUEID | LABEL |
Type | BIGINT | VARCHAR |
Indexed | x | |
Example:
Count not resolved issues with the "Git_commit" label
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
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 ' |