Create, read, update, and delete the available remote issue links.

Table Specific Information

Note: This table is available only in the Jira Cloud version.

Select

Retrieves details about remote issue links for a specific Jira issue.

The add-in uses the Jira REST API to process filters based on IssueId or IssueKey, with or without the Id of the remote link. All other filters are evaluated client-side by the add-in after the data is retrieved.

You must specify either IssueId or IssueKey in order to retrieve results. If neither is provided, the add-in automatically queries the Issues table to obtain the required identifiers and uses them to fetch the corresponding remote links.

Examples:

SELECT * FROM IssueRemoteLinks WHERE IssueId = 19409;
SELECT * FROM IssueRemoteLinks WHERE IssueKey = 'ACOL-4963' AND Id='10001';

Insert

Creates a new remote issue link for a specific Jira issue.

To insert a new record, you must provide the following fields:

• ObjectUrl – The URL of the linked item.
• ObjectTitle – The title of the linked item.
• Either IssueId or IssueKey – The issue to which the link will be added.

Example:

INSERT INTO IssueRemoteLinks (ObjectUrl, ObjectTitle, IssueKey) values('http://www.mycompany.com/support?id=1', 'TSTSUP-111', 'ACOL-4963');

Update

Updates one or more properties of an existing remote link.

To update a remote link, specify its Id and either the IssueId or IssueKey of the associated issue.

Example:

SET
  Relationship = 'relates to',
  ObjectStatusResolved = true,
  ObjectStatusIconTitle = 'Resolved',
  ObjectStatusIconLink = 'https://tracker.orion-labs.net/status/resolved',
  ObjectStatusIconUrl16x16 = 'https://tracker.orion-labs.net/icons/status_resolved_16.png'
WHERE
  Id = 10059
  AND IssueKey = 'ACOL-4971';

Delete

Removes a remote issue link from a specific issue.

To delete a remote link, specify the Id of the link and either the IssueId or IssueKey of the issue.

Example:

DELETE IssueRemoteLinks WHERE Id = 10058 AND IssueId = 19409;

Columns

Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
Id [KEY]	Integer	True		=	Cloud	The unique identifier of the remote link.
GlobalId	String	False			Cloud	The global identifier of the link, typically representing the linked item on a remote system.
ApplicationName	String	False			Cloud	The name of the remote application where the linked item resides.
ApplicationType	String	False			Cloud	The namespace-qualified type of the remote application where the linked item resides.
Relationship	String	False			Cloud	The description of the relationship between the issue and the linked item.
Self	String	True			Cloud	The API URL of this remote link resource.
ObjectTitle	String	False			Cloud	The title of the linked item.
ObjectSummary	String	False			Cloud	The summary of the linked item.
ObjectUrl	String	False			Cloud	The direct URL to view the linked item.
ObjectIconTitle	String	False			Cloud	The tooltip title of the linked item's icon.
ObjectIconUrl16x16	String	False			Cloud	The URL of the linked item's 16×16 pixel icon displayed in Jira.
ObjectStatusResolved	Bool	False			Cloud	Indicates whether the linked item is resolved.
ObjectStatusIconTitle	String	False			Cloud	The tooltip title of the linked item's status icon.
ObjectStatusIconLink	String	False			Cloud	The URL associated with the linked item's status icon tooltip.
ObjectStatusIconUrl16x16	String	False			Cloud	The URL of the linked item's 16×16 pixel status icon displayed in Jira.
IssueId [KEY]	String	False	Issues.Id	=	Cloud	The ID of the issue associated with the remote link.
IssueKey	String	False	Issues.Key	=	Cloud	The key of the issue associated with the remote link.