Lists review requests associated with pull requests.

Table-Specific Information

Select

The driver uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The driver processes other filters client-side within the driver.

• PullRequestId supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Repository].[PullRequestReviewRequests] WHERE [Repository].[PullRequestReviewRequests].[PullRequestId] = '123'

Insert

The following inputs can be used to request a pull request review:

PullRequestId, RequestedReviewerUserId, RequestedReviewerTeamId

Note: It is not possible to request both a user and team in the same statement.

INSERT INTO [Repository].[PullRequestReviewRequests] ([PullRequestId], [RequestedReviewerUserId]) VALUES ('123', '456')
INSERT INTO [Repository].[PullRequestReviewRequests] ([PullRequestId], [RequestedReviewerTeamId]) VALUES ('123', '789')

Delete

You can delete a pull request review by specifying the PullRequestId and the RequestedReviewerUserId or RequestedReviewerTeamId.

DELETE FROM [Repository].[PullRequestReviewRequests] WHERE [PullRequestId]='123' AND [RequestedReviewerUserId]='456'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The Node ID of the ReviewRequest object.
DatabaseId	Int	False		Identifies the primary key from the database.
AsCodeOwner	Bool	False		Whether this request was created for a code owner.
RequestedReviewerUserId	String	False		The Node ID of the User object.
RequestedReviewerUserLogin	String	False		The username of the actor.
RequestedReviewerTeamId	String	False		The Node ID of the Team object.
RequestedReviewerTeamSlug	String	False		The slug corresponding to the team.
RequestedReviewerMannequinId	String	False		The Node ID of the Mannequin object.
RequestedReviewerMannequinLogin	String	False		The username of the actor.
RequestedReviewerBotId	String	False		The Node ID of the Bot object.
RequestedReviewerBotLogin	String	False		The username of the actor.
PullRequestId	String	False		The ID of the pull request.
PullRequestNumber	Int	False		Identifies the pull request number.