Creates, reads, updates, and deletes the available remote issue links.

Table-Specific Information

SELECT

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

The add-in uses the Jira API to process filters based on the IssueId, IssueKey, and Id columns. The add-in processes all other filters client-side.

You must specify an IssueId or IssueKey to retrieve results. If neither is specified, the add-in automatically queries the Issues table to retrieve the required identifiers. This may result in increased query times.

For example, the following queries are processed server-side:

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

INSERT

Insert a remote issue link by specifying the following fields:

• ObjectUrl
• ObjectTitle
• Either IssueId or IssueKey

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

UPDATE

Update a remote issue link by specifying its Id and either the IssueId or IssueKey of the associated issue.

UPDATE IssueRemoteLinks
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

Delete a remote issue link by specifying the Id of the link and either the IssueId or IssueKey of the issue.

DELETE FROM IssueRemoteLinks WHERE Id = 10058 AND IssueId = 19409;

Columns

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