PullRequestReviewRequests
Tracks requests for reviews on pull requests, including information about requested reviewers and their response statuses.
Table-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- PullRequestId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [PullRequestReviewRequests]
SELECT * FROM [PullRequestReviewRequests] WHERE [PullRequestId] = 'Val1'
The add-in processes other filters client-side within the add-in.
Insert
You can use the following columns to create (insert) a new record:
- RequestedReviewerUserId
- RequestedReviewerTeamId
- PullRequestId
Note: It is not possible to request both a user and team in the same statement.
INSERT INTO [PullRequestReviewRequests] ([PullRequestId], [RequestedReviewerUserId]) VALUES ('123', '456')
INSERT INTO [PullRequestReviewRequests] ([PullRequestId], [RequestedReviewerTeamId]) VALUES ('123', '789')
Delete
You can specify either of the following sets of WHERE conditions to delete a record:
- PullRequestId and RequestedReviewerUserId
- PullRequestId and RequestedReviewerTeamId
DELETE FROM [PullRequestReviewRequests] WHERE [PullRequestId] = '123' AND [RequestedReviewerUserId] = '456'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique node ID of the ReviewRequest object, which is used to identify this specific review request within the GitHub system. | |
| DatabaseId | Int | True |
The primary key identifier for the review request in the database, represented as an integer and used for internal storage and references. | |
| AsCodeOwner | Bool | True |
Indicates whether the review request was specifically made for a code owner to review, highlighting requests that require specialized review. | |
| RequestedReviewerUserId | String | True |
The node ID of the User object representing the individual user who has been requested to review the pull request. | |
| RequestedReviewerUserLogin | String | True |
The GitHub username of the user who has been requested to review the pull request, enabling identification of the reviewer. | |
| RequestedReviewerTeamId | String | True |
The node ID of the Team object representing the team requested to review the pull request, used for organizing team-based reviews. | |
| RequestedReviewerTeamSlug | String | True |
The unique slug of the team within the organization, which helps identify the team in a standardized way across the repository. | |
| RequestedReviewerMannequinId | String | True |
The node ID of the Mannequin object, representing a template or placeholder user that is being requested to review, often used for automating review assignments. | |
| RequestedReviewerMannequinLogin | String | True |
The username of the Mannequin object, which serves as a placeholder or template user when no real reviewer is assigned. | |
| RequestedReviewerBotId | String | True |
The node ID of the Bot object representing a bot that has been requested to review the pull request, typically used for automated checks or processes. | |
| RequestedReviewerBotLogin | String | True |
The username of the bot that is requested to review the pull request, often involved in automated review workflows. | |
| PullRequestId | String | True |
The unique identifier for the pull request to which this review request is associated, linking the review request to a specific pull request. | |
| PullRequestNumber | Int | True |
The number assigned to the pull request within the repository, providing a unique identifier for the pull request and its associated review request. |