Issue Labels
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 '