Issues
Lists all project issues.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The 本製品 processes other filters client-side within the 本製品.
- 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 本製品 uses the GitHub API to process ORDER BY clause conditions built with the following column. The 本製品 processes ordering by other columns client-side within the 本製品.
- 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'
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The Issue ID. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| FullDatabaseId | Long | Identifies the primary key from the database as a BigInt. | ||
| Title | String | Identifies the issue title. | ||
| TitleHTML | String | Identifies the issue title rendered to HTML. | ||
| Author | String | The username of the actor who authored the comment. | ||
| AuthorAssociation | String | Author's association with the subject of the comment. | ||
| Editor | String | The username of the actor who edited the comment. | ||
| Body | String | Identifies the body of the issue. | ||
| BodyText | String | Identifies the body of the issue rendered to text. | ||
| BodyHTML | String | The body rendered to HTML. | ||
| BodyResourcePath | String | The http path for this issue body. | ||
| BodyUrl | String | The http URL for this issue body. | ||
| Number | Int | Identifies the issue number. | ||
| State | String | Identifies the state of the issue. | ||
| StateReason | String | Identifies the reason for the issue state. | ||
| Locked | Bool | True if the object is locked. | ||
| ActiveLockReason | String | Reason that the conversation was locked. | ||
| Closed | Bool | True if the object is closed (definition of closed may depend on type). | ||
| IsPinned | Bool | Indicates whether or not this issue is currently pinned to the repository issues list. | ||
| IncludesCreatedEdit | Bool | Check if this comment was edited and includes an edit with the creation data. | ||
| CreatedViaEmail | Bool | Check if this comment was created via an email reply. | ||
| ResourcePath | String | The HTTP path for this issue. | ||
| Url | String | The HTTP URL for this issue. | ||
| LastEditedAt | Datetime | The moment the editor made the last edit. | ||
| PublishedAt | Datetime | Identifies when the comment was published at. | ||
| ClosedAt | Datetime | 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 |
Milestones.Id | Identifies the milestone associated with the issue. | |
| MilestoneTitle | String | Identifies the title of the milestone. | ||
| MilestoneNumber | Int | Identifies the number of the milestone. | ||
| IsReadByViewer | Bool | Is this issue read by the viewer. | ||
| ViewerDidAuthor | Bool | Did the viewer author this comment? | ||
| ViewerSubscription | String | Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. | ||
| ViewerCanClose | Bool | Indicates if the object can be closed by the viewer. | ||
| ViewerCanReopen | Bool | Indicates if the object can be reopened by the viewer. | ||
| ViewerCanDelete | Bool | Check if the current viewer can delete this object. | ||
| ViewerCanReact | Bool | Can user react to this subject? | ||
| ViewerCanSubscribe | Bool | Check if the viewer is able to change their subscription status for the repository. | ||
| ViewerThreadSubscriptionStatus | String | Identifies the viewer's thread subscription status. | ||
| ViewerThreadSubscriptionFormAction | String | Identifies the viewer's thread subscription form action. | ||
| ViewerCanUpdate | Bool | Check if the current viewer can update this object. | ||
| ViewerCannotUpdateReasons | String | Reasons why the current viewer can not update this comment. | ||
| CommentCount | Int | The number of comments on the issue. | ||
| ReactionCount | Int | The number of reactions on the issue. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| 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. |