Skip to main content

case_relationship_jira_issues

Creates, updates, deletes, gets or lists a case_relationship_jira_issues resource.

Overview

Namecase_relationship_jira_issues
TypeResource
Iddatadog.service_management.case_relationship_jira_issues

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
create_case_jira_issueinsertcase_id, dataCreate a new Jira issue and link it to a case
link_jira_issue_to_caseupdatecase_id, dataLink an existing Jira issue to a case
unlink_jira_issuedeletecase_idRemove the link between a Jira issue and a case

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
case_idstringCase's UUID or key (example: f98a5a5b-e0ff-45d4-b2f5-afe6e74de504)
sitestringThe Datadog site (region) for your organization, for example datadoghq.com, us3.datadoghq.com, us5.datadoghq.com, ap1.datadoghq.com, ap2.datadoghq.com, datadoghq.eu, ddog-gov.com. Resolved from the DD_SITE environment variable when set. Optional: defaults to datadoghq.com, or the value of the DD_SITE environment variable when set; a WHERE value overrides both.

INSERT examples

Create a new Jira issue and link it to a case

INSERT INTO datadog.service_management.case_relationship_jira_issues (
data,
case_id
)
SELECT
'{{ data }}' /* required */,
'{{ case_id }}'
;

UPDATE examples

Link an existing Jira issue to a case

UPDATE datadog.service_management.case_relationship_jira_issues
SET
data = '{{ data }}'
WHERE
case_id = '{{ case_id }}' --required
AND data = '{{ data }}' --required;

DELETE examples

Remove the link between a Jira issue and a case

DELETE FROM datadog.service_management.case_relationship_jira_issues
WHERE case_id = '{{ case_id }}' --required
;