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
Insert
Inserts are not supported for this table. However, they can be performed through the CreateWorkItem stored procedure.
Update
Updates are not supported for this table. However, they can be performed through the UpdateWorkItem stored procedure.
Delete
The following is an example of deleting from the WorkItems table:
DELETE FROM WorkItems WHERE Id = 2
Note that some work items are of type TestCase or TestPlan, leading to the item being listed both there and in WorkItems. These work items must be deleted from the TestPlan or TestCase tables rather than the WorkItems table.
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 |