Lists information about pull request reviews in a repository.

View-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.

• PullRequestNumber supports the '=' comparison operator.
• State supports the '=, IN' comparison operators.
• Author supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Repository].[PullRequestReviews] WHERE [Repository].[PullRequestReviews].[PullRequestNumber] = '100'

SELECT * FROM [Repository].[PullRequestReviews] WHERE [Repository].[PullRequestReviews].[State] = 'PENDING'

SELECT * FROM [Repository].[PullRequestReviews] WHERE [Repository].[PullRequestReviews].[Author] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The unique identifier.
Body	String			The body as Markdown.
BodyText	String			The body rendered to text.
BodyHTML	String			The body rendered to HTML.
Author	String			The actor's username login who authored the comment.
AuthorAssociation	String			Author's association with the subject of the comment.
Editor	String			The username of the actor who edited the comment.
IsMinimized	Bool			Returns whether or not a comment has been minimized.
MinimizedReason	String			Returns why the comment was minimized.
CreatedViaEmail	Bool			Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool			Check if this comment was edited and includes an edit with the creation data.
ResourcePath	String			The HTTP path for this comment.
Url	String			The HTTP URL for this comment.
LastEditedAt	Datetime			The moment the editor made the last edit.
PublishedAt	Datetime			Identifies when the comment was published at.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ViewerDidAuthor	Bool			Did the viewer author this comment.
ViewerCanDelete	Bool			Check if the current viewer can delete this object.
ViewerCanMinimize	Bool			Check if the current viewer can minimize this object.
ViewerCanReact	Bool			Can user react to this subject.
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String			Reasons why the current viewer can not update this comment.
ReactionGroups	String			A list of reactions grouped by content left on the subject.
ViewerId	String			The viewer ID.
PullRequestId	String	PullRequests.Id		Identifies the pull request ID associated with this pull request review.
PullRequestNumber	Int			Identifies the pull request number associated with this pull request review.
CommitId	String			Identifies the commit associated with this pull request review.
SubmittedAt	Datetime			Identifies when the Pull Request Review was submitted.
State	String			Identifies the current state of the pull request review.
AuthorCanPushToRepository	Bool			Indicates whether the author of this review has push access to the repository.
FullDatabaseId	Long			Identifies the primary key from the database as a BigInt.