IssueComments
Lists information about comments which were made on a specific issue.
Table-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.
- IssueNumber supports the '=' comparison operator.
The add-in uses the GitHub API to process ORDER BY clause conditions built with the following column. The add-in processes ordering by other columns client-side within the add-in.
- UpdatedAt (when IssueNumber is specified in the criteria with the '=' comparison operator)
SELECT * FROM [Repository].[IssueComments] WHERE [Repository].[IssueComments].[IssueNumber] = '100'
Insert
The following inputs can be used to create a new issue comment:
IssueId, Body
INSERT INTO [Repository].[IssueComments] ([IssueId], [Body]) VALUES ('I_kwDOLkrwGs6OhNo0', 'hello there')
Update
The following inputs can be used to update an issue comment's fields:
Body
UPDATE [Repository].[IssueComments] SET [Body]='test' WHERE [Id]='123'
Delete
You can specify the Id to delete a issue comment.
DELETE FROM [Repository].[IssueComments] WHERE [Id]='123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The unique identifier. | |
| Body | String | False |
The body as Markdown. | |
| BodyText | String | False |
The body rendered to text. | |
| BodyHTML | String | False |
The body rendered to HTML. | |
| Author | String | False |
The username of the actor who authored the comment. | |
| AuthorAssociation | String | False |
Author's association with the subject of the comment. | |
| Editor | String | False |
The username of the actor who edited the comment. | |
| IsMinimized | Bool | False |
Returns whether or not a comment has been minimized. | |
| MinimizedReason | String | False |
Returns why the comment was minimized. | |
| CreatedViaEmail | Bool | False |
Check if this comment was created via an email reply. | |
| IncludesCreatedEdit | Bool | False |
Check if this comment was edited and includes an edit with the creation data. | |
| ResourcePath | String | False |
The HTTP path for this comment. | |
| Url | String | False |
The HTTP URL for this comment. | |
| LastEditedAt | Datetime | False |
The moment the editor made the last edit. | |
| PublishedAt | Datetime | False |
Identifies when the comment was published at. | |
| CreatedAt | Datetime | False |
Identifies the date and time when the object was created. | |
| UpdatedAt | Datetime | False |
Identifies the date and time when the object was last updated. | |
| ViewerDidAuthor | Bool | False |
Did the viewer author this comment. | |
| ViewerCanDelete | Bool | False |
Check if the current viewer can delete this object. | |
| ViewerCanMinimize | Bool | False |
Check if the current viewer can minimize this object. | |
| ViewerCanReact | Bool | False |
Can user react to this subject. | |
| ViewerCanUpdate | Bool | False |
Check if the current viewer can update this object. | |
| ViewerCannotUpdateReasons | String | False |
Reasons why the current viewer can not update this comment. | |
| ReactionGroups | String | False |
A list of reactions grouped by content left on the subject. | |
| ViewerId | String | False |
The viewer ID. | |
| IssueNumber | Int | False |
Issues.Number |
Identifies the issue number associated with the comment. |
| IssueId | String | False |
Identifies the issue ID associated with the comment. | |
| PullRequestId | String | False |
Returns the ID of the pull request associated with the comment, if this comment was made on a pull request. | |
| FullDatabaseId | Long | False |
Identifies the primary key from the database as a BigInt. |