Retrieves a list of work items associated with a build.

Table Specific Information

Select

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

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

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.