CData Python Connector for Azure DevOps

Build 24.0.9060

WorkItemsHistory

Retrieves a work item's history as a list.

Table Specific Information

Select

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

For example, the following query will be filtered server-side:

SELECT * FROM WorkItemsHistory WHERE WorkItemId = 1

Columns

Name Type References Description
Revision [KEY] String The WorkItem Revision.
RevisedById String Revised By Id.
WorkItemId Integer

WorkItemIds.Id

The WorkItem Id.
Name String Revised By Name.
Value String Work Item Value.
LinksAvatarHref String Revised By Links href.
Descriptor String Revised By Descriptor.
DisplayName String Revised By Display Name.
RevisedDate String Revised Date.
Url String 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