ODBC Driver for GitHub

Build 24.0.9175

Issues

Stores comprehensive details about issues in a repository, including labels, assignees, priorities, and statuses.

Table-Specific Information

Select

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

  • Author supports the '=,!=' comparison operators.
  • State supports the '=' comparison operator.
  • ClosedAt supports the '=,>,>=,<,<=' comparison operators.
  • UpdatedAt supports the '=,>,>=,<,<=' comparison operators.
  • CreatedAt supports the '=,>,>=,<,<=' comparison operators.
  • CommentCount supports the '=,>,>=,<,<=' comparison operators.
  • ReactionCount supports the '=,>,>=,<,<=' comparison operators.
  • Mentions supports the '=,IN' comparison operators.
  • Assignee supports the '=,IN' comparison operators.

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

SELECT * FROM [Issues]
SELECT * FROM [Issues] WHERE [Author] = 'Val1'
SELECT * FROM [Issues] WHERE [State] = 'open'
SELECT * FROM [Issues] WHERE [ClosedAt] = '2023-01-01 11:10:00'
SELECT * FROM [Issues] WHERE [UpdatedAt] = '2023-01-01 11:10:00'
SELECT * FROM [Issues] WHERE [CreatedAt] = '2023-01-01 11:10:00'
SELECT * FROM [Issues] WHERE [CommentCount] = 123
SELECT * FROM [Issues] WHERE [ReactionCount] = 123
SELECT * FROM [Issues] WHERE [Mentions] = 'Val1'
SELECT * FROM [Issues] WHERE [Assignee] = 'Val1'

The 本製品 processes other filters client-side within the 本製品.

The 本製品 uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:

  • UpdatedAt
  • CreatedAt

SELECT * FROM [Issues] ORDER BY [UpdatedAt]
SELECT * FROM [Issues] ORDER BY [CreatedAt]

The 本製品 uses client-side processing when ordering by any other columns. This impacts performance.

Insert

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

  • Title
  • Body
  • MilestoneId

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

  • AssigneeIds
  • LabelIds
  • IssueTemplate

INSERT INTO [Issues] ([Title], [AssigneeIds]) VALUES ('TestIssue', 'MDQ6VXNlcjg3ODExMTEx,U_kgDOCXOvpA')

Update

You can use the following columns to update a record:

  • Title
  • Body
  • State
  • MilestoneId

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

  • AssigneeIds
  • LabelIds

You can use the following columns to lock a record:

  • Locked
  • ActiveLockReason

You can use the following columns to unlock a record: Locked 

UPDATE [Issues] SET [Title] = 'NewTitle', [AssigneeIds] = 'MDQ6VXNlcjg3ODExMTEx,U_kgDOCXOvpA', [State] = 'CLOSED' WHERE [Id] = 'I_kwDOLkrwGs6M5WWy'
UPDATE [Issues] SET [Locked] = true WHERE [Id] = 'I_kwDOLkrwGs6M5WWy'
UPDATE [Issues] SET [Locked] = false WHERE [Id] = 'I_kwDOLkrwGs6M5WWy'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A unique identifier for the issue within the repository.

FullDatabaseId Long True

The primary key of the issue in the database, stored as a BigInt.

Title String False

The title of the issue, summarizing its content.

TitleHTML String True

The issue title formatted as HTML for web display.

Author String True

The username of the user who created the issue.

AuthorAssociation String True

The relationship of the author to the repository, such as collaborator or owner.

Editor String True

The username of the user who last edited the issue.

Body String False

The main content or description provided in the issue.

BodyText String True

The issue body converted to plain text, without formatting.

BodyHTML String True

The issue body formatted as HTML for web display.

BodyResourcePath String True

The relative HTTP path to access the issue body.

BodyUrl String True

The full HTTP URL to directly access the issue body.

Number Int True

A sequential number assigned to the issue within the repository.

State String False

The current status of the issue, such as open or closed.

使用できる値は次のとおりです。open, closed

StateReason String True

The explanation for the current issue state, if applicable.

Locked Bool True

Indicates whether the issue is locked to prevent further comments.

ActiveLockReason String True

The reason why the issue discussion was locked.

Closed Bool True

Indicates whether the issue has been closed.

IsPinned Bool True

Indicates whether the issue is pinned to the top of the repository's issue list.

IncludesCreatedEdit Bool True

Indicates whether the issue has been edited since its creation.

CreatedViaEmail Bool True

Indicates whether the issue was created through an email reply.

ResourcePath String True

The relative HTTP path to access the issue.

Url String True

The full HTTP URL to directly access the issue.

LastEditedAt Datetime True

The date and time when the issue was last edited.

PublishedAt Datetime True

The date and time when the issue was initially published.

ClosedAt Datetime True

The date and time when the issue was closed, if applicable.

UpdatedAt Datetime True

The date and time of the most recent update to the issue.

CreatedAt Datetime True

The date and time when the issue was first created.

MilestoneId String False

Milestones.Id

The unique identifier of the milestone associated with this issue.

MilestoneTitle String True

The title of the milestone associated with the issue.

MilestoneNumber Int True

The sequential number assigned to the milestone in the repository.

IsReadByViewer Bool True

Indicates whether the issue has been read by the current viewer.

ViewerDidAuthor Bool True

Indicates whether the current viewer is the author of the issue.

ViewerSubscription String True

The viewer's subscription status for this issue, such as watching, not watching, or ignoring.

ViewerCanLabel Bool True

Indicates whether the viewer has permission to add or edit labels on this issue.

ViewerCanClose Bool True

Indicates whether the viewer has permission to close the issue.

ViewerCanReopen Bool True

Indicates whether the viewer has permission to reopen a previously closed issue.

ViewerCanDelete Bool True

Indicates whether the viewer has permission to delete this issue.

ViewerCanReact Bool True

Indicates whether the viewer can react to this issue with emojis.

ViewerCanSubscribe Bool True

Indicates whether the viewer can modify their subscription status for the issue.

ViewerThreadSubscriptionStatus String True

The viewer's current subscription status for the issue's thread.

ViewerThreadSubscriptionFormAction String True

The available actions for the viewer to change their thread subscription.

ViewerCanUpdate Bool True

Indicates whether the viewer has permission to update this issue.

ViewerCannotUpdateReasons String True

The reasons why the viewer cannot update the issue, if applicable.

CommentCount Int True

The total number of comments added to the issue.

ReactionCount Int True

The total number of reactions added to the issue.

Mentions String True

Allows filtering of issues that mention a specific user.

Assignee String True

The username of the user assigned to the issue or pull request.

Pseudo-Columns

疑似カラムは、明示的にリストされているステートメントの型でのみ使用できるフィールドです。これらは標準のカラムではなく、特定の操作のための追加機能を提供するものです。

Name Type Description
AssigneeIds String

A list of assignee node IDs for the issue, separated by commas with spaces after each comma.

LabelIds String

A list of label node IDs associated with the issue, separated by commas with spaces after each comma.

IssueTemplate String

The name of an issue template used to pre-fill the issue with predefined labels and assignees.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175