JDBC Driver for Azure DevOps

Build 22.0.8462

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

Projects.Id

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.

ApprovedByImageUrl String False

The image Url of the user who approved.

ApprovedByUniqueName String False

The Unique name 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.

ApproverImageUrl String False

The image URL of the user who should approve.

ApproverUniqueName String False

The unique name 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.

Name Type Description
AssignedTo String

Approvals assigned to this user.

IncludeMyGroupApprovals Boolean

Include my group approvals.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462