WorkItemRevisionFields
Retrieves a list of work item revision fields
Table Specific Information
Select
The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- ChangesetId supports the '=' operator.
- Author supports the '=' operator.
- FromDate supports the '=' operator.
- ToDate supports the '=' operator.
- AsOf supports the '=' operator.
- Id supports the '=' operator.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM WorkItemRevisionFields WHERE ProjectId = '837ccd31'
SELECT * FROM WorkItemRevisionFields WHERE Id = '837ccd31'
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Id of the work item. | |
| Revision [KEY] | Integer | Revision of the work item. | |
| FieldName | String | Field Key for the work item revision. | |
| FieldValue | String | Field Value for the work item revision. | |
| 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. |