ReleaseDefinitionArtifacts
Retrieves a list of release definition 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.
- DefinitionId supports the '=,in' operators.
The rest of the filter is executed client-side in the connector.
NOTE: DefinitionId is required in order to query ReleaseDefinitionArtifacts.
For example:
SELECT * FROM ReleaseDefinitionArtifacts WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND DefinitionId IN (1, 2, 3)
Columns
| Name | Type | ReadOnly | References | Description |
| DefinitionId [KEY] | Integer | True |
Id of the release. | |
| ProjectId | String | True |
Id of the project. | |
| Alias | String | False |
Artifact alias. | |
| DefinitionReference | String | False |
Definition reference of the artifact. | |
| IsPrimary | Boolean | False |
Indicates whether artifact is primary or not. | |
| IsRetained | Boolean | False |
Indicates whether artifact is retained by release or not. | |
| SourceId | String | True |
Id of the source. | |
| Type | String | False |
Type of the artifact. |