Retrieves a list of drafts associated with the specific definition.

Table Specific Information

Select

The connector 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 connector.

NOTE: DefinitionId is required in order to query BuildDefinitionDrafts.

For example:

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

Insert

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')

Update

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'

Delete

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'

Columns

Name	Type	ReadOnly	References	Description
ProjectId	String	True		Id of the project.
DefinitionId	Integer	False	BuildDefinitions.Id	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	Repositories.Id	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.