ISSUECOMPONENTS | ||
|---|---|---|
Column | ISSUEID | PROJECTCOMPONENTID |
Type | BIGINT | BIGINT |
Indexed | x | x |
Example
Issues of component named "Component 1"
Example 1
SELECT
P.NAME AS "PROJECT",
PC.NAME AS "COMPONENT",
I.KEY AS "ISSUE"
FROM
ISSUES I
INNER JOIN
ISSUECOMPONENTS C ON C.ISSUEID =I.ID
INNER JOIN
PROJECTS P ON P.ID=I.PROJECTID
INNER JOIN
PROJECTCOMPONENTS PC ON C.ID=C.PROJECTCOMPONENTID
WHERE
I.JQL='COMPONENT = "COMPONENT 1"'
Please notice that the JQL condition in the query above. It fetches the issues belonging to the Component 1. The rest of the joined tables are necessaries in order to get the issue key, project name and component name.