FireDAC Components for Azure DevOps

Build 21.0.7930

Releases

Retrieves a list of releases.

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.
  • CreatedOn supports the '>,>=,<,<=' operators.
  • ProjectId supports the '=' operator.
  • ReleaseDefinitionId supports the '=' operator.
  • Status supports the '=' operator.
  • Tags supports the '=,in' operators.
  • Properties supports the '=,in' operators.
  • IsDeleted supports the '=' operator.
  • SourceBranch supports the '=' operator.
  • ArtifactVersionId supports the '=' operator.
  • ArtifactTypeId supports the '=' operator.
  • EnvironmentStatus supports the '=' operator.
  • DefinitionEnvironmentId supports the '=' operator.
  • SearchText supports the '=' operator.
  • SourceId supports the '=' operator.
  • Path supports the '=' operator.
  • TopGateRecoards supports the '=' operator.
  • Expand supports the '=' operator.
For example:
	SELECT * FROM Releases WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073'
	SELECT * FROM Releases WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Id = 1
    SELECT * FROM Releases WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND CreatedOn >= '2000-01-01'
	SELECT * FROM Releases WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Expand = 'Variables'

Columns

Name Type References Description
Id [KEY] Integer Id of the release.
LinksSelfHref String Self reference links.
LinksWebHref String Web reference links.
Comment String Release comment.
CreatedByDisplayName String The display name of the user who created this release.
CreatedById String The Id of the user who created this release.
CreatedByImageUrl String The image URL of the user who created this release.
CreatedByUniqueName String The unique name of the user who created this release.
CreatedByUrl String The URL of the user who created this release.
CreatedOn Datetime The date on which it was created.
DefinitionSnapshotRevision Integer Revision number of definition snapshot.
Description String Description of release.
KeepForever Boolean Whether to exclude the release from retention policies.
LogsContainerUrl String Logs container url.
ModifiedByDisplayName String The display name of the user who modified this release.
ModifiedById String The id of the user who modified this release.
ModifiedByImageUrl String The image URL of the user who modified this release.
ModifiedByUniqueName String The unique Name of the user who modified this release.
ModifiedByUrl String The URL of the user who modified this release.
ModifiedOn Datetime The date on which it got modified.
Name String Release name.
PoolName String Pool name.
ProjectId String

Projects.Id

Id of the project.
ProjectName String Name of the project.
Properties String Release properties.
Reason String Reason of release.
ReleaseDefinitionId Integer

ReleaseDefinitions.Id

Id of the release definition.
ReleaseDefinitionName String Name of the release definition.
ReleaseDefinitionUrl String URL of the release definition.
ReleaseDefinitionRevision Integer The release definition revision.
ReleaseNameFormat String The release name format.
Status String Release status.

The allowed values are abandoned, active, draft, undefined.

Tags String List of tags.
TriggeringArtifactAlias String Triggering artifact alias.
Url String The URL of the release.
Variables String The dictionary of variables.

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
IsDeleted Boolean Gets the soft deleted releases, if true.
SourceBranch String Releases with given sourceBranchFilter will be returned.
ArtifactVersionId String Releases with given artifactVersionId will be returned.
ArtifactTypeId String Releases with given artifactTypeId will be returned.
EnvironmentStatus Integer Environment status filter.
DefinitionEnvironmentId Integer Id of the definition environment.
SearchText String Releases with names containing searchText.
SourceId String Unique identifier of the artifact used.
Path String Releases under this folder path will be returned.
TopGateRecords Integer Number of release gate records to get.
Expand String The property that should be expanded in the list of releases.

The allowed values are none, tags, variables.

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