WorkItems
Retrieves a list of work items. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled.
Table Specific Information
Select
The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=', 'IN' operators.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM WorkItems WHERE Id = 1
GetDeleted
The ProjectId and ChangedDate columns are filterable while retrieving deleted WorkItems:GETDELETED FROM WorkItems WHERE Projectid = 'bl54d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND ChangedDate >= '2022-01-01'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
Id of the work item. | |
| ProjectId | String | True |
Id of the project. | |
| Type | String | True |
Type of the work item. | |
| State | String | True |
Current state of the work item. | |
| CreatedDate | Datetime | True |
Creation date of the work item. | |
| CreatedById | String | True |
User ID of work item creator. | |
| CreatedByDisplayName | String | True |
Display name of work item creator. | |
| CreatedByUrl | String | True |
Profile link of work item creator. | |
| ChangedDate | Datetime | True |
Date of last change to the work item. | |
| ChangedById | String | True |
User ID of most recent work item editor. | |
| ChangedByDisplayName | String | True |
Display name of most recent work item editor. | |
| ChangedByUrl | String | True |
Profile link of most recent work item editor. | |
| AssignedToId | String | True |
User ID of current work item assignee. | |
| AssignedToDisplayName | String | True |
Display name of current work item assignee. | |
| AssignedToUrl | String | True |
Profile link of current work item assignee. | |
| Links | String | True |
Aggregate of the reference links. | |
| Rev | Integer | True |
Revision number of the work item. | |
| Url | String | True |
Full HTTP link 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 |