WorkItems
Retrieves a list of work items. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled.
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
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
| 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. The allowed values are fail, omit. |
| Expand | String |
The expand parameters for work item attributes. The allowed values are all, fields, links, none, relations. |