RepositoryIssueComments

Lists information about issue comments in repositories.

Table-Specific Information

Select

The driver uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

IssueNumber supports the '=' comparison operator.
RepositoryName supports the '=' comparison operator.
OwnerLogin supports the '=' comparison operator.

For example, the following queries are processed server-side:

SELECT * FROM [RepositoryIssueComments]
SELECT * FROM [RepositoryIssueComments] WHERE [IssueNumber] = 123
SELECT * FROM [RepositoryIssueComments] WHERE [RepositoryName] = 'Val1'
SELECT * FROM [RepositoryIssueComments] WHERE [OwnerLogin] = 'Val1'

The driver processes other filters client-side within the driver.

The driver uses the GitHub API to process ORDER BY clause conditions that are built with the following column: UpdatedAt

SELECT * FROM [RepositoryIssueComments] ORDER BY [UpdatedAt]

The driver processes ordering by other columns client-side within the driver.

Insert

You can use the following columns to create (insert) a new record:

Body
IssueId
RepositoryId

INSERT INTO [RepositoryIssueComments] ([IssueId], [Body]) VALUES ('I_kwDOLkrwGs6OhNo0', 'hello there')

Update

You can use the following column to update a record: Body

UPDATE [RepositoryIssueComments] SET [Body] = 'new' WHERE [Id] = 'IC_kwDOLkrwGs7nLPcQ'

Delete

You can specify the following column to delete a record: Id

DELETE FROM [RepositoryIssueComments] WHERE [Id] = 'IC_kwDOLkrwGs7nLPcQ'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier.
Body	String	False		The body as Markdown.
BodyText	String	True		The body rendered to text.
BodyHTML	String	True		The body rendered to HTML.
Author	String	True		The username of the actor who authored the comment.
AuthorAssociation	String	True		Author's association with the subject of the comment.
Editor	String	True		The username of the actor who edited the comment.
IsMinimized	Bool	True		Returns whether or not a comment has been minimized.
MinimizedReason	String	True		Returns why the comment was minimized.
CreatedViaEmail	Bool	True		Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool	True		Check if this comment was edited and includes an edit with the creation data.
ResourcePath	String	True		The HTTP path for this comment.
Url	String	True		The HTTP URL for this comment.
LastEditedAt	Datetime	True		The moment the editor made the last edit.
PublishedAt	Datetime	True		Identifies when the comment was published at.
CreatedAt	Datetime	True		Identifies the date and time when the object was created.
UpdatedAt	Datetime	True		Identifies the date and time when the object was last updated.
ViewerDidAuthor	Bool	True		Did the viewer author this comment.
ViewerCanDelete	Bool	True		Check if the current viewer can delete this object.
ViewerCanMinimize	Bool	True		Check if the current viewer can minimize this object.
ViewerCanReact	Bool	True		Can user react to this subject.
ViewerCanUpdate	Bool	True		Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String	True		Reasons why the current viewer can not update this comment.
ReactionGroups	String	True		A list of reactions grouped by content left on the subject.
ViewerId	String	True		The viewer ID.
IssueNumber	Int	True	RepositoryIssues.Number	Identifies the issue number associated with the comment.
IssueId	String	False		Identifies the issue ID associated with the comment.
PullRequestId	String	True		Returns the ID of the pull request associated with the comment, if this comment was made on a pull request.
FullDatabaseId	Long	True		Identifies the primary key from the database as a BigInt.
RepositoryId	String	True		The ID of the repository.
RepositoryName	String	True		The name of the repository.
OwnerLogin	String	True		The login field of a user or organization.