Commits
Retrieve git commits for a project.
Table Specific Information
Select
The add-in 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 | 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). |