IssueLinks
Displays relationships between issues, such as 'blocks', 'duplicates', or 'relates to'.
テーブル固有の情報
SQL とJQL (Jira Query Language) を使用して、IssueLinks を検索できます。
Select
connector はJira API を使用して一部のフィルタを処理します。
connector は他のフィルタをconnector 内で処理します。
IssueLinks で使用可能なカラムは、IssueId、IssueKey、およびJQL です。次に例を示します。
SELECT * FROM IssueLinks WHERE IssueId > 10022 AND IssueId < 10090
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| Id [KEY] | String | Common | The unique identifier of the issue link, representing a specific relationship between two issues in Jira. | ||
| InwardIssueId | Integer |
Issues.Id | Common | The numeric ID of the issue that is linked to the current issue, acting as the inward target in the relationship. | |
| InwardIssueKey | String |
Issues.Key | Common | The key of the issue that is linked to the current issue, such as 'BUG-102' or 'TASK-301'. | |
| OutWardIssueId | Integer |
Issues.Id | Common | The numeric ID of the issue that the current issue is linking to, acting as the outward reference in the relationship. | |
| OutwardIssueKey | String |
Issues.Key | Common | The key of the issue that the current issue is linking to, such as 'EPIC-501' or 'STORY-210'. | |
| IssueId [KEY] | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The numeric ID of the issue that owns or originates this link. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The key of the issue that owns or originates this link, such as 'PROJ-123'. |
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date and time when the originating issue for this link was created in Jira. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date and time of the most recent update made to the originating issue associated with this link. | |
| TypeId | Id | Common | The identifier of the type of relationship, such as 'blocks', 'relates to', or 'duplicates'. | ||
| TypeName | String | Common | The descriptive name of the issue link type, such as 'is blocked by', 'relates to', or 'duplicates'. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| JQL | String | Jira Query Language (JQL) allows filtering of issues based on link relationships, such as issues that block or are blocked by others. |