RepositoryIssues

Lists information about issues 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:

Id supports the '=' comparison operator.
Author supports the '=' comparison operator.
Number supports the '=' comparison operator.
UpdatedAt supports the '>,>=' comparison operators.
MilestoneNumber supports the '=' comparison operator.
Mentions supports the '=' comparison operator.
Assignee 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 [RepositoryIssues]
SELECT * FROM [RepositoryIssues] WHERE [Id] = 'Val1'
SELECT * FROM [RepositoryIssues] WHERE [Author] = 'Val1'
SELECT * FROM [RepositoryIssues] WHERE [Number] = 123
SELECT * FROM [RepositoryIssues] WHERE [UpdatedAt] > '2023-01-01 11:10:00'
SELECT * FROM [RepositoryIssues] WHERE [MilestoneNumber] = 123
SELECT * FROM [RepositoryIssues] WHERE [Mentions] = 'Val1'
SELECT * FROM [RepositoryIssues] WHERE [Assignee] = 'Val1'
SELECT * FROM [RepositoryIssues] WHERE [RepositoryName] = 'Val1'
SELECT * FROM [RepositoryIssues] 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 columns:

UpdatedAt
CreatedAt
CommentCount

SELECT * FROM [RepositoryIssues] ORDER BY [UpdatedAt]
SELECT * FROM [RepositoryIssues] ORDER BY [CreatedAt]
SELECT * FROM [RepositoryIssues] ORDER BY [CommentCount]

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:

Title
Body
DuplicateIssueId
MilestoneId
TypeID
RepositoryId

You can use the following pseudo-columns to create a new record:

AssigneeIds
LabelIds
IssueTemplate

INSERT INTO [RepositoryIssues] ([RepositoryId], [Title]) VALUES ('R_kgDOLkrwGg', 'TestIssue')
INSERT INTO [RepositoryIssues] ([Title]) VALUES ('TestIssue')

Update

You can use the following columns to update a record:

Title
Body
State
MilestoneId
TypeID

You can use the following pseudo-columns to update a record:

AssigneeIds
LabelIds

UPDATE [RepositoryIssues] SET [Title] = 'NewTitle', [AssigneeIds] = 'MDQ6VXNlcjg3ODExMTEx,U_kgDOCXOvpA', [State] = 'CLOSED' WHERE [Id] = 'I_kwDOLkrwGs7pxi97'

Delete

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

DELETE FROM [RepositoryIssues] WHERE [Id] = 'I_kwDOLkrwGs7pxi97'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Issue ID.
FullDatabaseId	Long	True		Identifies the primary key from the database as a BigInt.
Title	String	False		Identifies the issue title.
TitleHTML	String	True		Identifies the issue title 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.
Body	String	False		Identifies the body of the issue.
BodyText	String	True		Identifies the body of the issue rendered to text.
BodyHTML	String	True		The body rendered to HTML.
BodyResourcePath	String	True		The http path for this issue body.
BodyUrl	String	True		The http URL for this issue body.
Number	Int	True		The number for the issue to be returned.
State	String	False		Identifies the state of the issue.
StateReason	String	False		Identifies the reason for the issue state. The allowed values are COMPLETED, NOT_PLANNED, DUPLICATE, REOPENED.
Locked	Bool	False		True if the object is locked.
ActiveLockReason	String	False		Reason that the conversation was locked.
Closed	Bool	False		True if the object is closed (definition of closed may depend on type).
IsPinned	Bool	True		Indicates whether or not this issue is currently pinned to the repository issues list.
IncludesCreatedEdit	Bool	True		Check if this comment was edited and includes an edit with the creation data.
CreatedViaEmail	Bool	True		Check if this comment was created via an email reply.
DuplicateIssueId	String	False		ID of the issue that this is a duplicate of.
IssueDependenciesSummaryBlockedBy	Int	True		Count of issues this issue is blocked by.
IssueDependenciesSummaryBlocking	Int	True		Count of issues this issue is blocking.
IssueDependenciesSummaryTotalBlockedBy	Int	True		Total count of issues this issue is blocked by (open and closed).
IssueDependenciesSummaryTotalBlocking	Int	True		Total count of issues this issue is blocking (open and closed).
ResourcePath	String	True		The HTTP path for this issue.
Url	String	True		The HTTP URL for this issue.
LastEditedAt	Datetime	True		The moment the editor made the last edit.
PublishedAt	Datetime	True		Identifies when the comment was published at.
ClosedAt	Datetime	True		Identifies the date and time when the object was closed.
UpdatedAt	Datetime	True		Identifies the date and time when the object was last updated.
CreatedAt	Datetime	True		Identifies the date and time when the object was created.
MilestoneId	String	False		Identifies the milestone associated with the issue.
MilestoneTitle	String	True		Identifies the title of the milestone.
MilestoneNumber	Int	True		Identifies the number of the milestone.
IsReadByViewer	Bool	True		Is this issue read by the viewer.
ViewerDidAuthor	Bool	True		Did the viewer author this comment.
ViewerSubscription	String	True		Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
ViewerCanLabel	Bool	True		Indicates if the viewer can edit labels for this object.
ViewerCanClose	Bool	True		Indicates if the object can be closed by the viewer.
ViewerCanReopen	Bool	True		Indicates if the object can be reopened by the viewer.
ViewerCanDelete	Bool	True		Check if the current viewer can delete this object.
ViewerCanReact	Bool	True		Can user react to this subject.
ViewerCanSubscribe	Bool	True		Check if the viewer is able to change their subscription status for the repository.
ViewerThreadSubscriptionStatus	String	True		Identifies the viewer's thread subscription status.
ViewerThreadSubscriptionFormAction	String	True		Identifies the viewer's thread subscription form action.
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.
CommentCount	Int	True		The number of comments on the issue.
ReactionCount	Int	True		The number of reactions on the issue.
Mentions	String	True		You can find issues that mention a certain user.
Assignee	String	True		You can find find issues and pull requests that are assigned to a certain user.
TypeID	String	False		The Node ID of the IssueType object.
TypeName	String	True		The issue type's name.
TypeDescription	String	True		The issue type's description.
TypeIsEnabled	Bool	True		The issue type's enabled state.
TypeColor	String	True		The issue type's color.
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.

Pseudo-Columns

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


Name	Type	Description
AssigneeIds	String	A simple, comma-separated list of Node IDs of assignees for this issue.
LabelIds	String	A simple, comma-separated list of Node IDs of labels for this issue.
IssueTemplate	String	The name of an issue template in the repository, assigns labels and assignees from the template to the issue.

JDBC Driver for GitHub