IssueComments
Lists information about comments which were made on a specific issue.
View-Specific Information
You must specify the UserLogin when executing a SELECT query against this view. You can specify the values in the WHERE clause or as connection properties. A value specified in the WHERE clause takes precedence over the connection property.
If you do not specify a UserLogin value, the driver will use the login name of the authenticated user.
Select
The driver uses the GitHub API to restrict results to the specified UserLogin and RepositoryName values.
The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.
- UserLogin, RepositoryName, and IssueNumber support the following operator: =
SELECT * FROM IssueComments WHERE RepositoryName = 'MyRepo' SELECT * FROM IssueComments WHERE UserLogin = 'MyUser' AND RepositoryName = 'MyRepo' SELECT * FROM IssueComments WHERE IssueNumber = 5 AND RepositoryName = 'MyRepo'
Columns
Name | Type | OrderBySupport | Description |
Id [KEY] | String | The issue comment Id. | |
UserLogin | String | The login name of the user. | |
RepositoryName | String | The name of the repository. | |
IssueNumber | Integer | Identifies the issue number associated with the comment. | |
Author | String | The username of the actor who authored the comment. | |
AuthorAssociation | String | Author's association with the subject of the comment. | |
Body | String | The body as Markdown. | |
BodyHTML | String | The body rendered to HTML. | |
BodyText | String | The body rendered to text. | |
CreatedAt | Datetime | Identifies the date and time when the object was created. | |
CreatedViaEmail | Boolean | Check if this comment was created via an email reply. | |
DatabaseId | Int | Identifies the primary key from the database. | |
Editor | String | The username of the actor who edited the comment. | |
IncludesCreatedEdit | Boolean | Check if this comment was edited and includes an edit with the creation data. | |
IsMinimized | Boolean | Returns whether or not a comment has been minimized. | |
LastEditedAt | Datetime | The moment the editor made the last edit. | |
MinimizedReason | String | Returns why the comment was minimized. | |
PublishedAt | Datetime | Identifies when the comment was published at. | |
PullRequestId | String | Returns the Id of the pull request associated with the comment, if this comment was made on a pull request. | |
ResourcePath | String | The HTTP path for this issue comment. | |
UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | |
Url | String | The HTTP URL for this issue comment. | |
ViewerCanDelete | Boolean | Check if the current viewer can delete this object. | |
ViewerCanMinimize | Boolean | Check if the current viewer can minimize this object. | |
ViewerCanReact | Boolean | Can user react to this subject. | |
ViewerCanUpdate | Boolean | Check if the current viewer can update this object. | |
ViewerDidAuthor | Boolean | Did the viewer author this comment. |