JDBC Driver for Azure DevOps

Build 22.0.8462

WorkItems

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

Columns

Name Type References Description
Id [KEY] Integer Id of the work item.
ProjectId String

Projects.Id

Id of the project.
Type String Type of the work item.
State String Current state of the work item.
CreatedDate Datetime Creation date of the work item.
CreatedById String User ID of work item creator.
CreatedByDisplayName String Display name of work item creator.
CreatedByName String User name of work item creator.
CreatedByUrl String Profile link of work item creator.
ChangedDate Datetime Date of last change to the work item.
ChangedById String User ID of most recent work item editor.
ChangedByDisplayName String Display name of most recent work item editor.
ChangedByName String User name of most recent work item editor.
ChangedByUrl String Profile link of most recent work item editor.
AssignedToId String User ID of current work item assignee.
AssignedToDisplayName String Display name of current work item assignee.
AssignedToName String User name of current work item assignee.
AssignedToUrl String Profile link of current work item assignee.
LinksFieldsHref String Work item fields reference link.
LinksHtmlHref String Html reference link.
LinksSelfHref String Self reference link.
LinksWorkItemHistoryHref String Work item history reference link.
LinksWorkItemRevisionsHref String Work item revisions reference link.
LinksWorkItemTypeHref String Work item type reference link.
LinksWorkItemUpdatesHref String Work item updates reference link.
Rev Integer Revision number of the work item.
Url String 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462