Query, create, modify, and delete the available Components of a project in Jira.

Table Specific Information

Select

The connector uses the Jira API to process some of the filters. The connector processes other filters within the connector.

For example, the following queries are processed server side:

Retrieve the components of each project

SELECT * FROM ProjectComponents

You can also filter the components by their Id or the Project they are part of:

SELECT * FROM ProjectComponents WHERE Id = 10022 

Using ProjectId:

SELECT * FROM ProjectComponents WHERE ProjectId = 10027 

Using ProjectKey:

SELECT * FROM ProjectComponents WHERE ProjectKey = 'QMTH' 

Insert

Create a new Component for the project. The ProjectKey and Name columns are required.

INSERT INTO ProjectComponents (ProjectKey, Name, AssigneeType) VALUES ('COB', 'Testing Component', 'PROJECT_LEAD')

Update

Make changes to a project component, specifying the Id column of the component to modify.

UPDATE ProjectComponents SET LeadKey = 'newlead' WHERE Id = 10065

Delete

Remove a component of the project by specifying the Id.

DELETE FROM ProjectComponents WHERE Id = 10065

Columns