WorkItemsHistory
Retrieves a list of work items history
Table Specific Information
Select
The driver 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 driver.
NOTE: WorkItemId is required in order to query WorkItemsHistory.
For example:
SELECT * FROM WorkItemsHistory WHERE WorkItemId=1
Columns
| Name | Type | References | Description |
| Revision [KEY] | String | The WorkItem Revision. | |
| Id | Integer | Revised By Id. | |
| WorkItemId | Integer | The WorkItem Id. | |
| Name | String | Revised By Name. | |
| Value | String | Work Item Value. | |
| ImageURL | String | Revised By Image URL. | |
| 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.
| 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. |