RepositoryCommits
Lists information about commits in repositories.
View-Specific Information
Select
The driver uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators.
- CommittedDate supports the =, >=, >, =, <, <= comparison operators.
- OwnerLogin supports the =, IN comparison operators.
When querying RepositoryCommits, applying the following filters are recommended to improve query efficiency:
- BranchName supports the =, IN comparison operators.
- RepositoryName supports the =, IN comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [RepositoryCommits]
SELECT * FROM [RepositoryCommits] WHERE [CommittedDate] = '2023-01-01 11:10:00'
SELECT * FROM [RepositoryCommits] WHERE [BranchName] = 'Val1'
SELECT * FROM [RepositoryCommits] WHERE [RepositoryName] = 'Val1'
SELECT * FROM [RepositoryCommits] WHERE [OwnerLogin] = 'Val1'
The driver processes other filters client-side within the driver.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The ID of the commit. | |
| Oid | String | True |
The Git object ID. | |
| AbbreviatedOid | String | True |
An abbreviated version of the Git object ID. | |
| BranchName [KEY] | String | False |
RepositoryBranches.Name |
The name of the branch. |
| ChangedFilesIfAvailable | Int | True |
The number of changed files in this commit. If GitHub is unable to calculate the number of changed files (for example due to a timeout), this will return 'null'. We recommend using this field instead of 'changedFiles'. | |
| Additions | Int | True |
The number of additions in this commit. | |
| Deletions | Int | True |
The number of deletions in this commit. | |
| AuthoredByCommitter | Bool | True |
Check if the committer and the author match. | |
| CommittedViaWeb | Bool | True |
Check if committed via GitHub web UI. | |
| AuthoredDate | Datetime | True |
The datetime when this commit was authored. | |
| CommittedDate | Datetime | True |
The datetime when this commit was committed. | |
| ViewerSubscription | String | True |
Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. | |
| ViewerCanSubscribe | Bool | True |
Check if the viewer is able to change their subscription status for the repository. | |
| Message | String | True |
The Git commit message. | |
| MessageBody | String | False |
The Git commit message body. | |
| MessageHeadline | String | False |
The Git commit message headline. | |
| MessageBodyHTML | String | True |
The commit message body rendered to HTML. | |
| MessageHeadlineHTML | String | True |
The commit message headline rendered to HTML. | |
| ResourcePath | String | True |
The HTTP path for this commit. | |
| CommitResourcePath | String | True |
The HTTP path for this Git object. | |
| TreeResourcePath | String | True |
The HTTP path for the tree of this commit. | |
| Url | String | True |
The HTTP URL for this commit. | |
| CommitUrl | String | True |
The HTTP URL for this Git object. | |
| TarballUrl | String | True |
Returns a URL to download a tarball archive for a repository. Note: For private repositories, these links are temporary and expire after five minutes. | |
| TreeUrl | String | True |
The HTTP URL for the tree of this commit. | |
| ZipballUrl | String | True |
Returns a URL to download a zipball archive for a repository. Note: For private repositories, these links are temporary and expire after five minutes. | |
| AuthorName | String | True |
The name in the Git commit. | |
| AuthorEmail | String | True |
The email of the commit author. | |
| AuthorDate | Datetime | True |
The timestamp of the Git action (authoring or committing). | |
| AuthorUserLogin | String | True |
The GitHub user corresponding to the email field. Null if no such user exists. | |
| CommitterName | String | True |
The name in the Git commit. | |
| CommitterEmail | String | True |
The email of the committer. | |
| CommitterDate | Datetime | True |
The timestamp of the Git action (authoring or committing). | |
| CommitterUserLogin | String | True |
The GitHub user corresponding to the email field. Null if no such user exists. | |
| OnBehalfOfId | String | True |
The organization's ID this commit was made on behalf of. | |
| OnBehalfOf | String | True |
The organization's login name this commit was made on behalf of. | |
| SignatureIsValid | Bool | True |
True if the signature is valid and verified by GitHub. | |
| Signature | String | True |
ASCII-armored signature header from object. | |
| SignatureEmail | String | True |
Email used to sign this object. | |
| SignaturePayload | String | True |
Payload for GPG signing object. Raw ODB object without the signature header. | |
| SignatureState | String | True |
The state of this signature. VALID if signature is valid and verified by GitHub, otherwise represents reason why signature is considered invalid. | |
| SignatureSigner | String | True |
GitHub user's login name corresponding to the email signing this commit. | |
| WasSignedByGitHub | Bool | True |
True if the signature was made with GitHub's signing key. | |
| SignatureVerifiedAt | Datetime | True |
The date the signature was verified, if valid. | |
| StatusId | String | True |
The commit status ID. | |
| StatusState | String | True |
The combined commit status. | |
| StatusCheckRollupId | String | True |
The Check and Status rollup ID. | |
| StatusCheckRollupState | String | True |
Check and Status rollup combined status state for this commit. | |
| TreeId | String | True |
The commit's root Tree ID. | |
| TreeOid | String | True |
The Git object ID. | |
| TreeAbbreviatedOid | String | True |
An abbreviated version of the Git object ID. | |
| TreeCommitUrl | String | True |
The HTTP URL for this Git object. | |
| TreeCommitResourcePath | String | True |
The HTTP path for this Git object. | |
| RepositoryId | String | True |
The ID of the repository. | |
| RepositoryName | String | True |
The name of the repository. | |
| OwnerLogin | String | True |
The login field of a user or organization. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ExpectedHeadOid | String |
The git commit oid expected at the head of the branch prior to the commit. |
| FileChangeAdditions | String |
File to add or change. |
| FileChangeDeletions | String |
Files to delete. |