IssueLinks
Displays relationships between issues, such as 'blocks', 'duplicates', or 'relates to'.
Table Specific Information
You can search IssueLinks by using SQL and JQL (Jira Query Language).
Select
The add-in uses the Jira API to process some of the filters.
The add-in processes other filters within the add-in.
The available columns for IssueLinks are IssueId, IssueKey, and JQL. For example:
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |