Commits
Lists the commit history of gists.
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:
- GistName supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [Commits]
SELECT * FROM [Commits] WHERE [GistName] = 'Val1'
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| GistName [KEY] | String |
Gists.Name | The gist identifier. | |
| Sha [KEY] | String | The SHA of the gist revision. | ||
| Url | String | The API URL of the gist revision. | ||
| CommittedAt | Datetime | The date and time when the revision was committed. | ||
| ChangeStatusTotal | Int | The total number of changes in the revision. | ||
| ChangeStatusAdditions | Int | The number of additions in the revision. | ||
| ChangeStatusDeletions | Int | The number of deletions in the revision. | ||
| UserLogin | String | The username of the user who created the revision. | ||
| UserId | Int | The ID of the user who created the revision. | ||
| UserNodeId | String | The node ID of the user who created the revision. | ||
| UserAvatarUrl | String | The avatar URL of the user who created the revision. | ||
| UserGravatarId | String | The Gravatar ID of the user who created the revision. | ||
| UserUrl | String | The API URL of the user who created the revision. | ||
| UserHtmlUrl | String | The HTML URL of the user who created the revision. | ||
| UserFollowersUrl | String | The API URL for the followers of the user who created the revision. | ||
| UserFollowingUrl | String | The API URL for the following of the user who created the revision. | ||
| UserGistsUrl | String | The API URL for the gists of the user who created the revision. | ||
| UserStarredUrl | String | The API URL for the starred repositories of the user who created the revision. | ||
| UserSubscriptionsUrl | String | The API URL for the subscriptions of the user who created the revision. | ||
| UserOrganizationsUrl | String | The API URL for the organizations of the user who created the revision. | ||
| UserReposUrl | String | The API URL for the repositories of the user who created the revision. | ||
| UserEventsUrl | String | The API URL for the events of the user who created the revision. | ||
| UserReceivedEventsUrl | String | The API URL for the received events of the user who created the revision. | ||
| UserType | String | The type of the user who created the revision. | ||
| UserSiteAdmin | Bool | Indicates whether the user who created the revision is a site administrator. | ||
| UserViewType | String | The user view type of the user who created the revision. | ||
| OwnerLogin | String | The username of the gist owner. |