Retrieve changes for a particular commit, sliced across all repositories.

Table Specific Information

Select

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

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.