WorkItemsHistory
Retrieves a work item's history as a list.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Revision supports the '=' operator.
- WorkItemId supports the '=' operator.
The rest of the filter is executed client-side in the provider.
For example, the following query will be filtered server-side:
SELECT * FROM WorkItemsHistory WHERE WorkItemId = 1
Columns
Name | Type | References | Description |
Revision [KEY] | String | The WorkItem Revision. | |
RevisedById | String | Revised By Id. | |
WorkItemId | Integer |
WorkItemIds.Id | The WorkItem Id. |
Name | String | Revised By Name. | |
Value | String | Work Item Value. | |
LinksAvatarHref | String | Revised By Links href. | |
Descriptor | String | Revised By Descriptor. | |
DisplayName | String | Revised By Display Name. | |
RevisedDate | String | Revised Date. | |
Url | String | URL. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
Name | Type | Description | |
AsOf | Datetime | AsOf UTC date time string. | |
ErrorPolicy | String | The flag to control error policy in a bulk get work items request.
The allowed values are fail, omit. | |
Expand | String | The expand parameters for work item attributes.
The allowed values are all, fields, links, none, relations. |