FireDAC Components for Azure DevOps

Build 21.0.7930

ReleaseApprovals

Retrieves a list of approvals..

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • 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.
For example:
	SELECT * FROM ReleaseApprovals WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Status > 'pending'	

Columns

Name Type References Description
Id [KEY] Integer Id of the approval.
ProjectId String

Projects.Id

Id of the project.
ApprovalType String The type of approval.

The allowed values are all, postDeploy, preDeploy, undefined.

ApprovedByDisplayName String The display name of the user who approved.
ApprovedById String The Id of the user who approved.
ApprovedByImageUrl String The image Url of the user who approved.
ApprovedByUniqueName String The Unique name of the user who approved.
ApprovedByUrl String The URL of the user who approved.
ApproverDisplayName String The display name of the user who should approve.
ApproverId String The Id of the user who should approve.
ApproverImageUrl String The image URL of the user who should approve.
ApproverUniqueName String The unique name of the user who should approve.
ApproverUrl String The URL of the user who should approve.
Attempt Integer This specifies as which deployment attempt it belongs.
Comments String Comments for approval.
CreatedOn Datetime The date on which it was created.
IsAutomated Boolean Indicates whether approval is automated or not.
IsNotificationOn Boolean Indicates whether notification is on or not.
ModifiedOn Datetime The date on which it got modified.
Rank Integer Specifies the order of the approval.
ReleaseId Integer Id of the release.
ReleaseName String Name of the release.
ReleaseUrl String URL of the release.
ReleaseDefinitionId Integer Id of the release definition.
ReleaseDefinitionName String Name of the release definition.
ReleaseDefinitionUrl String URL of the release definition.
ReleaseEnvironmentId Integer Id of the release environment.
ReleaseEnvironmentName String Name of the release environment.
ReleaseEnvironmentUrl String URL of the release environment.
Revision Integer The revision number.
Status String The status of the approval.
TrialNumber Integer The trial number.
Url String 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930