ReleaseApprovals

Retrieves a list of approvals..

Table Specific Information

Select

The connector 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 connector.

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.