CommitWorkItems
Retrieve work items for the specific commit.
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.
- RepositoryId supports the '=' operator.
- CommitId supports the '=' operator.
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 |
Projects.Id | Id of the project. |
RepositoryId | String |
Repositories.Id | Id of the repository. |
CommitId | String |
Commits.Id | Id of the commit. |
Url | String | URL of the work item. |