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