CommitChanges
Retrieve changes for a particular commit.
Table Specific Information
Select
The provider 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 CommitChanges.
For example:
SELECT * FROM CommitChanges WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND CommitId = '01832416d11f521e2e8fa1dc3acd9aebd93c773f' SELECT * FROM CommitChanges WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND CommitId = '01832416d11f521e2e8fa1dc3acd9aebd93c773f'
Columns
Name | Type | References | Description |
CommitId | String |
Commits.Id | Id of the commit. |
ProjectId | String | Id of the project. | |
RepositoryId | String | Id of the repository. | |
ChangeType | String | The type of change that was made to the item. | |
ItemGitObjectType | String | Git object type. | |
ItemObjectId | String | Change object Id. | |
ItemIsFolder | Boolean | Indicates whether its a folder. | |
ItemPath | String | Path of the change. | |
ItemUrl | String | URL of the commit change. |