JDBC Driver for GitHub

Build 22.0.8462

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: =
For example, the following queries are processed server side:
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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462