AssignableUsers
Identifies users who are eligible to be assigned to repository issues, based on their roles and permissions.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following column and operator:
- Login supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [AssignableUsers]
SELECT * FROM [AssignableUsers] WHERE [Login] = 'Val1'
The 本製品 processes other filters client-side within the 本製品.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier for the user, used across the system. | ||
| DatabaseId | Int | The primary key for the user in the database, ensuring unique identification. | ||
| Login | String | The user's GitHub login username, used for authentication and display. | ||
| Name | String | The publicly visible name of the user, often used for display purposes. | ||
| String | The user's publicly visible email address, if they have chosen to share it. | |||
| TwitterUsername | String | The user's Twitter handle, linked to their GitHub profile. | ||
| Pronouns | String | The pronouns specified by the user on their profile. | ||
| Bio | String | A textual description of the user, provided on their public GitHub profile. | ||
| BioHTML | String | The user's biography rendered as HTML, for use in web applications. | ||
| Company | String | The organization or company the user is affiliated with, as per their profile. | ||
| CompanyHTML | String | The user's affiliated company rendered as HTML for web use. | ||
| Location | String | The geographic location provided by the user on their profile. | ||
| AnyPinnableItems | Bool | Indicates whether this user can pin items, such as repositories, to their profile. | ||
| PinnedItemsRemaining | Int | The number of additional items this user can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether this user has any pinned repositories or gists in their profile showcase. | ||
| IsEmployee | Bool | Specifies whether the user is an employee of GitHub. | ||
| IsHireable | Bool | Indicates whether the user has marked themselves as available for hiring opportunities. | ||
| IsBountyHunter | Bool | Indicates whether this user participates in the GitHub Security Bug Bounty program. | ||
| IsCampusExpert | Bool | Indicates whether this user is part of the GitHub Campus Experts program. | ||
| IsFollowingViewer | Bool | Indicates whether this user is following the current viewer. Inverse of ViewerIsFollowing. | ||
| IsSiteAdmin | Bool | Specifies whether the user has administrative privileges on the GitHub site. | ||
| IsDeveloperProgramMember | Bool | Indicates whether the user is a member of the GitHub Developer Program. | ||
| IsGitHubStar | Bool | Specifies whether the user is part of the GitHub Stars program, recognizing outstanding community members. | ||
| IsSponsoringViewer | Bool | True if the user or organization is sponsoring the current viewer on GitHub. | ||
| IsViewer | Bool | Indicates whether this user is the same as the current viewing user. | ||
| ViewerCanFollow | Bool | Indicates whether the current viewer has the option to follow this user. | ||
| ViewerCanSponsor | Bool | Indicates whether the current viewer can sponsor this user or organization. | ||
| ViewerIsFollowing | Bool | True if this user is currently being followed by the viewer. | ||
| ViewerIsSponsoring | Bool | True if the viewer is currently sponsoring this user or organization. | ||
| ViewerCanCreateProjects | Bool | Indicates whether the current viewer can create new projects associated with this user. | ||
| ViewerCanChangePinnedItems | Bool | Indicates whether the viewer has permission to pin repositories and gists to this user's profile. | ||
| StatusId | String | A unique identifier for the user's current status emoji. | ||
| StatusEmoji | String | An emoji representing the user's current status, such as availability or mood. | ||
| StatusMessage | String | A short custom message set by the user to describe their current status or activity. | ||
| StatusIndicatesLimitedAvailability | Bool | True if the status indicates that the user has limited availability on GitHub. | ||
| StatusEmojiHTML | String | The status emoji formatted as HTML for web display. | ||
| StatusCreatedAt | Datetime | The timestamp when the status was first created. | ||
| StatusExpiresAt | Datetime | If specified, this timestamp indicates when the status automatically expires and is no longer displayed. | ||
| StatusUpdatedAt | Datetime | The timestamp of the most recent update to the user's status. | ||
| StatusOrganizationId | String | A unique identifier for the organization associated with the user's status. | ||
| StatusOrganizationLogin | String | The login name of the organization associated with the user's status. | ||
| InteractionAbilityLimit | String | The current interaction restriction applied to this user or organization (for example, limit on who can comment or interact). | ||
| InteractionAbilityOrigin | String | Specifies the source of the current interaction limit (for example, user settings or GitHub policy). | ||
| InteractionAbilityExpiresAt | Datetime | The expiration timestamp of the current interaction limit, after which restrictions will be lifted. | ||
| HasSponsorsListing | Bool | True if this user or organization has a GitHub Sponsors listing to receive financial support. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly income in cents (USD) from GitHub Sponsors for this user or organization. | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated payout in cents (USD) for the next GitHub Sponsors disbursement. | ||
| SponsorsListingId | String | A unique identifier for the GitHub Sponsors listing associated with this user or organization. | ||
| SponsorsListingName | String | The full name of the GitHub Sponsors listing for this user or organization. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount in cents (USD) that this user or organization has spent on GitHub sponsorships. Visible only to the user or authorized managers. | ||
| ResourcePath | String | The relative GitHub API path to access this user's profile. | ||
| ProjectsResourcePath | String | The relative GitHub API path to list this user's projects. | ||
| Url | String | The full HTTP URL to the user's GitHub profile. | ||
| ProjectsUrl | String | The full HTTP URL listing the user's GitHub projects. | ||
| WebsiteUrl | String | A publicly shared URL linking to the user's personal website or blog. | ||
| AvatarUrl | String | A URL pointing to the user's avatar image. Accepts a size argument to specify the resolution. | ||
| CopilotEndpointsApi | String | The API endpoint used for GitHub Copilot services. | ||
| CopilotEndpointsOriginTracker | String | The tracking endpoint used to monitor Copilot request origins. | ||
| CopilotEndpointsProxy | String | The proxy endpoint for routing GitHub Copilot requests. | ||
| CopilotEndpointsTelemetry | String | The telemetry endpoint used for GitHub Copilot usage tracking. | ||
| CreatedAt | Datetime | The timestamp when this user account was created. | ||
| UpdatedAt | Datetime | The timestamp of the most recent update to the user's profile. | ||
| RepositoryCount | Int | The total number of repositories owned by the user. | ||
| FollowerCount | Int | The total number of followers the user has on GitHub. |