Retrieve work items for the specific commit.

Table Specific Information

Select

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

• ProjectId supports the '=' operator.
• RepositoryId supports the '=' operator.
• CommitId supports the '=' operator.

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

NOTE: RepositoryId and CommitId are required in order to query CommitWorkItems.

For example:

	SELECT * FROM CommitWorkItems WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND CommitId = '01832416d11f521e2e8fa1dc3acd9aebd93c773f'

Columns

Name	Type	References	Description
Id [KEY]	String		Id of the work item.
ProjectId	String		Id of the project.
RepositoryId	String		Id of the repository.
CommitId	String	Commits.Id	Id of the commit.
Url	String		URL of the work item.