IssueLinks
Query the available IssueLinks in JIRA.
Table Specific Information
You can search IssueLinks by using SQL and JQL (JIRA Query Language).
Select
The driver uses the Jira API to process some of the filters.
The driver processes other filters within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
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 Id of the link. | ||
| InwardIssueId | Integer |
Issues.Id | Common | The Id of the issue targeting this issue in the link. | |
| InwardIssueKey | String |
Issues.Key | Common | The Key of the issue targeting this issue in the link. | |
| OutWardIssueId | Integer |
Issues.Id | Common | The Id of the issue this link is targeting. | |
| OutwardIssueKey | String |
Issues.Key | Common | The Key of the issue this link is targeting. | |
| IssueId [KEY] | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The link's original issue Id. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The link's original issue Key. |
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the link's issue was created. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the links's issue was last updated. | |
| TypeId | Id | Common | The Id of the link type. | ||
| TypeName | String | Common | The Name of the link type. |
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 | JQL (JIRA Query Language) allows you to build structured queries. |