SSIS Components for Azure DevOps

Build 24.0.9063

Releases

Retrieves a list of releases.

Table Specific Information

Select

The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • 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.

The rest of the filter is executed client-side in the 本製品.

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'

Insert

The following is an example of inserting into Releases table. For example:

INSERT INTO ReleaseArtifacts#TEMP (Alias, BuildVersionId, BuildVersionName) VALUES ('cdata1', 1, 'cdata')
INSERT INTO ReleaseArtifacts#TEMP (Alias, BuildVersionId, BuildVersionName) VALUES ('cdata2', 2, 'cdata33')
INSERT INTO Releases (ProjectId, Reason, Description, ReleaseArtifacts) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'creating release object', 'HelloCdata1', releaseArtifacts#TEMP)

Update

The following is an example of updating a Releases table:

UPDATE Releases SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the release.

Links String True

Aggregate of the reference links.

Comment String True

Release comment.

CreatedByDisplayName String True

The display name of the user who created this release.

CreatedById String True

The Id of the user who created this release.

CreatedByUrl String True

The URL of the user who created this release.

CreatedOn Datetime True

The date on which it was created.

DefinitionSnapshotRevision Integer True

Revision number of definition snapshot.

Description String False

Description of release.

KeepForever Boolean True

Whether to exclude the release from retention policies.

LogsContainerUrl String True

Logs container url.

ModifiedByDisplayName String True

The display name of the user who modified this release.

ModifiedById String True

The id of the user who modified this release.

ModifiedByUrl String True

The URL of the user who modified this release.

ModifiedOn Datetime True

The date on which it got modified.

Name String True

Release name.

PoolName String True

Pool name.

ProjectId String True

Id of the project.

ProjectName String True

Name of the project.

Properties String False

Release properties.

Reason String False

Reason of release.

ReleaseDefinitionId Integer True

ReleaseDefinitions.Id

Id of the release definition.

ReleaseDefinitionName String True

Name of the release definition.

ReleaseDefinitionUrl String True

URL of the release definition.

ReleaseDefinitionRevision Integer True

The release definition revision.

ReleaseNameFormat String True

The release name format.

Status String True

Release status.

使用できる値は次のとおりです。abandoned, active, draft, undefined

Tags String True

List of tags.

TriggeringArtifactAlias String True

Triggering artifact alias.

Url String True

The URL of the release.

Variables String False

The dictionary of variables.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

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.

使用できる値は次のとおりです。none, tags, variables

ReleaseArtifacts String

The property that should be expanded in the list of releases.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063