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 |
Projects.Id |
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. | |
| CreatedByName | String | True |
User 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. | |
| ChangedByName | String | True |
User 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. | |
| AssignedToName | String | True |
User name of current work item assignee. | |
| AssignedToUrl | String | True |
Profile link of current work item assignee. | |
| LinksFieldsHref | String | True |
Work item fields reference link. | |
| LinksHtmlHref | String | True |
Html reference link. | |
| LinksSelfHref | String | True |
Self reference link. | |
| LinksWorkItemHistoryHref | String | True |
Work item history reference link. | |
| LinksWorkItemRevisionsHref | String | True |
Work item revisions reference link. | |
| LinksWorkItemTypeHref | String | True |
Work item type reference link. | |
| LinksWorkItemUpdatesHref | String | True |
Work item updates reference link. | |
| 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.
| 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. |