WorkItemsHistory
Retrieves a work item's history as a list.
Table Specific Information
Select
The connector 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 connector.
For example, the following query will be filtered server-side:
SELECT * FROM WorkItemsHistory WHERE WorkItemId = 1
Columns
| Name | Type | References | Description |
| Revision [KEY] | String | The WorkItem Revision. | |
| RevisedById | String | Revised By Id. | |
| WorkItemId | Integer |
WorkItemIds.Id | The WorkItem Id. |
| Name | String | Revised By Name. | |
| Value | String | Work Item Value. | |
| 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 |