ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieve git status for the specific commit.

Table Specific Information


The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • CommitId supports the '=' operator.
  • ProjectId supports the '=' operator.
  • RepositoryId supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

NOTE: RepositoryId and CommitId are required in order to query CommitGitStatus.

For example:

	SELECT * FROM CommitGitStatus WHERE RepositoryId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' 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.
ContextGenre String Genre of the status. Typically name of the service/tool generating the status, can be empty.
ContextName String Name identifier of the status.
CreatedByDisplayName String The non-unique display name of the user who created the status.
CreatedById String The Id of the user who created the status.
CreatedByImageUrl String The image Url of the user who created the status.
CreatedByUniqueName String The unique name of the user who created the status.
CreationDate Datetime Creation date and time of the status.
Description String Status description. Typically describes current state of the status.
Id Integer Id of the status.
State String State of the status.
TargetUrl String URL with status details.
UpdatedDate Datetime Last updated date and time of the status.

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