BuildWorkItems
Retrieves a list of work items associated with a build.
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.
- BuildId supports the '=,>=,>,<=,<' operators.
NOTE: BuildId is required in order to query BuildWorkItems.
For example:
SELECT * FROM BuildChanges WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND BuildId = 3 SELECT * FROM BuildWorkItems WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND BuildId > 3 AND BuildId < 6
Columns
Name | Type | References | Description |
Id [KEY] | String | Id of the work item. | |
Url | String | URL of the work item. | |
ProjectId | String |
Projects.Id | Id of the project. |
BuildId | Integer |
Builds.Id | Id of the builds. |