SSIS Components for Azure DevOps

Build 24.0.9063

ReleaseApprovals

Retrieves a list of approvals..

Table Specific Information

Select

The 本製品 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 本製品.

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.

使用できる値は次のとおりです。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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name Type Description
AssignedTo String

Approvals assigned to this user.

IncludeMyGroupApprovals Boolean

Include my group approvals.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063