FireDAC Components for Azure DevOps

Build 21.0.7930

Projects

Get all projects in the organization that the authenticated user has access to and details of the specific project.

Table Specific Information

Select

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.

  • Id supports the '=' operator.
  • State supports the '=' operator.
  • GetDefaultTeamImageUrl supports the '=' operator.
  • IncludeCapabilities supports the '=' operator.
For example:
	SELECT * FROM Projects WHERE State = 'wellFormed'
	SELECT * FROM Projects WHERE GetDefaultTeamImageUrl = false
	SELECT * FROM Projects WHERE Id = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Projects WHERE Id = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND IncludeCapabilities = true

Columns

Name Type References Description
Id [KEY] String Unique identifier of the project.
CapabilitiesProcessTemplateName String Process template capabilities this project has.
CapabilitiesProcessTemplateTypeId String Process template capabilities this project has.
CapabilitiesVersionControlType String Version control capabilities this project has.
CapabilitiesVersionControlGitEnabled Boolean Version control capabilities this project has.
CapabilitiesVersionControlTfvcEnabled Boolean Version control capabilities this project has.
DefaultTeamId String Team (identity) GUID.
DefaultTeamName String The name of the default team.
DefaultTeamUrl String The URL of the team.
DefaultTeamImageUrl String URL to default team identity image.
Description String The description of the project.
LastUpdateTime Datetime The timestamp at which the project was last updated.
LinksCollectionHref String Collection reference links.
LinksSelfHref String Self reference link.
LinksWebHref String Web reference link.
Name String The name of the project.
Revision Integer The revision of the project.
State String The current state of the project.
Url String URL to the full version of the object.
Visibility String Indicates whom the project is visible to.

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
GetDefaultTeamImageUrl Boolean If set, returns of the default team image URL.
IncludeCapabilities Boolean Include capabilities (such as source control) in the team project result (default: false).

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930