FireDAC Components for Azure DevOps

Build 21.0.7930

ReleaseDefinitions

Retrieves a list of release definitions.

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.

  • Id supports the '=,in' operator.
  • ProjectId supports the '=' operator.
  • IsDeleted supports the '=' operator.
  • Path supports the '=' operator.
  • Properties supports the '=,in' operators.
  • Tags supports the '=,in' operators.
  • ArtifactSourceId supports the '=' operator.
  • ArtifactType supports the '=' operator.
  • Expand supports the '=' operator.
  • IsExactNameMatch supports the '=' operator.
  • SearchText supports the '=' operator.
  • SearchTextContainsFolderName supports the '=' operator.
For example:
	SELECT * FROM ReleaseDefinitions WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'
	SELECT * FROM ReleaseDefinitions WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' And Id = 1
	SELECT * FROM ReleaseDefinitions WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' And Tags IN ('Tag1','Tag2')
	SELECT * FROM ReleaseDefinitions WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' And Expand = 'triggers'

Columns

Name Type References Description
Id [KEY] Integer Id of the release definition.
LinksSelfHref String Self reference links.
LinksWebHref String Web reference links.
Comment String Comment on the release definition.
CreatedByDisplayName String The non unique display name of the user who created this release definition.
CreatedById String The Id of the user.
CreatedByImageUrl String The Image Url of the user.
CreatedByUniqueName String The Unique name of the user.
CreatedByUrl String The URL of the user.
CreatedOn Datetime The date on which it got created.
Description String The description of the release definition.
IsDeleted Boolean Whether release definition is deleted.
LastReleaseCreatedByDisplayName String The non-unique display name of the user who created last release.
LastReleaseCreatedById String The Id of the user who created last release.
LastReleaseCreatedByImageUrl String The Image URL of the user who created last release.
LastReleaseCreatedByUniqueName String The Unique name of the user who created last release.
LastReleaseCreatedByUrl String The URL of the user who created last release.
LastReleaseCreatedOn Datetime The date on which the last release was created.
LastReleaseDescription String The description of the last release.
LastReleaseId Integer The Id of the last release.
LastReleaseModifiedById String The Id of the user who modified the last release.
LastReleaseModifiedByUniqueName String The unique name of the user who modified the last release.
LastReleaseName String The name of the last release.
LastReleaseReason String The reason of the last release.
LastReleaseReleaseDefinitionId Integer The Id of the release definition of the last release.
LastReleaseWebAccessUri String The web access URI of the last release.
ModifiedByDisplayName String The non-unique display name of the user who modified this release definition.
ModifiedById String The Id of the user who modified this release definition.
ModifiedByImageUrl String The Image URL of the user who modified this release definition.
ModifiedByUniqueName String The Unique name of the user who modified this relase definition.
ModifiedByUrl String The URL of the user who modified this release definition.
ModifiedOn Datetime The date on which it got modified.
Name String The name of the release definition.
Path String The Path of the release definition.
ProjectId String

Projects.Id

Id of the Project.
ProjectName String Name of the Project.
Properties String The list of properties associated with this definition.
ReleaseNameFormat String The release name format.
Revision Integer The revision number.
Source String The source of the release definition.
Tags String The list of tags.
Triggers String The list of triggers.
Url String REST API URL to access the release definition.
VariableGroups String The list of variable groups.
Variables String Release Definition Variables.

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
ArtifactSourceId String Release definitions with given artifactSourceId will be returned.
ArtifactType String Release definitions with given artifactType will be returned.
Expand String The properties that should be expanded in the list of Release definitions.

The allowed values are tags, lastRelease, triggers, none.

IsExactNameMatch Boolean 'true' to gets the release definitions with exact match as specified in searchText.
SearchText String Get release definitions with names containing searchText.
SearchTextContainsFolderName Boolean 'true' to get the release definitions under the folder with name as specified in searchText.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930