ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieve statistics about all branches within a repository.

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.
  • Name supports the '=' operator.
  • VersionOptions supports the '=' operator.
  • Version supports the '=' operator.
  • VersionType supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

NOTE: RepositoryId is required in order to query GitStats.

For example:

    SELECT * FROM GitStats WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051'
	SELECT * FROM GitStats WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND VersionOptions = 'none'
	SELECT * FROM GitStats WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND Name = 'master'


Name Type References Description
Name [KEY] String Name of the branch.
ProjectId String


Id of the project.
RepositoryId String


Id of the repository.
AheadCount Integer Number of commits ahead.
BehindCount Integer Number of commits behind.
CommitId String ID (SHA-1) of the commit.
IsBaseVersion Boolean Indicates whether this is base version.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
VersionOptions String Version options - Specify additional modifiers to version (e.g Previous).

使用できる値は次のとおりです。firstParent, none, previousChange

Version String Version string identifier (name of tag/branch, SHA1 of commit).
VersionType String Version type (branch, tag, or commit). Determines how Id is interpreted.

使用できる値は次のとおりです。branch, commit, tag

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