IssueAssignees
Tracks users assigned to issues within a repository, detailing responsibilities and roles for task ownership.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- IssueNumber supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [IssueAssignees]
SELECT * FROM [IssueAssignees] WHERE [IssueNumber] = 123
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique ID of the user assigned to the issue. | ||
| DatabaseId | Int | The primary key for the user in the database. | ||
| Login | String | The username that is used by the user to login. | ||
| Name | String | The user's public profile name. | ||
| String | The user's publicly visible profile email. | |||
| TwitterUsername | String | The user's Twitter username. | ||
| Pronouns | String | The user's profile pronouns. | ||
| Bio | String | The user's public profile bio. | ||
| BioHTML | String | The user's public profile bio rendered in HTML. | ||
| Company | String | The company listed in the user's public profile. | ||
| CompanyHTML | String | The user's company name rendered in HTML. | ||
| Location | String | The location of the user as listed on their public profile. | ||
| AnyPinnableItems | Bool | Indicates whether the repository owner has any items that can be pinned to their profile. | ||
| PinnedItemsRemaining | Int | The number of items that the profile owner can still pin. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether the owner has any pinned repositories or gists. | ||
| IsEmployee | Bool | Indicates whether the user is a GitHub employee. | ||
| IsHireable | Bool | Indicates whether the user has marked themselves as available for hire. | ||
| IsBountyHunter | Bool | Indicates whether the user participates in the GitHub Security Bug Bounty program. | ||
| IsCampusExpert | Bool | Indicates whether the user is a part of the GitHub Campus Experts Program. | ||
| IsFollowingViewer | Bool | Indicates whether the user is following the viewer. This is the inverse of viewerIsFollowing. | ||
| IsSiteAdmin | Bool | Indicates whether the user is a GitHub site administrator. | ||
| IsDeveloperProgramMember | Bool | Indicates whether the user is a member of the GitHub Developer Program. | ||
| IsGitHubStar | Bool | Indicates whether the user is a member of the GitHub Stars Program. | ||
| IsSponsoringViewer | Bool | Indicates whether the viewer is sponsored by this user or organization. | ||
| IsViewer | Bool | Indicates whether this user is the viewer. | ||
| ViewerCanFollow | Bool | Indicates whether the viewer is able to follow this user. | ||
| ViewerCanSponsor | Bool | Indicates whether the viewer is able to sponsor this user or organization. | ||
| ViewerIsFollowing | Bool | Indicates whether the viewer is following this user. | ||
| ViewerIsSponsoring | Bool | Indicates whether the viewer is sponsoring this user or organization. | ||
| ViewerCanCreateProjects | Bool | Indicates whether the current viewer can create new projects on this owner's account. | ||
| ViewerCanChangePinnedItems | Bool | Indicates whether the viewer can pin repositories and gists to their profile. | ||
| StatusId | String | The ID associated with the user's status emoji. | ||
| StatusEmoji | String | An emoji representing the user's current status. | ||
| StatusMessage | String | A brief message describing what the user is currently doing. | ||
| StatusIndicatesLimitedAvailability | Bool | Indicates whether the user's status signifies limited availability on GitHub. | ||
| StatusEmojiHTML | String | The HTML representation of the status emoji. | ||
| StatusCreatedAt | Datetime | The date and time when the status was created. | ||
| StatusExpiresAt | Datetime | The expiration date of the status. The status is not shown after this date. | ||
| StatusUpdatedAt | Datetime | The date and time when the status was last updated. | ||
| StatusOrganizationId | String | The ID of the organization associated with the user's status. | ||
| StatusOrganizationLogin | String | The login name of the organization associated with the status. | ||
| InteractionAbilityLimit | String | Describes the current interaction limit imposed on this object. | ||
| InteractionAbilityOrigin | String | Indicates the source or origin of the active interaction limit. | ||
| InteractionAbilityExpiresAt | Datetime | The time when the current interaction limit expires. | ||
| HasSponsorsListing | Bool | Indicates whether the user or organization has a GitHub Sponsors listing. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly income from GitHub Sponsors for this user or organization, in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated amount of the next GitHub Sponsors payout, in cents (USD). | ||
| SponsorsListingId | String | The ID of the GitHub Sponsors listing. | ||
| SponsorsListingName | String | The full name of the GitHub Sponsors listing. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount spent by the user/organization on GitHub Sponsors, in cents (USD). This value is only available for users who can manage sponsorships. | ||
| ResourcePath | String | The HTTP path for this user. | ||
| ProjectsResourcePath | String | The HTTP path listing the user's projects. | ||
| Url | String | The HTTP URL for this user's profile. | ||
| ProjectsUrl | String | The HTTP URL listing the user's projects. | ||
| WebsiteUrl | String | A URL pointing to the user's public website or blog. | ||
| AvatarUrl | String | A URL pointing to the user's public avatar. The 'size' argument specifies the size of the resulting square image. | ||
| CopilotEndpointsApi | String | The API endpoint for Copilot services. | ||
| CopilotEndpointsOriginTracker | String | The endpoint used for Copilot's origin tracking. | ||
| CopilotEndpointsProxy | String | The proxy endpoint used for Copilot services. | ||
| CopilotEndpointsTelemetry | String | The telemetry endpoint used by Copilot for data tracking. | ||
| CreatedAt | Datetime | The date and time when the object was created. | ||
| UpdatedAt | Datetime | The date and time when the object was last updated. | ||
| RepositoryCount | Int | The total number of repositories owned by the user. | ||
| FollowerCount | Int | The total number of followers the user has. | ||
| IssueNumber [KEY] | Int |
Issues.Number | The issue number associated with the assignee. |