ProjectComponents
Manages components within Jira projects. Supports creating, updating, deleting, and querying project components.
Table-Specific Information
SELECT
The connector uses the Jira API to process filters based on the Id, ProjectId, and ProjectKey columns. The connector processes all other filters client-side.For example, the following queries are processed server-side:
SELECT * FROM ProjectComponents WHERE Id = 10022;
SELECT * FROM ProjectComponents WHERE ProjectId = 10027;
SELECT * FROM ProjectComponents WHERE ProjectKey = 'QMTH';
INSERT
Insert a component by specifying the ProjectKey and Name columns.INSERT INTO ProjectComponents (ProjectKey, Name, AssigneeType) VALUES ('COB', 'Testing Component', 'PROJECT_LEAD');
UPDATE
Update a component by specifying the Id column and the columns to update.UPDATE ProjectComponents SET LeadKey = 'newlead' WHERE Id = 10065;
DELETE
Delete a component by specifying the Id.DELETE FROM ProjectComponents WHERE Id = 10065;
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| Id [KEY] | Integer | True | = | Common |
A unique identifier for the project component, used to reference it in Jira. | |
| ProjectId | Integer | True | Projects.Id | =,IN | Common |
The internal ID of the project to which the component belongs. |
| ProjectKey | String | False | =,IN | Common |
The unique key of the project associated with the component, typically used in issue keys. | |
| Name | String | False | Common |
The name assigned to the project component, used to categorize and organize issues. | ||
| Description | String | False | Common |
A detailed explanation of the component's purpose or scope within the project. | ||
| LeadDisplayName | String | True | Common |
The display name of the user designated as the lead for this component, often responsible for overseeing related work. | ||
| LeadKey | String | False | Server |
The unique key identifying the user who is the lead of this component. | ||
| LeadAccountId | String | False | Cloud |
The account ID of the component's lead. | ||
| AssigneeType | String | False | Common |
Indicates the default assignee type for issues filed under this component, such as 'Project Lead' or 'Component Lead'. The allowed values are PROJECT_DEFAULT, COMPONENT_LEAD, PROJECT_LEAD, UNASSIGNED. | ||
| AssigneeDisplayName | String | True | Common |
The display name of the user who is assigned issues by default for this component. | ||
| AssigneeKey | String | True | Server |
The user key of the default assignee for issues in this component. | ||
| AssigneeAccountId | String | False | Users.AccountId | Cloud |
The account ID of the component's default assignee. | |
| IsAssigneeTypeValid | Boolean | True | Common |
Indicates whether the specified assignee type is valid in the context of the project. |