ReleaseDeployments
Retrieves a list of deployments.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
The rest of the filter is executed client-side in the provider.
- ProjectId supports the '=' operator.
- DefinitionEnvironmentId supports the '=' operator.
- DeploymentStatus supports the '=' operator.
- LastModifiedOn supports the '<,<=,>,>=' operators.
- OperationStatus supports the '=' operator.
- RequestedById supports the '=' operator.
- ReleaseDefinitionId supports the '=' operator.
- RequestedForId supports the '=' operator.
- StartedOn supports the '>,>=,<,<=' operators.
- LastestAttemptsOnly supports the '=' operator.
- SourceBranch supports the '=' operator.
For example:
SELECT * FROM ReleaseDeployments WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' SELECT * FROM ReleaseDeployments WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND StartedOn > '2020-04-01 12:18:51'
Columns
Name | Type | References | Description |
Id [KEY] | Integer | Id of the deployment. | |
Attempt | Integer | Attempt number. | |
CompletedOn | String | The date on which deployment is complete. | |
Conditions | String | The list of condition associated with deployment. | |
DefinitionEnvironmentId | Integer | Release definition environment Id. | |
DeploymentStatus | String | Status of the deployment.
The allowed values are all, failed, inProgress, notDeployed, partiallySucceeded, succeeded, undefined. | |
LastModifiedByDisplayName | String | The display name of the user who last modified this deployment. | |
LastModifiedById | String | The Id of the user who last modified this deployment. | |
LastModifiedByUrl | String | The URL of the user who last modified this deployment. | |
LastModifiedOn | Datetime | The date on which deployment is last modified. | |
OperationStatus | String | Operation status of deployment.
The allowed values are all, approved, canceled, cancelling, deferred, evaluatingGates, gateFailed, manualInterventionPending, pending, phaseCanceled, phaseFailed, phaseInProgress, phasePartiallySucceeded, phaseSucceeded, queued, queuedForAgent, queuedForPipeline, rejected, scheduled, undefined. | |
PostDeployApprovals | String | List of PostDeployApprovals. | |
PreDeployApprovals | String | List of PreDeployApprovals. | |
ProjectId | String | Id of the project. | |
ProjectName | String | Name of the project. | |
QueuedOn | Date | The date on which deployment is queued. | |
Reason | String | Reason of deployment. | |
ReleaseId | Integer | The Id of the release. | |
ReleaseDefinitionId | Integer | The Id of the release definition. | |
ReleaseDefinitionName | String | The Name of the release definition. | |
ReleaseDefinitionPath | String | The Path of the release definition. | |
ReleaseEnvironmentId | Integer | The Id of the release environment. | |
ReleaseEnvironmentName | String | The Name of the release environment. | |
ReleaseEnvironmentUrl | String | The URL of the release environment. | |
RequestedByDisplayName | String | The Display name of the user who requested. | |
RequestedById | String | The Id of the user who requested. | |
RequestedByUrl | String | The URL of the user who requested. | |
RequestedForDisplayName | String | The display name of the user for whom deployment is requested. | |
RequestedForId | String | The Id of the user for whom deployment is requested. | |
RequestedForUrl | String | The URL of the user for whom deployment is requested. | |
ScheduledDeploymentTime | Date | The date on which deployment is scheduled. | |
StartedOn | Datetime | The date on which deployment is started. |
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 | |
LatestAttemptsOnly | Boolean | Includes latest attempts only. | |
SourceBranch | String | Source branch. |