ProjectComponents

Manages components within Jira projects. Supports creating, updating, deleting, and querying project components.

Table Specific Information

Select

The add-in uses the Jira API to process some of the filters. The add-in processes other filters within the add-in.

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	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			Common	The unique key identifying the user who is the lead of this component.
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 will be assigned issues by default for this component.
AssigneeKey	String	True			Common	The user key of the default assignee for issues in this component.
IsAssigneeTypeValid	Boolean	True			Common	If the value is 'true', the specified assignee type is valid in the context of the project; if 'false', it is not a valid selection.