WorkItemsHistory
Retrieves a list of work items history
Table Specific Information
Select
The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Revision supports the '=' operator.
- WorkItemId supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.
NOTE: WorkItemId is required in order to query WorkItemsHistory.
For example:
SELECT * FROM WorkItemsHistory WHERE WorkItemId = 1
Columns
| Name | Type | References | Description |
| Revision [KEY] | String | The WorkItem Revision. | |
| Id | Integer | Revised By Id. | |
| WorkItemId | Integer | The WorkItem Id. | |
| Name | String | Revised By Name. | |
| Value | String | Work Item Value. | |
| ImageURL | String | Revised By Image URL. | |
| LinksAvatarHref | String | Revised By Links href. | |
| Descriptor | String | Revised By Descriptor. | |
| DisplayName | String | Revised By Display Name. | |
| RevisedDate | String | Revised Date. | |
| Url | String | URL. |
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 | |
| Expand | String | The expand parameters for work item attributes.
使用できる値は次のとおりです。all, fields, links, none, relations |