ADO.NET Provider for Azure DevOps

Build 24.0.9060

GitStats

Retrieve statistics about all branches within a repository.

Table Specific Information

Select

The provider 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 provider.


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

Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.

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

The allowed values are 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.

The allowed values are branch, commit, tag.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060