ReleaseDefinitions
Retrieves a list of release definitions.
Table Specific Information
Select
The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- 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.
The rest of the filter is executed client-side in the connector.
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'
Insert
The following are examples of inserting into ReleaseDefinitions table. For example:
INSERT INTO ReleaseDefinitionArtifacts#TEMP (Alias, IsPrimary) VALUES ('cdata1', false)
INSERT INTO ReleaseDefinitionArtifacts#TEMP (Alias, IsPrimary) VALUES ('cdata2', true)
INSERT INTO ReleaseDefinitions (Revision, Source, ProjectId, Name, Comment, Description, ReleaseDefinitionArtifacts) VALUES (1, undefined, 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', cdata, 'demo request to create release definitions', 'HelloCdata1', ReleaseDefinitionArtifacts#TEMP)
Update
The following is an example of updating a ReleaseDefinitions table:
UPDATE ReleaseDefinitions SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'
Delete
The following is an example of deleting data in a ReleaseDefinitions table:
DELETE FROM ReleaseDefinitions WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
Id of the release definition. | |
| Links | String | True |
Aggregate of the reference links. | |
| Comment | String | False |
Comment on the release definition. | |
| CreatedByDisplayName | String | False |
The non unique display name of the user who created this release definition. | |
| CreatedById | String | False |
The Id of the user. | |
| CreatedByUrl | String | False |
The URL of the user. | |
| CreatedOn | Datetime | False |
The date on which it got created. | |
| Description | String | False |
The description of the release definition. | |
| IsDeleted | Boolean | False |
Whether release definition is deleted. | |
| LastReleaseCreatedByDisplayName | String | False |
The non-unique display name of the user who created last release. | |
| LastReleaseCreatedById | String | False |
The Id of the user who created last release. | |
| LastReleaseCreatedByUrl | String | False |
The URL of the user who created last release. | |
| LastReleaseCreatedOn | Datetime | False |
The date on which the last release was created. | |
| LastReleaseDescription | String | False |
The description of the last release. | |
| LastReleaseId | Integer | False |
The Id of the last release. | |
| LastReleaseModifiedById | String | False |
The Id of the user who modified the last release. | |
| LastReleaseName | String | False |
The name of the last release. | |
| LastReleaseReason | String | False |
The reason of the last release. | |
| LastReleaseReleaseDefinitionId | Integer | False |
The Id of the release definition of the last release. | |
| LastReleaseWebAccessUri | String | False |
The web access URI of the last release. | |
| ModifiedByDisplayName | String | False |
The non-unique display name of the user who modified this release definition. | |
| ModifiedById | String | False |
The Id of the user who modified this release definition. | |
| ModifiedByUrl | String | False |
The URL of the user who modified this release definition. | |
| ModifiedOn | Datetime | False |
The date on which it got modified. | |
| Name | String | False |
The name of the release definition. | |
| Path | String | False |
The Path of the release definition. | |
| ProjectId | String | False |
Id of the Project. | |
| ProjectName | String | False |
Name of the Project. | |
| Properties | String | False |
The list of properties associated with this definition. | |
| ReleaseNameFormat | String | False |
The release name format. | |
| Revision | Integer | False |
The revision number. | |
| Source | String | False |
The source of the release definition. | |
| Tags | String | False |
The list of tags. | |
| Triggers | String | False |
The list of triggers. | |
| Url | String | False |
REST API URL to access the release definition. | |
| VariableGroups | String | False |
The list of variable groups. | |
| Variables | String | False |
Release Definition Variables. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| 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. 使用できる値は次のとおりです。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. |
| ReleaseDefinitionArtifacts | String |
List of artifacts for release definition object. |