Retrieve changes for a particular commit.

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.
• RepositoryId supports the '=' operator.
• CommitId supports the '=' operator.

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

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.