Delete Work Item Comment

Parameters

Output Columns

Input Columns

Examples

SSIS

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

Delete rows from WorkItemComments table using API Destination

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

Azure DevOps

WorkItemComments

Delete

ODBC application

Use these SQL queries in your ODBC application data source:

Delete work item comment

SELECT * FROM delete_workitem_comment
WHERE Id = 'abcd-1234-id'
AND WorkItemId = 'abcd-1234-workitemid'
WITH
(
    "Project" = 'abcd-1234-project'
)

Delete a specific work item by its Id

DELETE FROM WorkItemComments WHERE WorkItemId=6455 and Id=5284411

SQL Server

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

Delete work item comment

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_workitem_comment
WHERE Id = ''abcd-1234-id''
AND WorkItemId = ''abcd-1234-workitemid''
WITH
(
    "Project" = ''abcd-1234-project''
)';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

Delete a specific work item by its Id

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM WorkItemComments WHERE WorkItemId=6455 and Id=5284411';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];