ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a list of drafts associated with the specific definition.

Table Specific Information


The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • DefinitionId supports the '=' operator.
  • ProjectId supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

NOTE: DefinitionId is required in order to query BuildDefinitionDrafts.

For example:

    SELECT * FROM BuildDefinitionDrafts WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND DefinitionId = 2


The following is an example of inserting into a BuildDefinitionDrafts table. For example:

INSERT INTO BuildDefinitionDrafts (projectId,Name,RepositoryId,RepositoryType,ProcessYamlFilename) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937',cdata11211,'e50698d4-bb6e-400f-a1a0-5f4d17517d9e',TfsGit,'data.txt')


The following is an example of updating a BuildDefinitionDrafts table:

UPDATE BuildDefinitionDrafts SET Name = 'Shubham2', revision = 1, RepositoryId = 'e50698d4-bb6e-400f-a1a0-5f4d17517d9e', ProcessYamlFilename = 'data.txt', RepositoryType = 'TfsGit' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND DefinitionId = '1'


The following is an example of deleting data in a BuildDefinitionDrafts table:

DELETE FROM BuildDefinitionDrafts WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Definitionid = '1'


Name Type ReadOnly References Description
ProjectId String True


Id of the project.

DefinitionId Integer False


Id of the build definition.

CreatedDate Integer False

The date this version of the definition was created.

Id [KEY] Integer True

The Id of the referenced definition.

Name String False

The name of the referenced definition.

Path String False

The folder path of the definition.

QueueStatus String False

A value that indicates whether builds can be queued against this definition.

Revision Integer False

The definition revision number.

Type String False

The type of the definition.

Uri String False

The definition's URI.

Url String False

The REST URL of the definition.

RepositoryId String False


The ID of the repository.

RepositoryType String False

The type of the repository.

ProcessType Integer False

The process type.

ProcessYamlFilename String False

The process YAML file name.

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