ProjectComponents

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

テーブル固有の情報

Select

本製品はJira API を使用して一部のフィルタを処理します。本製品は他のフィルタを本製品内で処理します。

例えば、次のクエリはサーバー側で処理されます。

各プロジェクトのコンポーネントを取得

SELECT * FROM ProjectComponents

コンポーネントのId 、またはコンポーネントが含まれているプロジェクトでフィルタリングすることもできます。

SELECT * FROM ProjectComponents WHERE Id = 10022

ProjectId の使用：

SELECT * FROM ProjectComponents WHERE ProjectId = 10027

ProjectKey の使用：

SELECT * FROM ProjectComponents WHERE ProjectKey = 'QMTH'

Insert

プロジェクトの新しいコンポーネントを作成します。ProjectKey およびName カラムが必須です。

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

Update

変更するコンポーネントのId カラムを指定して、プロジェクトコンポーネントを変更します。

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

Delete

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'. 使用できる値は次のとおりです。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.