ReleaseArtifacts
Retrieves a list of release artifacts.
Table Specific Information
Select
The connector 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 connector.
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. |