JDBC Driver for Azure DevOps

Build 22.0.8462

CommitChanges

Retrieve changes for a particular 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.
The rest of the filter is executed client-side in the driver.


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

Projects.Id

Id of the project.
RepositoryId String

Repositories.Id

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.8462