Commits
Contains metadata for commits in a repository, including author information, timestamps, and commit messages for version tracking.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- BranchName supports the '=,IN' comparison operators.
- CommittedDate supports the '=,>=,>,<,<=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [Commits]
SELECT * FROM [Commits] WHERE [BranchName] = 'Val1'
SELECT * FROM [Commits] WHERE [CommittedDate] = '2023-01-01 11:10:00'
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier for the commit. | ||
| Oid | String | The Git object ID, uniquely identifying this commit in the Git repository. | ||
| AbbreviatedOid | String | An abbreviated version of the Git object ID, commonly used for easier reference. | ||
| BranchName [KEY] | String |
Branches.Name | The name of the branch where the commit was made. | |
| ChangedFilesIfAvailable | Int | The number of files changed in this commit. Returns 'null' if the number can't be calculated. | ||
| Additions | Int | The total number of lines added in this commit. | ||
| Deletions | Int | The total number of lines removed in this commit. | ||
| AuthoredByCommitter | Bool | Indicates whether the author and the committer of this commit are the same. | ||
| CommittedViaWeb | Bool | Indicates whether this commit was made through GitHub's web UI. | ||
| AuthoredDate | Datetime | The date and time when this commit was authored. | ||
| CommittedDate | Datetime | The date and time when this commit was actually committed. | ||
| ViewerSubscription | String | Indicates the subscription status of the viewer (for example, watching, not watching, ignoring) for this commit's repository. | ||
| ViewerCanSubscribe | Bool | Indicates whether the viewer has the ability to change their subscription status for the repository. | ||
| Message | String | The main message or description of the changes made in this commit. | ||
| MessageBody | String | The full body text of the commit message. | ||
| MessageHeadline | String | The headline or short summary of the commit message. | ||
| MessageBodyHTML | String | The body of the commit message rendered as HTML. | ||
| MessageHeadlineHTML | String | The headline of the commit message rendered as HTML. | ||
| ResourcePath | String | The HTTP path for this specific commit. | ||
| CommitResourcePath | String | The HTTP path for the Git object associated with this commit. | ||
| TreeResourcePath | String | The HTTP path for accessing the tree structure of the commit. | ||
| Url | String | The HTTP URL that leads to this commit's page. | ||
| CommitUrl | String | The URL for accessing this specific Git object in the repository. | ||
| TarballUrl | String | The URL to download a tarball archive of the repository. (Links expire after five minutes for private repositories.) | ||
| TreeUrl | String | The HTTP URL for accessing the tree structure of this commit. | ||
| ZipballUrl | String | The URL to download a zipball archive of the repository. (Links expire after five minutes for private repositories.) | ||
| AuthorName | String | The name of the author who authored the commit. | ||
| AuthorEmail | String | The email address of the commit author. | ||
| AuthorDate | Datetime | The timestamp when the commit was authored (Git action). | ||
| AuthorUserLogin | String | The GitHub username corresponding to the email address associated with this commit. Null if no user is found. | ||
| CommitterName | String | The name of the committer who committed the changes. | ||
| CommitterEmail | String | The email address of the person who committed the changes. | ||
| CommitterDate | Datetime | The timestamp indicating when the commit was committed. | ||
| CommitterUserLogin | String | The GitHub username corresponding to the email address of the committer. Null if no user is found. | ||
| OnBehalfOfId | String | The unique ID of the organization this commit was made on behalf of. | ||
| OnBehalfOf | String | The login name of the organization this commit was made on behalf of. | ||
| SignatureIsValid | Bool | Indicates whether the commit's signature is valid and verified by GitHub. | ||
| Signature | String | The ASCII-armored signature header used in this commit. | ||
| SignatureEmail | String | The email address associated with the signature for this commit. | ||
| SignaturePayload | String | The payload used for the GPG signature. Represents the raw ODB object without the signature header. | ||
| SignatureState | String | The state of the signature. 'VALID' indicates that the signature is valid, and other states indicate why the signature is considered invalid. | ||
| SignatureSigner | String | The GitHub username of the person who signed this commit. | ||
| WasSignedByGitHub | Bool | Indicates whether the commit was signed using GitHub's signing key. | ||
| StatusId | String | The unique ID of the commit status associated with this commit. | ||
| StatusState | String | The overall status of the commit, combining various checks and statuses. | ||
| StatusCheckRollupId | String | The unique ID for the Check and Status rollup associated with this commit. | ||
| StatusCheckRollupState | String | The combined state of the Check and Status rollup for this commit. | ||
| TreeId | String | The unique ID of the root tree object for this commit. | ||
| TreeOid | String | The Git object ID of the tree associated with this commit. | ||
| TreeAbbreviatedOid | String | An abbreviated version of the Git object ID of the tree. | ||
| TreeCommitUrl | String | The HTTP URL to view the tree object associated with this commit. | ||
| TreeCommitResourcePath | String | The HTTP path to access the tree object associated with this commit. |