ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a list of work items history

Table Specific Information


The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • Revision supports the '=' operator.
  • WorkItemId supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

NOTE: WorkItemId is required in order to query WorkItemsHistory.

For example:

SELECT * FROM WorkItemsHistory WHERE WorkItemId=1


Name Type References Description
Revision [KEY] String The WorkItem Revision.
Id Integer Revised By Id.
WorkItemId Integer The WorkItem Id.
Name String Revised By Name.
Value String Work Item Value.
ImageURL String Revised By Image URL.
LinksAvatarHref String Revised By Links href.
Descriptor String Revised By Descriptor.
DisplayName String Revised By Display Name.
RevisedDate String Revised Date.
Url String 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