EndPoint Query Work Item Comments

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

query_workitem_comments

Description

Get work item comments associated with the specified project and organization that are filtered by a Wiql query. (A team can optionally be specified as well.). Read more about this API here https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query-by-wiql?view=azure-devops-rest-7.0 and here https://learn.microsoft.com/en-us/azure/devops/boards/queries/query-operators-variables?view=azure-devops [API reference]

Parameters

Parameter

Label

Required

Options

Description

Project

Project Name

YES

The Name of the project.

Query

Wiql Query

YES

The WIQL query (refer Azure DevOps Help to learn Wiql syntax. [API reference]

Team

Team Id or Name

Id or name of the team associated with the query.

TimePrecision

Use time precision

Option	Value
false	false
true	true

Whether or not to use time precision.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_I4`	`int`		False
WorkItemId	`DT_I4`	`int`		False
Text	`DT_NTEXT`	`nvarchar(MAX)`		False
RenderedText	`DT_NTEXT`	`nvarchar(MAX)`		False
Format	`DT_WSTR`	`nvarchar(4000)`	4000	False
CreatedDate	`DT_DBTIMESTAMP`	`datetime`		False
CreatedByUniqueName	`DT_WSTR`	`nvarchar(4000)`	4000	False
CreatedById	`DT_WSTR`	`nvarchar(4000)`	4000	False
CreatedByDisplayName	`DT_WSTR`	`nvarchar(4000)`	4000	False
ModifiedDate	`DT_DBTIMESTAMP`	`datetime`		False
ModifiedByUniqueName	`DT_WSTR`	`nvarchar(4000)`	4000	False
ModifiedById	`DT_WSTR`	`nvarchar(4000)`	4000	False
ModifiedByDisplayName	`DT_WSTR`	`nvarchar(4000)`	4000	False
Url	`DT_WSTR`	`nvarchar(1000)`	1000	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.