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 connector 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 connector.
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. |