FireDAC Components for Azure DevOps

Build 21.0.7930

Builds

Retrieves a list of builds.

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.
  • BuildNumber supports the '=' operator.
  • DefinitionId supports the '=,in' operators.
  • FinishTime supports the '>,>=,<,<=' operators.
  • QueueTime supports the '>,>=,<,<=' operators.
  • Reason supports the '=' operator.
  • RepositoryId supports the '=' operator.
  • RepositoryType supports the '=' operator.
  • Result supports the '=' operator.
  • SourceBranch supports the '=' operator.
  • StartTime supports the '<,<=,>,>=' operators.
  • Status supports the '=' operator.
  • Tags supports the '=,in' operators.
  • DeletedFilter supports the '=' operator.
  • Properties supports the '=,in' operators.
  • QueueId supports the '=' operator.
  • RequestedForId supports the '=' operator.
  • MaxBuildsPerDefinition supports the '=' operator.
For example:
	SELECT * FROM Builds WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073'
	SELECT * FROM Builds WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND BuildNumber = '20200401.1'
	SELECT * FROM Builds WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' ORDER BY StartTime Asc
	SELECT * FROM Builds WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Id IN (2,3,4)
	SELECT * FROM Builds WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND FinishTime > '2020-04-06 05:50:00' AND FinishTime < '2020-04-06 06:50:00'

Columns

Name Type References Description
Id [KEY] Integer Id of the Build.
AgentSpecificationIdentifier String The agent specification for the build.
BuildNumber String The build number/name of the build.
BuildNumberRevision Integer The build number revision.
ControllerCreatedDate Datetime The date the controller was created. This is only set if definition type is XAML.
ControllerDescription String The description of the controller. This is only set if definition type is XAML.
ControllerEnabled Boolean Indicates whether the controller is enabled. This is only set if definition type is XAML.
ControllerId Integer Id of the build controller. This is set only if definition type is XAML.
ControllerName String Name of the controller. This is set only if definition type is XAML.
ControllerStatus String Status of the controller. This is set only if definition type is XAML.
ControllerUpdatedDate Datetime The date the controller was last updated. This is only set if definition type is XAML.
ControllerUri String The controller URI. This is only set if definition type is XAML.
ControllerUrl String Full Http Link to the resource. This is set only if definition type is XAML.
DefinitionId Integer

BuildDefinitions.Id

The Id of the definition associated with the build.
Deleted Boolean Indicates whether the build has been deleted.
DeletedByDisplayName String This is the non-unique display name of the user.
DeletedById String The Id of the user.
DeletedByUniqueName String The Unique name of the user.
DeletedDate Datetime The date the build was deleted.
DeletedReason String The description of how the build was deleted.
FinishTime Datetime The time that the build was completed.
KeepForever Boolean Indicates whether the build should be skipped by retention policies.
LastChangedByDisplayName String This is the non-unique display name of the user.
LastChangedById String The Id of the user.
LastChangedByUniqueName String The Unique name of the user.
LastChangedDate Datetime The date the build was last changed.
LinksBadgeHref String Badge reference link.
LinksSelfHref String Self reference link.
LinksSourceVersionDisplayUriHref String Source version display Uri reference link.
LinksTimelineHref String Timeline reference link.
LinksWebHref String Web reference link.
LogsId Integer The Id of the log.
LogsType String The type of the log location.
LogsUrl String A full link to the log resource.
OrchestrationPlanId String The ID of the plan.
OrchestrationPlanType Integer The type of the plan.
Parameters String The parameters for the build.
Priority String The build's priority.
ProjectId String

Projects.Id

Project identifier.
Properties String The class represents a property bag as a collection of key-value pairs.
Quality String The quality of the XAML build (good, bad, etc.).
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.
QueueOptions String Additional options for queueing the build.
QueuePosition Integer The current position of the build in the queue.
QueueTime Datetime The time that the build was queued.
Reason String The reason that the build was create.

The allowed values are all, batchedCI, buildCompletion, checkInShelveset, individualCI, manual, none, pullRequest, schedule, scheduleForced, triggered, userCreated, validateShelveset.

RepositoryId String

Repositories.Id

The Id of the repository.
RepositoryType String Type of the repository.
RequestedByDisplayName String This is the non-unique display name of the user.
RequestedById String The Id of the user.
RequestedByUniqueName String The Unique name of the user.
RequestedForDisplayName String This is the non-unique display name of the user.
RequestedForId String The Id of the user.
RequestedForUniqueName String The Unique name of the user.
Result String The build result.

The allowed values are canceled, failed, none, partiallySucceeded, succeeded.

RetainedByRelease Boolean Indicates whether the build is retained by a release.
SourceBranch String The source branch.
SourceVersion String The source version.
StartTime Datetime The time that the build was started.
Status String The status of the build.

The allowed values are all, cancelling, completed, inProgress, none, notStarted, postponed.

Tags String The tags associated with this build.
TriggerInfo String Sourceprovider-specific information about what triggered the build.
TriggeredByBuildId Integer The build that triggered this build via a Build completion trigger.
Uri String The URI of the build.
Url String The REST URL of the build.

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
DeletedFilter String Indicates whether to exclude, include, or only return deleted builds.

The allowed values are excludeDeleted, includeDeleted, onlyDeleted.

MaxBuildsPerDefinition Integer The maximum number of builds to return per definition.

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