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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| 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.
使用できる値は次のとおりです。fail, omit |