Returns links between Jira issues and Zendesk tickets.

Table-Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the server.

SELECT * FROM JiraLinks WHERE Id = 123
SELECT * FROM JiraLinks WHERE TicketId = 123
SELECT * FROM JiraLinks WHERE IssueId = 123

Insert

The Name and Subdomain columns are required to insert. This operation is allowed for logged-in users with the "admin" role only.

INSERT INTO JiraLinks (TicketId, IssueId, IssueKey) VALUES (1, 1, 'TP-1')

Delete

You must specify the Id of the Jira link to delete it. This operation is allowed for logged-in users with the "agent" role.

DELETE FROM JiraLinks WHERE Id = 123

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Automatically assigned when the link is created.
TicketId	Integer	False	Tickets.Id	The Id of the Zendesk ticket.
IssueId	Integer	False		The Id of the Jira issue.
IssueKey	String	False		The key for the Jira issue.
CreatedAt	Datetime	True		The date and time at which the link was created.
UpdatedAt	Datetime	True		The date and time at which the link was last updated.