ReleaseArtifacts
Retrieves a list of release artifacts.
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.
- ReleaseId supports the '=,in' operators.
The rest of the filter is executed client-side in the driver.
NOTE: ReleaseId is required in order to query ReleaseArtifacts.
For example:
SELECT * FROM ReleaseArtifacts WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND ReleaseId = 2
Columns
Name | Type | References | Description |
ReleaseId [KEY] | Integer |
Releases.Id | Id of the release. |
ProjectId | String | Id of the project. | |
Alias | String | Artifact alias. | |
DefinitionReference | String | Definition reference of the artifact. | |
IsPrimary | Boolean | Indicates whether artifact is primary or not. | |
IsRetained | Boolean | Indicates whether artifact is retained by release or not. | |
SourceId | String | Id of the source. | |
Type | String | Type of the artifact. | |
BuildVersionId | String | Sets the build id. | |
BuildVersionCommitMessage | String | commit message for the artifact. | |
BuildVersionName | String | Sets the build number. |