FireDAC Components for Azure DevOps

Build 21.0.7930

BuildDefinitions

Retrieves a list of build definitions.

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 '=,in' operators.
  • ProjectId supports the '=' operator.
  • Name supports the '=' operator.
  • Path supports the '=' operator.
  • ProcessType supports the '=' operator.
  • ProcessYamlFileName supports the '=' operator.
  • Properties supports the '=,in' operators.
  • RepositoryId supports the '=' operator.
  • RepositoryType supports the '=' operator.
  • Revision supports the '=' operator.
  • BuildDate supports the '<,<=,>,>=' operators.
  • MinMetricsTime supports the '=' operator.
  • IncludeLatestBuilds supports the '=' operator.
  • TaskId supports the '=' operator.
  • IncludeAllProperties supports the '=' operator.
For example:
    SELECT * FROM BuildDefinitions WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'	
	SELECT * FROM BuildDefinitions WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id IN (3, 4, 5)	
	SELECT * FROM BuildDefinitions WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Path = '\"'

Columns

Name Type References Description
Id [KEY] Integer Id of the build definition.
LinksBadgeHref String Badge reference link.
LinksEditorHref String Editor reference link.
LinksSelfHref String Self reference link.
LinksWebHref String Web reference link.
AuthoredByDisplayName String This is the non-unique display name of the user.
AuthoredById String Id of the user.
AuthoredByImageUrl String The image Url of the user.
AuthoredByUniqueName String The unique name of the user.
AuthoredByUrl String The URL Of the user.
BadgeEnabled Boolean Indicates whether the badge is enabled.
CreatedDate Datetime The date this version of the definition was created.
DraftOfCreatedDate Integer The date this version of the definition was created.
DraftOfId Integer The Id of the referenced definition.
DraftOfName String The name of the referenced definition.
DraftOfPath String The folder path of the definition.
DraftOfProjectId String Id of the Project of the referenced Definition.
DraftOfQueueStatus String A value that indicates whether builds can be queued against this definition.
DraftOfRevision Integer The definition revision number.
DraftOfType String The type of the definition.
DraftOfUri String The Definition's URI.
DraftOfUrl String The REST URL of the definition.
JobAuthorizationScope String The job authorization scope for builds queued against this definition.
JobCancelTimeoutInMinutes Integer The job cancel timeout (in minutes) for builds cancelled by user for this definition.
JobTimeoutInMinutes Integer The job execution timeout (in minutes) for builds queued against this definition.
LatestBuildId String

Builds.Id

Id of the latest build.
LatestCompletedBuildId String Id of the latest completed build.
Name String The name of the referenced definition.
Path String The folder path of the definition.
ProcessType Integer The process type.
ProcessYamlFilename String The process YAML file name.
ProjectId String

Projects.Id

Project identifier.
Properties String Properties of the build definition.
Quality String The quality of the definition document (draft, etc.).
QueueLinksSelfHref String Queue self reference link.
QueueId Integer The ID of the queue.
QueueName String The name of the queue.
QueuePoolId Integer The pool Id.
QueuePoolIsHosted Boolean A value indicating whether or not this pool is managed by the service.
QueuePoolName String The pool name.
QueueUrl String The full http link to the resource.
QueueStatus String A value that indicates whether builds can be queued against this definition.
RepositoryCheckoutSubmodules Boolean Indicates whether to checkout submodules.
RepositoryClean String Indicates whether to clean the target folder when getting code from the repository.
RepositoryId String

Repositories.Id

The ID of the repository.
RepositoryType String The type of the repository.
Revision Integer The definition revision number.
Tags String The tags associated with this definition.
Triggers String The build triggers.
Type String The type of the definition.
Uri String The definition's URI.
Url String The REST URL of the definition.

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
BuildDate Datetime If specified, filters to definitions that have builds before or after this date.
MinMetricsTime Datetime If specified, indicates the date from which metrics should be included.
IncludeLatestBuilds Boolean Indicates whether latest builds should be included.
TaskId String If specified, filters to definitions that use the specified task.
IncludeAllProperties Boolean Indicates whether the full definitions should be returned.

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