JiraLinks
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 provider.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. |