IssueComponents

Lists components assigned to issues, which typically represent parts or modules of a project.

テーブル固有の情報

SQL とJQL (Jira Query Language) を使用して、IssueComponents を検索できます。

connector はJira API を使用して一部のフィルタを処理します。

connector は他のフィルタをconnector 内で処理します。

IssueComponents で使用可能なカラムは、IssueId、IssueKey、およびJQL です。次に例を示します。

SELECT * FROM IssueComponents WHERE IssueId > 10022 AND IssueId < 10090


Name	Type	References	SupportedOperators	Platform	Description
Id [KEY]	String		=,<>,IS,IS NOT,IN,NOT IN	Common	The unique identifier of the component associated with the issue, used internally by Jira to reference the component.
Name	String			Common	The name of the component, which categorizes issues within a project into smaller parts such as modules, features, or teams.
IssueId [KEY]	Integer	Issues.Id	=,<>,>,>=,<,<=,IN,NOT IN	Common	The internal numeric identifier of the issue that is associated with the component.
IssueKey	String	Issues.Key	=,<>,>,>=,<,<=,IN,NOT IN	Common	The readable issue key (such as 'JIRA-456') that uniquely identifies the issue linked to the component.
IssueCreatedDate	Datetime		=,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp representing when the issue associated with the component was originally created.
IssueUpdatedDate	Datetime		=,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp representing the last time the issue linked to the component was updated.
Description	String			Common	A short summary or explanation of what the component represents within the context of the project.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
JQL	String		Jira Query Language (JQL) allows filtering issue components by various fields, such as component name, issue key, or project.