ADO.NET Provider for Azure DevOps

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060