Lists information about comments which were made on a specific pull request.

View-Specific Information

Select

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

• PullRequestId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Repository].[PullRequestComments] WHERE [Repository].[PullRequestComments].[PullRequestId] = 'PR_kwDO00RTuc5l2kMj'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The unique identifier.
DatabaseId	Int			Identifies the primary key from the database.
Body	String			The body as Markdown.
BodyText	String			The body rendered to text.
BodyHTML	String			The body rendered to HTML.
Author	String			The username of the actor 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.
IssueId	String			Identifies the issue ID associated with the comment.
PullRequestId	String			Returns the ID of the pull request associated with the comment, if this comment was made on a pull request.
FullDatabaseId	Long			Identifies the primary key from the database as a BigInt.