WorkItemRevisions
Retrieves a list of work item revisions. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled.
Table Specific Information
Select
The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' operator.
- Revision supports the '=' operator.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM WorkItemRevisions WHERE Id = 1
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Id of the work item. | |
| Revision [KEY] | Integer | Revision of the work item. | |
| ProjectId | String | Id of the project this changeset belongs to. |
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. |