ItemLinkedPullRequests
Connects pull requests to specific project items, creating traceability between project tasks and related code changes.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- ItemId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [ItemLinkedPullRequests]
SELECT * FROM [ItemLinkedPullRequests] WHERE [ItemId] = 'Val1'
The 本製品 processes other filters client-side within the 本製品.
Columns
| Name | Type | References | OrderBySupport | Description |
| ItemId [KEY] | String | A unique identifier for the item (for example, issue or task) associated with the linked pull request. | ||
| Id [KEY] | String | A unique identifier for the pull request. | ||
| FullDatabaseId | Long | The primary key of the pull request in the database, stored as a BigInt for scalability. | ||
| Author | String | The login name of the user who authored the pull request. | ||
| AuthorAssociation | String | The author's relationship with the repository (for example, 'CONTRIBUTOR', 'MEMBER', or 'OWNER'). | ||
| Editor | String | The login name of the user who last edited the body of the pull request. | ||
| HeadRepositoryId | String | The unique identifier for the repository associated with the pull request's head branch. | ||
| HeadRepositoryOwner | String | The login name of the owner of the repository associated with the pull request's head branch. | ||
| MergedBy | String | The login name of the user who merged the pull request. | ||
| BaseRefId | String | The unique identifier for the base branch of the pull request, even if the branch has been deleted. | ||
| BaseRefOid | String | The Git Object ID (OID) of the base branch associated with the pull request. | ||
| BaseRefPrefix | String | The prefix (for example, 'refs/heads/') of the base branch associated with the pull request. | ||
| BaseRefName | String | The name of the base branch associated with the pull request, even if the branch has been deleted. | ||
| HeadRefId | String | The unique identifier for the head branch of the pull request, even if the branch has been deleted. | ||
| HeadRefOid | String | The Git Object ID (OID) of the head branch associated with the pull request. | ||
| HeadRefPrefix | String | The prefix (for example, 'refs/heads/') of the head branch associated with the pull request. | ||
| HeadRefName | String | The name of the head branch associated with the pull request, even if the branch has been deleted. | ||
| Title | String | The title of the pull request, summarizing its purpose or changes. | ||
| TitleHTML | String | The pull request title formatted in HTML for rendering in web applications. | ||
| Body | String | The full content of the pull request description written in Markdown. | ||
| BodyText | String | The content of the pull request description rendered as plain text. | ||
| BodyHTML | String | The content of the pull request description rendered as HTML for display purposes. | ||
| State | String | The current state of the pull request (for example, 'OPEN', 'CLOSED', or 'MERGED').
使用できる値は次のとおりです。OPEN, CLOSED, MERGED | ||
| Number | Int | The unique number assigned to the pull request within its repository. | ||
| Mergeable | String | Indicates whether the pull request is mergeable, based on the absence of merge conflicts. | ||
| Merged | Bool | Indicates whether the pull request has been successfully merged. | ||
| Closed | Bool | Indicates whether the pull request is closed without being merged. | ||
| ChangedFiles | Int | The total number of files that were modified in this pull request. | ||
| Additions | Int | The total number of lines added in this pull request. | ||
| Deletions | Int | The total number of lines removed in this pull request. | ||
| TotalCommentsCount | Int | The total number of comments, including review comments, on this pull request. | ||
| ReviewDecision | String | The current review status of the pull request, such as 'APPROVED', 'CHANGES_REQUESTED', or 'REVIEW_REQUIRED'. | ||
| Locked | Bool | Indicates whether the pull request is locked to prevent further discussion or changes. | ||
| ActiveLockReason | String | The reason provided for locking the conversation on this pull request, such as 'RESOLVED' or 'OFF_TOPIC'. | ||
| IsDraft | Bool | Indicates whether the pull request is a draft, meaning it is not yet ready for review or merging. | ||
| IsCrossRepository | Bool | Indicates whether the pull request's base and head branches are in different repositories. | ||
| MaintainerCanModify | Bool | Indicates whether repository maintainers are allowed to make changes to the pull request's branch. | ||
| CreatedViaEmail | Bool | Indicates whether this comment on the pull request was created through an email reply. | ||
| IncludesCreatedEdit | Bool | Indicates whether the comment on the pull request has been edited and includes data from the original creation. | ||
| MergeCommitId | String | The unique commit ID generated when the pull request was successfully merged. | ||
| PotentialMergeCommitId | String | The unique commit ID generated by GitHub to test the mergeability of the pull request. This is not available if the pull request is already merged or if the test is still in progress. | ||
| Permalink | String | The permanent URL that links directly to this pull request. | ||
| ResourcePath | String | The relative HTTP path for accessing this pull request on GitHub. | ||
| ChecksResourcePath | String | The relative HTTP path for viewing the checks and statuses for this pull request. | ||
| RevertResourcePath | String | The relative HTTP path for initiating a revert of this pull request. | ||
| Url | String | The full HTTP URL for accessing this pull request. | ||
| ChecksUrl | String | The full HTTP URL for viewing the checks and statuses for this pull request. | ||
| RevertUrl | String | The full HTTP URL for initiating a revert of this pull request. | ||
| LastEditedAt | Datetime | The date and time when the last edit was made to this pull request. | ||
| MergedAt | Datetime | The date and time when the pull request was successfully merged. | ||
| ClosedAt | Datetime | The date and time when the pull request was closed, either by merging or other means. | ||
| PublishedAt | Datetime | The date and time when the comment associated with the pull request was published. | ||
| UpdatedAt | Datetime | The date and time when the pull request or its associated data was last updated. | ||
| CreatedAt | Datetime | The date and time when the pull request or its associated data was created. | ||
| MilestoneId | String | The unique identifier of the milestone associated with this pull request. | ||
| MilestoneTitle | String | The title of the milestone associated with this pull request. | ||
| MilestoneNumber | Int | The unique number of the milestone associated with this pull request. | ||
| AutoMergeRequestCommitHeadline | String | The title of the commit created as part of the auto-merge request. Set by the merge queue if required by the base branch. | ||
| AutoMergeRequestAuthorEmail | String | The email address of the user who initiated the auto-merge request. | ||
| AutoMergeRequestCommitBody | String | The commit message created as part of the auto-merge request. Set by the merge queue if required by the base branch. | ||
| AutoMergeRequestEnabledAt | Datetime | The date and time when the auto-merge request for this pull request was enabled. | ||
| AutoMergeRequestMergeMethod | String | Specifies the merge method (for example, 'MERGE', 'SQUASH', 'REBASE') used for the auto-merge request. This value is set by the merge queue if required by the base branch. | ||
| ViewerDidAuthor | Bool | Indicates whether the currently authenticated viewer authored this comment on the pull request. | ||
| IsReadByViewer | Bool | Indicates whether the pull request has been marked as read by the viewer. | ||
| ViewerSubscription | String | Identifies the viewer's subscription status for the pull request, such as 'WATCHING', 'NOT_WATCHING', or 'IGNORING'. | ||
| ViewerCanLabel | Bool | Indicates whether the viewer has permission to edit or add labels to the pull request. | ||
| ViewerCanClose | Bool | Indicates whether the viewer has permission to close the pull request. | ||
| ViewerCanReact | Bool | Indicates whether the viewer can react to this pull request or its comments with emoji reactions. | ||
| ViewerCanReopen | Bool | Indicates whether the viewer can reopen the pull request after it has been closed. | ||
| ViewerCanSubscribe | Bool | Indicates whether the viewer can change their subscription status for the repository containing this pull request. | ||
| ViewerCanApplySuggestion | Bool | Indicates whether the viewer has permission to apply suggested changes to the pull request. | ||
| ViewerCanEditFiles | Bool | Indicates whether the viewer can edit files within the context of this pull request. | ||
| ViewerCanDeleteHeadRef | Bool | Indicates whether the viewer can restore a deleted head reference associated with this pull request. | ||
| ViewerCanDisableAutoMerge | Bool | Indicates whether the viewer can disable the auto-merge feature for this pull request. | ||
| ViewerCanEnableAutoMerge | Bool | Indicates whether the viewer can enable the auto-merge feature for this pull request. | ||
| ViewerCanMergeAsAdmin | Bool | Indicates whether the viewer can bypass branch protection rules and merge the pull request immediately as an administrator. | ||
| ViewerCanUpdate | Bool | Indicates whether the viewer can update this pull request or its associated content. | ||
| ViewerCanUpdateBranch | Bool | Indicates whether the viewer can update the head branch of this pull request by merging or rebasing the base branch. | ||
| ViewerCannotUpdateReasons | String | A list of reasons why the viewer cannot update this pull request or its associated content. | ||
| ViewerLatestReviewRequestId | String | The unique ID of the viewer's most recent review request for this pull request. | ||
| ViewerLatestReviewId | String | The unique ID of the viewer's most recent review on this pull request. | ||
| IsMergeQueueEnabled | Bool | Indicates whether the base branch of this pull request has a merge queue enabled for managing merge operations. | ||
| IsInMergeQueue | Bool | Indicates whether the pull request is currently in a merge queue awaiting processing. | ||
| MergeQueueEntryId | String | A unique identifier for this pull request's entry in the merge queue. | ||
| MergeQueueEntryJump | Bool | Indicates whether this pull request is prioritized to jump ahead in the merge queue. | ||
| MergeQueueEntryPosition | Int | The position of this pull request's entry in the merge queue. | ||
| MergeQueueEntrySolo | Bool | Indicates whether this pull request needs to be merged or deployed independently, without batching with others. | ||
| MergeQueueEntryState | String | The current state of this pull request's entry in the merge queue, such as 'ENQUEUED', 'MERGING', or 'FAILED'. | ||
| MergeQueueEntryEnqueuedAt | Datetime | The date and time when this pull request was added to the merge queue. | ||
| MergeQueueEntryEstimatedTimeToMerge | Int | The estimated time in seconds until this pull request is expected to be merged. | ||
| MergeQueueEntryBaseCommitId | String | The unique ID of the base commit associated with this merge queue entry. | ||
| MergeQueueEntryHeadCommitId | String | The unique ID of the head commit associated with this merge queue entry. | ||
| MergeQueueEntryMergeQueueId | String | The unique identifier of the merge queue containing this pull request. | ||
| MergeQueueEntryMergeQueueUrl | String | The full HTTP URL for viewing the merge queue containing this pull request. | ||
| MergeQueueEntryMergeQueueResourcePath | String | The relative HTTP path for accessing the merge queue containing this pull request. | ||
| MergeQueueEntryMergeQueueNextEntryEstimatedTimeToMerge | Int | The estimated time in seconds until a newly added entry in this merge queue is expected to be merged. | ||
| StatusCheckRollupId | String | The unique Node ID of the StatusCheckRollup object, which aggregates status checks and runs. | ||
| StatusCheckRollupCommitId | String | The commit ID to which the status checks and check runs are attached. | ||
| StatusCheckRollupState | String | The combined status of all checks and runs for the associated commit, such as 'SUCCESS', 'PENDING', or 'FAILURE'. |