JDBC Driver for GitHub

Build 22.0.8462

Issues

Lists all project issues.

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 State support the following operator: =
  • RepositoryName and Author support the following operators: =,!=
  • ClosedAt, CreatedAt, and UpdatedAt support the following operators: =,>,>=,<,<=
The following queries are processed server side.
SELECT * FROM Issues WHERE UserLogin = 'MyUser' AND RepositoryName = 'MyRepo'

SELECT * FROM Issues WHERE RepositoryName = 'test' AND UpdatedAt >= '2018-05-10 11:11:38.0'

Columns

Name Type OrderBySupport Description
Id [KEY] String The Issue ID.
UserLogin String The login name of the user.
RepositoryName String The name of the repository.
ActiveLockReason String Reason that the conversation was locked.
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 body of the issue.
BodyHTML String The body rendered to HTML.
BodyText String Identifies the body of the issue rendered to text.
Closed Boolean True if the object is closed (definition of closed may depend on type).
ClosedAt Datetime Identifies the date and time when the object was closed.
CreatedAt Datetime True 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.
LastEditedAt Datetime The moment the editor made the last edit.
Locked Boolean True if the object is locked.
MilestoneId String Identifies the milestone associated with the issue.
Number Int Identifies the issue number.
PublishedAt Datetime Identifies when the comment was published at.
ResourcePath String The HTTP path for this issue.
State String Identifies the state of the issue.

The allowed values are open, closed.

Title String Identifies the issue title.
UpdatedAt Datetime True Identifies the date and time when the object was last updated.
Url String The HTTP URL for this issue.
ViewerCanReact Boolean Can user react to this subject.
ViewerCanSubscribe Boolean Check if the viewer is able to change their subscription status for the repository.
ViewerCanUpdate Boolean Check if the current viewer can update this object.
ViewerDidAuthor Boolean Did the viewer author this comment.
ViewerSubscription String Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Comments Integer You can search by the number of comments.
Interactions Integer You can filter issues by the number of interactions.
Reactions Integer You can filter issues by the number of reactions.
Mentions String You can find issues that mention a certain user.
Assignee String You can find find issues and pull requests that are assigned to a certain user.

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