ODBC Driver for Azure DevOps

Build 22.0.8479


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


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


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 .


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

使用できる値は次のとおりです。fail, omit

Expand String The expand parameters for work item attributes.

使用できる値は次のとおりです。all, fields, links, none, relations

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