GitStats
Retrieve statistics about all branches within a repository.
Table Specific Information
Select
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.
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 |