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. |