IssueComments
Logs comments added to issues, capturing discussions, updates, and resolutions for tracking purposes.
Table-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- IssueNumber supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [IssueComments]
SELECT * FROM [IssueComments] WHERE [IssueNumber] = 123
The 本製品 processes other filters client-side within the 本製品.
The 本製品 uses the GitHub API to process ORDER BY clause conditions that are built with the following column: UpdatedAt
SELECT * FROM [IssueComments] ORDER BY [UpdatedAt]
The 本製品 uses client-side processing when ordering by any other columns. This impacts performance.
Insert
You can use the following columns to create (insert) a new record:
- Body
- IssueId
INSERT INTO [IssueComments] ([IssueId], [Body]) VALUES ('I_kwDOLkrwGs6OhNo0', 'hello there')
Update
You can use the following column to update a record: Body
UPDATE [IssueComments] SET [Body] = 'test' WHERE [Id] = 'IC_kwDOLkrwGs6GFwhQ'
Delete
You can specify the following column to delete a record: Id
DELETE FROM [IssueComments] WHERE [Id] = 'IC_kwDOLkrwGs6GFuN2'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier for the comment. | |
| Body | String | False |
The body of the comment in Markdown format. | |
| BodyText | String | True |
The body of the comment rendered as plain text. | |
| BodyHTML | String | True |
The body of the comment rendered in HTML. | |
| Author | String | True |
The username of the person who authored the comment. | |
| AuthorAssociation | String | True |
The author's association with the subject of the comment. | |
| Editor | String | True |
The username of the actor who edited the comment. | |
| IsMinimized | Bool | True |
Indicates whether or not the comment has been minimized. | |
| MinimizedReason | String | True |
The reason why the comment was minimized. | |
| CreatedViaEmail | Bool | True |
Indicates if the comment was created through an email reply. | |
| IncludesCreatedEdit | Bool | True |
Indicates if the comment was edited and includes the creation data in the edit. | |
| ResourcePath | String | True |
The HTTP path for this comment. | |
| Url | String | True |
The HTTP URL for this comment. | |
| LastEditedAt | Datetime | True |
The date and time when the comment was last edited. | |
| PublishedAt | Datetime | True |
The date and time when the comment was published. | |
| CreatedAt | Datetime | True |
The date and time when the comment was created. | |
| UpdatedAt | Datetime | True |
The date and time when the comment was last updated. | |
| ViewerDidAuthor | Bool | True |
Indicates whether the viewer authored this comment. | |
| ViewerCanDelete | Bool | True |
Indicates if the current viewer has permission to delete this comment. | |
| ViewerCanMinimize | Bool | True |
Indicates if the current viewer has permission to minimize this comment. | |
| ViewerCanReact | Bool | True |
Indicates if the user can react to this comment. | |
| ViewerCanUpdate | Bool | True |
Indicates if the current viewer can update this comment. | |
| ViewerCannotUpdateReasons | String | True |
Lists the reasons why the current viewer cannot update this comment. | |
| ReactionGroups | String | True |
A list of reactions grouped by content left on the subject. | |
| ViewerId | String | True |
The ID of the viewer. | |
| IssueNumber | Int | True |
Issues.Number |
The issue number associated with the comment. |
| IssueId | String | True |
The issue ID associated with the comment. | |
| PullRequestId | String | True |
The ID of the pull request associated with the comment, if applicable. | |
| FullDatabaseId | Long | True |
The primary key for the comment in the database, stored as a BigInt. |