JDBC Driver for GitHub

Build 22.0.8462

CommitComments

Lists information about comments which were made on a specific commit.

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 and RepositoryName support the following operator: =
For example, the following queries are processed server side:
SELECT * FROM CommitComments WHERE UserLogin = 'MyUser' AND RepositoryName = 'MyRepo'

Columns

Name Type OrderBySupport Description
Id [KEY] String The ID of the commit comment.
UserLogin String The login name of the user.
RepositoryName String The name of the repository.
CommitId String Identifies the commit associated with the comment, if the commit exists.
Author String The username of the actor who authored the comment.
AuthorAssociation String Author's association with the subject of the comment.
Body String Identifies the comment body.
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.
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.
Path String Identifies the file path associated with the comment.
Position Int Identifies the line position associated with the comment.
PublishedAt Datetime Identifies when the comment was published at.
ResourcePath String The HTTP path permalink for this commit comment.
UpdatedAt Datetime Identifies the date and time when the object was last updated.
Url String The HTTP URL permalink for this commit 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