Retrieves a list of work items. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled.

Table Specific Information

Select

The provider 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 provider.

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

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.