ReleaseApprovals
Retrieves a list of approvals..
Table Specific Information
Select
The driver uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- ApprovalType supports the '=' operator.
- ReleaseId supports the '=,in' operators.
- Status supports the '<,<=,>,>=' operators.
- AssignedTo supports the '=' operator.
- IncludeMyGroupApprovals supports the '=' operator.
The rest of the filter is executed client-side in the driver.
For example:
SELECT * FROM ReleaseApprovals WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Status > 'pending'
Update
The following is an example of updating a ReleaseApprovals table:
UPDATE ReleaseApprovals SET Status = 'approved', Comments = 'Good to go!' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Id of the approval. | |
ProjectId | String | True |
Id of the project. | |
ApprovalType | String | False |
The type of approval. The allowed values are all, postDeploy, preDeploy, undefined. | |
ApprovedByDisplayName | String | False |
The display name of the user who approved. | |
ApprovedById | String | False |
The Id of the user who approved. | |
ApprovedByUrl | String | False |
The URL of the user who approved. | |
ApproverDisplayName | String | False |
The display name of the user who should approve. | |
ApproverId | String | False |
The Id of the user who should approve. | |
ApproverUrl | String | False |
The URL of the user who should approve. | |
Attempt | Integer | False |
This specifies as which deployment attempt it belongs. | |
Comments | String | False |
Comments for approval. | |
CreatedOn | Datetime | False |
The date on which it was created. | |
IsAutomated | Boolean | False |
Indicates whether approval is automated or not. | |
IsNotificationOn | Boolean | True |
Indicates whether notification is on or not. | |
ModifiedOn | Datetime | False |
The date on which it got modified. | |
Rank | Integer | False |
Specifies the order of the approval. | |
ReleaseId | Integer | False |
Id of the release. | |
ReleaseName | String | False |
Name of the release. | |
ReleaseUrl | String | False |
URL of the release. | |
ReleaseDefinitionId | Integer | False |
Id of the release definition. | |
ReleaseDefinitionName | String | False |
Name of the release definition. | |
ReleaseDefinitionUrl | String | False |
URL of the release definition. | |
ReleaseEnvironmentId | Integer | False |
Id of the release environment. | |
ReleaseEnvironmentName | String | False |
Name of the release environment. | |
ReleaseEnvironmentUrl | String | False |
URL of the release environment. | |
Revision | Integer | False |
The revision number. | |
Status | String | False |
The status of the approval. | |
TrialNumber | Integer | True |
The trial number. | |
Url | String | False |
The URL to access the approval. |
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 |
AssignedTo | String |
Approvals assigned to this user. |
IncludeMyGroupApprovals | Boolean |
Include my group approvals. |