CommitCompare
Stores a detailed list of commits generated from a comparison of two references, such as branches or tags.
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:
- Base supports the '=' comparison operator.
- Head supports the '=' comparison operator.
For example, the following query is processed server-side:
SELECT * FROM [CommitCompare] WHERE [Base] = 'Val1' AND [Head] = 'Val2'
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| Type [KEY] | String | The type of the commit, indicating its purpose or classification (for example, 'merge', 'update', 'feature'). | ||
| Id [KEY] | String |
Commits.Id | The unique node ID associated with this commit, used for internal reference within the system. | |
| Oid | String |
Commits.Oid | The unique SHA identifier for the commit, representing a cryptographic hash of the commit's contents. | |
| Url | String | The URL used to access the commit details via the GitHub API. | ||
| HtmlUrl | String | The URL to view this commit directly in a web browser on GitHub. | ||
| CommentsUrl | String | The URL for accessing any comments associated with this commit. | ||
| CommentCount | Int | The number of comments currently made on this commit, indicating user interaction. | ||
| TreeSha | String | The SHA hash of the tree object associated with this commit, identifying the directory structure at the time of the commit. | ||
| TreeUrl | String | The URL for accessing the tree structure (that is, the files and directories) related to this commit. | ||
| GitUrl | String | The URL that provides access to Git-specific information about the commit, often used for Git operations. | ||
| Message | String | The commit message provided by the author, summarizing the changes made in this commit. | ||
| AuthorName | String | The name of the person who authored the commit. | ||
| AuthorEmail | String | The email address of the author who made the commit, often used for contact or attribution. | ||
| AuthorLogin | String | The GitHub username of the commit author, used to reference the author within the GitHub platform. | ||
| AuthorId | Int | A unique identifier assigned to the author within GitHub's database. | ||
| AuthorNodeId | String | The unique node ID assigned to the author, used internally by GitHub for reference. | ||
| AuthorAvatarUrl | String | The URL pointing to the author's avatar image, displayed on their profile or commit history. | ||
| AuthorGravatarId | String | The Gravatar ID associated with the author, used for avatar management across various services. | ||
| AuthorUrl | String | The API URL for accessing the author's GitHub profile data programmatically. | ||
| AuthorHtmlUrl | String | The HTML URL that leads to the author's profile page on GitHub, where their repositories and contributions can be viewed. | ||
| AuthorFollowersUrl | String | The URL for accessing the list of followers of the author, showing their connections within GitHub. | ||
| AuthorFollowingUrl | String | The URL for accessing the list of users the author is following, which indicates their network and collaboration links. | ||
| AuthorGistsUrl | String | The URL for accessing the author's public gists, which are small code snippets or files shared within GitHub. | ||
| AuthorStarredUrl | String | The URL for accessing the repositories that the author has starred, indicating their favorite or most important projects. | ||
| AuthorSubscriptionsUrl | String | The URL for accessing the author's subscription list, showing the repositories or users they are subscribed to for notifications. | ||
| AuthorOrganizationsUrl | String | The URL for accessing the organizations that the author belongs to, useful for viewing their team collaborations. | ||
| AuthorReposUrl | String | The URL for accessing the author's repositories, where all their contributed or owned repositories are listed. | ||
| AuthorEventsUrl | String | The URL for accessing the events generated by the author, such as push events, pull requests, etc. | ||
| AuthorReceivedEventsUrl | String | The URL for accessing events received by the author, such as comments or mentions by others. | ||
| AuthorType | String | Indicates the type of the author, such as 'User' or 'Organization'. | ||
| AuthorSiteAdmin | Bool | Indicates whether the author is a GitHub site administrator, providing them with elevated access and privileges within the platform. | ||
| AuthorStarredAt | Datetime | The timestamp when the author starred this repository, indicating their interest or endorsement of the repository. | ||
| AuthorDate | Datetime | The date and time when the commit was authored, reflecting when the changes were initially made. | ||
| CommitterName | String | The name of the committer who finalized the commit, potentially different from the author if they are distinct individuals. | ||
| CommitterEmail | String | The email address of the committer, providing a point of contact for the person who made the commit. | ||
| CommitterLogin | String | The GitHub username of the committer, used to identify them within GitHub. | ||
| CommitterId | Int | The unique identifier of the committer within GitHub's database, used for internal referencing. | ||
| CommitterNodeId | String | The unique node ID assigned to the committer, a system-wide identifier used in GitHub's infrastructure. | ||
| CommitterAvatarUrl | String | The URL pointing to the committer's avatar image, used to visually identify them across the platform. | ||
| CommitterGravatarId | String | The Gravatar ID associated with the committer, used for cross-service avatar management. | ||
| CommitterUrl | String | The API URL for accessing the committer's profile data, useful for automated tools and integrations. | ||
| CommitterHtmlUrl | String | The HTML URL that leads to the committer's public profile on GitHub. | ||
| CommitterFollowersUrl | String | The URL to view the list of followers of the committer, indicating their network within GitHub. | ||
| CommitterFollowingUrl | String | The URL to view the list of users that the committer is following, indicating their interests and collaborations. | ||
| CommitterGistsUrl | String | The URL to access the committer's public gists, which are shared snippets of code or documentation. | ||
| CommitterStarredUrl | String | The URL for accessing repositories that the committer has starred, indicating their favorite or noteworthy projects. | ||
| CommitterSubscriptionsUrl | String | The URL for accessing the committer's subscription list, showing repositories or users they are subscribed to for notifications. | ||
| CommitterOrganizationsUrl | String | The URL to access the organizations the committer belongs to, providing information about their professional associations. | ||
| CommitterReposUrl | String | The URL for accessing the committer's repositories, which lists all the repositories they own or contribute to. | ||
| CommitterEventsUrl | String | The URL for accessing events that the committer has performed, such as pushes or pull requests. | ||
| CommitterReceivedEventsUrl | String | The URL for accessing events received by the committer, like comments or mentions from others. | ||
| CommitterType | String | Indicates the type of the committer (for example, 'User', 'Bot', or 'Organization'). | ||
| CommitterSiteAdmin | Bool | Indicates whether the committer has site administrator privileges on GitHub, providing them with special access and control. | ||
| CommitterStarredAt | Datetime | The timestamp when the committer starred this repository, showing their personal endorsement of the repository. | ||
| CommitterDate | Datetime | The date and time when the commit was actually made, reflecting when the changes were committed to the repository. | ||
| VerificationVerified | Bool | Indicates whether the commit has been verified, confirming the authenticity of the commit's source. | ||
| VerificationReason | String | The reason explaining why the commit was or was not verified, such as security or trust issues. | ||
| VerificationPayload | String | The payload used during the commit verification process, providing technical details related to the verification process. | ||
| VerificationSignature | String | The cryptographic signature used for verifying the commit, ensuring the integrity and origin of the changes. | ||
| StatsAdditions | Int | The number of lines of code added in this commit, indicating the extent of new content introduced. | ||
| StatsDeletions | Int | The number of lines of code deleted in this commit, showing the scope of changes that removed content. | ||
| StatsTotal | Int | The total number of lines changed in this commit, which is the sum of both added and deleted lines. | ||
| Parents | String | The list of parent commits for this commit, representing the commit history leading up to the current commit. Multiple parents indicate a merge commit. | ||
| Base | String | The ref (branch, tag, or commit hash) that serves as the base for a comparison, representing the starting point in the comparison between two commits. | ||
| Head | String | The ref (branch, tag, or commit hash) that serves as the head for a comparison, representing the endpoint in the comparison between two commits. |