CommitFiles
Details files modified in specific commits, including filenames, change types (for example, added, deleted, modified), and related metadata.
View-Specific Information
Select
The provider uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- CommitOid supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [CommitFiles]
SELECT * FROM [CommitFiles] WHERE [CommitOid] = 'Val1'
The provider processes other filters client-side within the provider.
Columns
| Name | Type | References | OrderBySupport | Description |
| CommitId [KEY] | String |
Commits.Id | The node ID of the commit, uniquely identifying the commit in the repository history. | |
| CommitOid | String |
Commits.Oid | The SHA (Secure Hash Algorithm) of the commit, which serves as a unique identifier for this commit. | |
| Sha [KEY] | String | The SHA of the file, uniquely identifying the file's content in the commit. | ||
| FileName | String | The name of the file that was modified in the commit. | ||
| Additions | Int | The number of lines added to the file in this commit. | ||
| Deletions | Int | The number of lines deleted from the file in this commit. | ||
| Changes | Int | The total number of changes made to the file, including both additions and deletions. | ||
| Status | String | The status of the file after the commit, such as 'modified', 'added', or 'removed'. | ||
| BlobUrl | String | A URL linking to the file in blob format, which represents the file's content at the time of the commit. | ||
| RawUrl | String | A direct URL linking to the raw content of the file, allowing access to the file as plain text. | ||
| ContentsUrl | String | A URL linking to the file served by the content management system, providing access to the file's content. | ||
| Patch | String | A diff representation of the changes made to the file, showing additions and deletions. | ||
| PreviousFileName | String | The name of the file before it was changed in this commit, applicable in case of renaming. |