JDBC Driver for Azure DevOps

Build 22.0.8462

ReleaseDefinitionArtifacts

Retrieves a list of release definition 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.
  • DefinitionId supports the '=,in' operators.

The rest of the filter is executed client-side in the driver.

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

ReleaseDefinitions.Id

Id of the release.

ProjectId String True

Projects.Id

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462