IssuePullRequests
Connects issues to related pull requests, allowing traceability between reported problems and their solutions.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- IssueNumber supports the '=,IN' comparison operators.
- UserLinkedOnly supports the '=' comparison operator.
- ExcludeClosedPullRequests supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [IssuePullRequests]
SELECT * FROM [IssuePullRequests] WHERE [IssueNumber] = 123
SELECT * FROM [IssuePullRequests] WHERE [UserLinkedOnly] = true
SELECT * FROM [IssuePullRequests] WHERE [ExcludeClosedPullRequests] = true
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| IssueId [KEY] | String |
Issues.Id | The unique identifier for an issue within the repository. | |
| IssueNumber | Int |
Issues.Number | The sequential number assigned to an issue within the repository. | |
| IssueAuthor | String | The username of the user who created the issue. | ||
| IssueState | String | The current state of the issue, such as open, closed, or draft. | ||
| IssueTitle | String | The title summarizing the issue's purpose or content. | ||
| IssueLastEditedAt | Datetime | The date and time when the issue was last edited by any user. | ||
| IssuePublishedAt | Datetime | The date and time when the issue was first published. | ||
| IssueClosedAt | Datetime | The date and time when the issue was marked as closed. | ||
| IssueUpdatedAt | Datetime | The most recent date and time the issue's content or metadata was updated. | ||
| IssueCreatedAt | Datetime | The date and time when the issue was initially created. | ||
| PullRequestId [KEY] | String |
PullRequests.Id | The unique identifier for a pull request within the repository. | |
| PullRequestNumber | Int |
PullRequests.Number | The sequential number assigned to a pull request within the repository. | |
| PullRequestState | String | The current state of the pull request, such as open, closed, or merged. | ||
| PullRequestAuthor | String | The username of the user who created the pull request. | ||
| PullRequestTitle | String | The title summarizing the pull request's purpose or changes. | ||
| PullRequestReviewDecision | String | The current review status of the pull request, such as approved or changes requested. | ||
| PullRequestMergeable | String | Indicates whether the pull request can be merged, considering potential merge conflicts. | ||
| PullRequestLastEditedAt | Datetime | The date and time when the pull request was last edited by any user. | ||
| PullRequestMergedAt | Datetime | The date and time when the pull request was successfully merged. | ||
| PullRequestClosedAt | Datetime | The date and time when the pull request was marked as closed. | ||
| PullRequestPublishedAt | Datetime | The date and time when the pull request was first published. | ||
| PullRequestUpdatedAt | Datetime | The most recent date and time the pull request's content or metadata was updated. | ||
| PullRequestCreatedAt | Datetime | The date and time when the pull request was initially created. | ||
| UserLinkedOnly | Bool | Filters results to include only pull requests manually linked to issues. | ||
| ExcludeClosedPullRequests | Bool | Filters results to exclude pull requests that are closed. |