Issue Components

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", 
   KEY(JQL.ISSUE) AS "ISSUE"
 FROM 
   JQL
     INNER JOIN
    ISSUECOMPONENTS C ON C.ISSUEID = JQL.ISSUEID 
     INNER JOIN
    PROJECTS P ON P.ID = I.PROJECTID
     INNER JOIN 
    PROJECTCOMPONENTS PC ON C.ID = C.PROJECTCOMPONENTID
 WHERE 
   JQL.QUERY = ' 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.