Delete Issue Comment

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Jira Connector in API Source component to read data or in API Destination component to read/write data:

Delete rows from Comments table using API Destination

This Endpoint belongs to Comments table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Jira

Comments

Delete

ODBC application

Use these SQL queries in your ODBC application data source:

Delete issue comment

SELECT * FROM delete_comment
WITH
(
    "IssueIdOrKey" = 'abcd-1234-issueidorkey',
    "CommentId" = 'abcd-1234-commentid'
)

Delete an exising Comment

This example deletes an exising comment for a given Issue Id and Comment Id. You can use Issue Key or Id as an input value.

DELETE FROM Comments WHERE Id=10004 WITH(IssueIdOrKey='CS-2')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Delete issue comment

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_comment
WITH
(
    "IssueIdOrKey" = ''abcd-1234-issueidorkey'',
    "CommentId" = ''abcd-1234-commentid''
)';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

Delete an exising Comment

This example deletes an exising comment for a given Issue Id and Comment Id. You can use Issue Key or Id as an input value.

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Comments WHERE Id=10004 WITH(IssueIdOrKey=''CS-2'')';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];