IssuesBlocking
Lists all project issues which the specified issue is blocking.
View-Specific Information
Select
The driver uses the GitHub API to process WHERE clause conditions that are built with the following column and operator:
- BlockedById supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [IssuesBlocking] WHERE [BlockedById] = 'Val1'
The driver processes other filters client-side within the driver.
The driver uses the GitHub API to process ORDER BY clause conditions that are built with the following column: CreatedAt
SELECT * FROM [IssuesBlocking] WHERE [BlockedById] = 'Val1' ORDER BY [CreatedAt]
The driver uses client-side processing when ordering by any other columns. This impacts performance.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The Issue ID. | ||
| 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 issue. | ||
| AuthorType | String | The type of the actor who authored the issue. | ||
| AuthorAssociation | String | Author's association with the subject of the issue. | ||
| Editor | String | The username of the actor who edited the issue. | ||
| 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.
The allowed values are open, closed. | ||
| StateReason | String | Identifies the reason for the issue state.
The allowed values are COMPLETED, NOT_PLANNED, DUPLICATE, REOPENED. | ||
| 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 issue was edited and includes an edit with the creation data. | ||
| CreatedViaEmail | Bool | Check if this issue was created via an email reply. | ||
| DuplicateIssueId | String | ID of the issue that this is a duplicate of. | ||
| IssueDependenciesSummaryBlockedBy | Int | Count of issues this issue is blocked by. | ||
| IssueDependenciesSummaryBlocking | Int | Count of issues this issue is blocking. | ||
| IssueDependenciesSummaryTotalBlockedBy | Int | Total count of issues this issue is blocked by (open and closed). | ||
| IssueDependenciesSummaryTotalBlocking | Int | Total count of issues this issue is blocking (open and closed). | ||
| 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 issue was published at. | ||
| ClosedAt | Datetime | Identifies the date and time when the object was closed. | ||
| UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| CreatedAt | Datetime | 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 issue. | ||
| ViewerSubscription | String | Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. | ||
| ViewerCanLabel | Bool | Indicates if the viewer can edit labels for this object. | ||
| 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 issue. | ||
| CommentCount | Int | The number of comments on the issue. | ||
| ReactionCount | Int | The number of reactions on the issue. | ||
| TypeID | String | The Node ID of the IssueType object. | ||
| TypeName | String | The issue type's name. | ||
| TypeDescription | String | The issue type's description. | ||
| TypeIsEnabled | Bool | The issue type's enabled state. | ||
| TypeColor | String | The issue type's color. | ||
| BlockedById | String | The Issue ID which this issue is Blocked By. |