FireDAC Components for Azure DevOps

Build 21.0.7930


Retrieves a list of work items.

Table Specific Information


The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
Note: Id is required in order to query WorkItems.

  • Id supports the '=,in' operators.
  • ProjectId supports the '=' operator.
  • Fields supports the 'in' operator.
  • AsOf supports the '=' operator.
  • ErrorPolicy supports the '=' operator.
  • Expand supports the '=' operator.
For example:
	SELECT * FROM WorkItems WHERE Id IN (1, 2, 3)	
	SELECT * FROM WorkItems WHERE Expand = 'fields'


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


Id of the project.
Fields String Map of field and values for the work item.
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 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930