WorkItemRevisionFields
Retrieves a list of work item revision fields
Table Specific Information
Select
The 本製品 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 本製品.
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 |