Commits
Retrieve git commits for a project, sliced across all repositories.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' operator.
- ProjectId supports the '=' operator.
- RepositoryId supports the '=' operator.
- AuthorName supports the '=' operator.
- CommitterName supports the '=' operator.
- PushId supports the '=' operator.
- ExcludeDeletes supports the '=' operator.
- HistoryMode supports the '=' operator.
- IncludePushData supports the '=' operator.
- IncludeLinks supports the '=' operator.
- ItemPath supports the '=' operator.
- VersionType supports the '=' operator.
- Version supports the '=' operator.
- VersionOptions supports the '=' operator.
- CompareVersionType supports the '=' operator.
- CompareVersion supports the '=' operator.
- CompareVersionOptions supports the '=' operator.
- FromCommitId supports the '=' operator.
- ToCommitId supports the '=' operator.
NOTE: RepositoryId is required in order to query Commits.
For example:
SELECT * FROM Commits WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' SELECT * FROM Commits WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND Id = '01832416d11f521e2e8fa1dc3acd9aebd93c773f' SELECT * FROM Commits WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND IncludePushData = true
Columns
Name | Type | References | Description |
Id [KEY] | String | Id of the commit. | |
ProjectId | String | Id of the project. | |
RepositoryId | String |
Repositories.Id | Id of the repository. |
AuthorDate | Datetime | Date of the Git operation. | |
AuthorEmail | String | Email address of the user performing the Git operation. | |
AuthorName | String | Name of the user performing the Git operation. | |
ChangeCountsAdd | String | Counts of the types of changes (edits, deletes, etc.) included with the commit. | |
ChangeCountsEdit | String | Counts of the types of changes (edits, deletes, etc.) included with the commit. | |
ChangeCountsDelete | String | Counts of the types of changes (edits, deletes, etc.) included with the commit. | |
Comment | String | Comment or message of the commit. | |
CommentTruncated | Boolean | Indicates if the comment is truncated from the full Git commit comment message. | |
CommitterDate | Datetime | Date of the Git operation. | |
CommitterEmail | String | Email address of the user performing the Git operation. | |
CommitterName | String | Name of the user performing the Git operation. | |
Links | String | Aggregate of the reference links. | |
LinkedWorkItems | String | List of linked WorkItem Ids. | |
Parents | String | An enumeration of the parent commit IDs for this commit. | |
PushDate | Datetime | Date of the commit push. | |
PushedByDisplayName | String | This is the non-unique display name of the user. | |
PushedById | String | Id of the user. | |
PushedByUrl | String | The URL of the user resource. | |
PushId | Integer | The Id of the commit push. | |
RemoteUrl | String | Remote URL path to the commit. | |
Url | String | REST URL for this resource. |
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 | |
FromCommitId | String | A lower bound for filtering commits alphabetically. | |
ToCommitId | String | An upper bound for filtering commits alphabetically. | |
ExcludeDeletes | Boolean | Only applies when an itemPath is specified. This determines whether to exclude delete entries of the specified path. | |
HistoryMode | String | What Git history mode should be used. This only applies to the search criteria when Ids = null and an itemPath is specified.
The allowed values are firstParent, fullHistory, fullHistorySimplifyMerges, simplifiedHistory. | |
IncludePushData | Boolean | Whether to include the push information. | |
IncludeLinks | Boolean | Whether to include the links. | |
ItemPath | String | Path of item to search under. | |
VersionType | String | Version type (branch, tag, or commit). Determines how Id is interpreted. | |
Version | String | Version string identifier (name of tag/branch, SHA1 of commit). | |
VersionOptions | String | Version options - Specify additional modifiers to version (e.g Previous). | |
CompareVersionType | String | Version type (branch, tag, or commit). Determines how Id is interpreted. | |
CompareVersion | String | Version string identifier (name of tag/branch, SHA1 of commit). | |
CompareVersionOptions | String | Version options - Specify additional modifiers to version (e.g Previous). |