PullRequestReviewComments
Logs comments made during pull request reviews, capturing feedback, suggestions, and discussions for improving the code.
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:
- PullRequestReviewId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [PullRequestReviewComments]
SELECT * FROM [PullRequestReviewComments] WHERE [PullRequestReviewId] = 'Val1'
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | A unique identifier for each review comment, used to distinguish it from other comments in the system. | ||
| Body | String | The content of the comment, written in Markdown format, allowing for rich text, links, and other formatting features. | ||
| BodyText | String | The plain text version of the comment's body, with all Markdown formatting removed. | ||
| BodyHTML | String | The HTML-rendered version of the comment, which shows how the comment appears when viewed on the web. | ||
| Author | String | The GitHub username of the person who authored the comment, indicating the individual who wrote the feedback or notes. | ||
| AuthorAssociation | String | The relationship between the author and the repository, such as 'OWNER', 'CONTRIBUTOR', or 'COLLABORATOR', indicating their role in the project. | ||
| Editor | String | The GitHub username of the person who last edited or modified the comment after it was originally posted. | ||
| IsMinimized | Bool | Indicates whether the comment has been minimized or collapsed in the view, which can be done by the author or a reviewer. | ||
| MinimizedReason | String | The reason why the comment was minimized, such as it being flagged as less relevant or having an insignificant impact. | ||
| CreatedViaEmail | Bool | Indicates whether the comment was created via email, such as through an email reply to a pull request notification. | ||
| IncludesCreatedEdit | Bool | Indicates whether the comment has been edited after it was first created, and whether it includes information on the original creation of the comment. | ||
| ResourcePath | String | The relative HTTP path for accessing the review comment through the GitHub API, which can be used to retrieve the comment programmatically. | ||
| Url | String | The full URL to access the comment directly on GitHub, which allows viewing and interacting with the comment on the platform. | ||
| LastEditedAt | Datetime | The timestamp when the comment was last edited, showing when the most recent update to the comment was made. | ||
| PublishedAt | Datetime | The timestamp when the comment was first published, marking the initial moment it became visible to others. | ||
| CreatedAt | Datetime | The timestamp when the comment was created, representing the exact time when the comment was first added to the system. | ||
| UpdatedAt | Datetime | The timestamp when the comment was last updated, which can be an edit or a new reply within the conversation thread. | ||
| ViewerDidAuthor | Bool | Indicates whether the current viewer is the author of the comment. A value of 'true' means the viewer is the one who wrote the comment. | ||
| ViewerCanDelete | Bool | Indicates whether the current viewer has permission to delete the comment, typically based on their role or relationship to the repository. | ||
| ViewerCanMinimize | Bool | Indicates whether the current viewer has the ability to minimize or collapse the comment in their view. | ||
| ViewerCanReact | Bool | Indicates whether the current viewer can react to the comment, such as adding a thumbs-up, thumbs-down, or other emoji reactions. | ||
| ViewerCanUpdate | Bool | Indicates whether the current viewer has the ability to edit or update the comment after it has been posted. | ||
| ViewerCannotUpdateReasons | String | Lists the reasons why the current viewer is unable to update or edit the comment, which can be due to permissions or specific restrictions. | ||
| PullRequestId | String | The ID of the pull request that this comment is associated with, linking the comment to the relevant pull request on GitHub. | ||
| PullRequestReviewId | String | The ID of the review to which this comment belongs, helping to group comments within a specific pull request review session. | ||
| FullDatabaseId | Long | The primary key identifier for the comment in the underlying database, represented as a BigInt, used internally for data storage and reference. |