Retrieve statistics about all branches within a repository.

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.
• 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 connector.

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'

Columns

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.

Pseudo-Columns

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