ProjectComponents
Query, create, modify, and delete the available Components of a project in Jira.
Table Specific Information
Select
The driver uses the Jira API to process some of the filters. The driver processes other filters within the driver.
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
Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
Id [KEY] | Integer | True | = | Common |
The Id of the component. | |
ProjectId | Integer | True |
Projects.Id | =,IN | Common |
The selected project's id. |
ProjectKey | String | False | =,IN | Common |
The selected project's key. | |
Name | String | False | Common |
The name of the component. | ||
Description | String | False | Common |
The description of the component. | ||
LeadDisplayName | String | True | Common |
The display name of the component's lead. | ||
LeadKey | String | False | Common |
The key of the component's lead. | ||
AssigneeType | String | False | Common |
The type of the component's default assignee. The allowed values are PROJECT_DEFAULT, COMPONENT_LEAD, PROJECT_LEAD, UNASSIGNED. | ||
AssigneeDisplayName | String | True | Common |
The display name of the component's default assignee. | ||
AssigneeKey | String | True | Common |
The key of the component's default assignee. | ||
IsAssigneeTypeValid | Boolean | True | Common |
Whether the assignee type is valid. |