PullRequestComments
Lists information about comments which were made on a specific pull request.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The add-in processes other filters client-side within the add-in.
- PullRequestId supports the '=' comparison operator.
SELECT * FROM [Repository].[PullRequestComments] WHERE [Repository].[PullRequestComments].[PullRequestId] = 'PR_kwDO00RTuc5l2kMj'
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 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. |