Issues

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

Table-Specific Information

Select

The add-in 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 add-in processes other filters client-side within the add-in.

The add-in 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 add-in 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. The allowed values are 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

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.


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.