Releases
Retrieves a list of releases.
Table Specific Information
Select
The provider 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 provider.
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 |
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. The allowed values are 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
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. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
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. |
ReleaseArtifacts | String |
The property that should be expanded in the list of releases. |