BuildDefinitionDrafts
Retrieves a list of drafts associated with the specific definition.
Table Specific Information
Select
The driver 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.
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 |
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. |