PullRequestFiles
Tracks files modified within pull requests, listing filenames, change types, and details for thorough review.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- PullRequestNumber supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [PullRequestFiles]
SELECT * FROM [PullRequestFiles] WHERE [PullRequestNumber] = 123
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| PullRequestId [KEY] | String | A unique identifier for the pull request associated with the file changes, used to link these modifications to a specific pull request. | ||
| PullRequestNumber | Int | The number assigned to the pull request for identification, allowing users to refer to it easily within the repository's pull request system. | ||
| Path [KEY] | String | The relative file path within the repository that was modified by this pull request, showing the location of the file that was changed. | ||
| ChangeType | String | The type of modification made to the file in the pull request, such as 'ADDED' for new files, 'MODIFIED' for changes to existing files, or 'DELETED' for removed files. | ||
| ViewerViewedState | String | The state of the file as seen by the current user in the context of the review process. This can indicate whether the file has been reviewed, approved, or is still pending review. | ||
| Additions | Int | The total number of lines added to the file as part of the changes in this pull request. | ||
| Deletions | Int | The total number of lines removed from the file as part of the changes in this pull request. |