ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieve changes for a particular commit.

Table Specific Information


The 本製品 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 本製品.

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'


Name Type References Description
CommitId String


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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479