Issues
Lists all project issues.
Table-Specific Information
Select
The cmdlet uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The cmdlet processes other filters client-side within the cmdlet.
- 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 '=' comparison operator.
- Assignee supports the '=' comparison operator.
The cmdlet uses the GitHub API to process ORDER BY clause conditions built with the following column. The cmdlet processes ordering by other columns client-side within the cmdlet.
- UpdatedAt
- CreatedAt
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[Author] = 'EXAMPLE'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[State] = 'EXAMPLE'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[ClosedAt] = '2018-05-10 11:11:38.0'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[UpdatedAt] = '2018-05-10 11:11:38.0'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[CreatedAt] = '2018-05-10 11:11:38.0'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[CommentCount] = '100'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[ReactionCount] = '100'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[Mentions] = 'User'
SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[Assignee] = 'User'
Insert
The following inputs can be used in INSERT statements:
Title, Body, MilestoneId, AssigneeIds, LabelIds, IssueTemplate
INSERT INTO [Repository].[Issues] ([Title], [AssigneeIds]) VALUES ('TestIssue', 'MDQ6VXNlcjg3ODExMTEx,U_kgDOCXOvpA')
Update
The following inputs can be used to update an issue's fields:
Title, Body, State, MilestoneId, AssigneeIds, LabelIds
The following inputs can be used to lock an issue:
Locked, ActiveLockReason
The following inputs can be used to unlock an issue:
Locked
UPDATE [Repository].[Issues] SET [Title]='NewTitle', [AssigneeIds]='MDQ6VXNlcjg3ODExMTEx,U_kgDOCXOvpA', [State]='CLOSED' WHERE [Id]='I_kwDOLkrwGs6M5WWy'
UPDATE [Repository].[Issues] SET [Locked]=true WHERE [Id]='I_kwDOLkrwGs6M5WWy'
UPDATE [Repository].[Issues] SET [Locked]=false WHERE [Id]='I_kwDOLkrwGs6M5WWy'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The Issue ID. | |
| FullDatabaseId | Long | False |
Identifies the primary key from the database as a BigInt. | |
| Title | String | False |
Identifies the issue title. | |
| TitleHTML | String | False |
Identifies the issue title rendered to HTML. | |
| Author | String | False |
The username of the actor who authored the comment. | |
| AuthorAssociation | String | False |
Author's association with the subject of the comment. | |
| Editor | String | False |
The username of the actor who edited the comment. | |
| Body | String | False |
Identifies the body of the issue. | |
| BodyText | String | False |
Identifies the body of the issue rendered to text. | |
| BodyHTML | String | False |
The body rendered to HTML. | |
| BodyResourcePath | String | False |
The http path for this issue body. | |
| BodyUrl | String | False |
The http URL for this issue body. | |
| Number | Int | False |
Identifies the issue number. | |
| State | String | False |
Identifies the state of the issue. | |
| StateReason | String | False |
Identifies the reason for the issue state. | |
| 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 | False |
Indicates whether or not this issue is currently pinned to the repository issues list. | |
| IncludesCreatedEdit | Bool | False |
Check if this comment was edited and includes an edit with the creation data. | |
| CreatedViaEmail | Bool | False |
Check if this comment was created via an email reply. | |
| ResourcePath | String | False |
The HTTP path for this issue. | |
| Url | String | False |
The HTTP URL for this issue. | |
| LastEditedAt | Datetime | False |
The moment the editor made the last edit. | |
| PublishedAt | Datetime | False |
Identifies when the comment was published at. | |
| ClosedAt | Datetime | False |
Identifies the date and time when the object was closed. | |
| UpdatedAt | Datetime | False |
Identifies the date and time when the object was last updated. | |
| CreatedAt | Datetime | False |
Identifies the date and time when the object was created. | |
| MilestoneId | String | False |
Milestones.Id |
Identifies the milestone associated with the issue. |
| MilestoneTitle | String | False |
Identifies the title of the milestone. | |
| MilestoneNumber | Int | False |
Identifies the number of the milestone. | |
| IsReadByViewer | Bool | False |
Is this issue read by the viewer. | |
| ViewerDidAuthor | Bool | False |
Did the viewer author this comment. | |
| ViewerSubscription | String | False |
Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. | |
| ViewerCanClose | Bool | False |
Indicates if the object can be closed by the viewer. | |
| ViewerCanReopen | Bool | False |
Indicates if the object can be reopened by the viewer. | |
| ViewerCanDelete | Bool | False |
Check if the current viewer can delete this object. | |
| ViewerCanReact | Bool | False |
Can user react to this subject. | |
| ViewerCanSubscribe | Bool | False |
Check if the viewer is able to change their subscription status for the repository. | |
| ViewerThreadSubscriptionStatus | String | False |
Identifies the viewer's thread subscription status. | |
| ViewerThreadSubscriptionFormAction | String | False |
Identifies the viewer's thread subscription form action. | |
| ViewerCanUpdate | Bool | False |
Check if the current viewer can update this object. | |
| ViewerCannotUpdateReasons | String | False |
Reasons why the current viewer can not update this comment. | |
| CommentCount | Int | False |
The number of comments on the issue. | |
| ReactionCount | Int | False |
The number of reactions on the issue. | |
| Mentions | String | False |
You can find issues that mention a certain user. | |
| Assignee | String | False |
You can find find issues and pull requests that are assigned to a certain user. |
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 |
| 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. |