WorkItemsHistory
Retrieves a work item's history as a list.
Table Specific Information
Select
The add-in 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 add-in.
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. |