MentionableUsers
Identifies users who can be mentioned in repository discussions, including issues, pull requests, and comments, based on 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 [MentionableUsers]
SELECT * FROM [MentionableUsers] WHERE [Login] = 'Val1'
The 本製品 processes other filters client-side within the 本製品.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | A unique identifier for the user within the GitHub platform. | ||
| DatabaseId | Int | The primary key of the user record in the GitHub database. | ||
| Login | String | The username the user uses to log in to GitHub. | ||
| Name | String | The public profile name of the user, as displayed on their GitHub account. | ||
| String | The user's publicly visible email address, if provided. | |||
| TwitterUsername | String | The user's Twitter username, if linked to their GitHub profile. | ||
| Pronouns | String | The pronouns the user has chosen for their public profile. | ||
| Bio | String | The user's brief description or bio displayed on their public profile. | ||
| BioHTML | String | The user's bio formatted in HTML for rendering on their profile. | ||
| Company | String | The company the user publicly associates with on their profile. | ||
| CompanyHTML | String | The user's company name formatted in HTML for rendering. | ||
| Location | String | The location the user has provided on their GitHub profile. | ||
| AnyPinnableItems | Bool | Indicates whether the user has any repositories or other items that can be pinned to their profile. | ||
| PinnedItemsRemaining | Int | The number of additional items the user can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether the user has pinned any repositories or gists to their profile. | ||
| 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 is a participant in the GitHub Security Bug Bounty program. | ||
| IsCampusExpert | Bool | Indicates whether the user is part of the GitHub Campus Experts Program. | ||
| IsFollowingViewer | Bool | Indicates whether the user is following the current viewer (inverse of viewerIsFollowing). | ||
| IsSiteAdmin | Bool | Indicates whether the user is a site administrator for GitHub. | ||
| 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 being sponsored by this user or organization. | ||
| IsViewer | Bool | Indicates whether the current user is the viewer (that is, the user making the request). | ||
| ViewerCanFollow | Bool | Indicates whether the viewer can follow this user. | ||
| ViewerCanSponsor | Bool | Indicates whether the viewer can sponsor this user or organization. | ||
| ViewerIsFollowing | Bool | Indicates whether the viewer is currently 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 under this owner. | ||
| ViewerCanChangePinnedItems | Bool | Indicates whether the viewer has permission to pin repositories or gists to the owner's profile. | ||
| StatusId | String | The unique identifier for the user's status emoji. | ||
| StatusEmoji | String | The emoji representing the user's current status. | ||
| StatusMessage | String | A brief description of the user's current activity or status. | ||
| StatusIndicatesLimitedAvailability | Bool | Indicates whether the user's status suggests they are not fully available on GitHub. | ||
| StatusEmojiHTML | String | The status emoji represented as HTML code for embedding. | ||
| StatusCreatedAt | Datetime | The date and time when the user's status was created. | ||
| StatusExpiresAt | Datetime | The expiration date for the status, after which it is no longer be displayed. | ||
| StatusUpdatedAt | Datetime | The date and time when the user's status was last updated. | ||
| StatusOrganizationId | String | The unique identifier for the organization associated with the status, if applicable. | ||
| StatusOrganizationLogin | String | The login name of the organization associated with the status, if applicable. | ||
| InteractionAbilityLimit | String | The current interaction limit in place on this object, if any. | ||
| InteractionAbilityOrigin | String | The source of the active interaction limit on this object. | ||
| InteractionAbilityExpiresAt | Datetime | The date and 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 this user or organization receives through GitHub Sponsors, in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated amount this user or organization will receive in their next GitHub Sponsors payout, in cents (USD). | ||
| SponsorsListingId | String | The unique identifier for the GitHub Sponsors listing associated with this user or organization. | ||
| SponsorsListingName | String | The full name of the GitHub Sponsors listing. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount this user or organization has spent on GitHub sponsorships, in US cents. Only visible to the user themselves or those who can manage sponsorships. | ||
| ResourcePath | String | The relative HTTP path to access the user's profile. | ||
| ProjectsResourcePath | String | The relative HTTP path to access the user's project listings. | ||
| Url | String | The full HTTP URL to the user's GitHub profile. | ||
| ProjectsUrl | String | The full HTTP URL to the user's project listings. | ||
| WebsiteUrl | String | A URL pointing to the user's personal website or blog. | ||
| AvatarUrl | String | A URL pointing to the user's avatar image. | ||
| CopilotEndpointsApi | String | The API endpoint for GitHub Copilot. | ||
| CopilotEndpointsOriginTracker | String | The origin tracker endpoint for GitHub Copilot. | ||
| CopilotEndpointsProxy | String | The proxy endpoint for GitHub Copilot. | ||
| CopilotEndpointsTelemetry | String | The telemetry endpoint for GitHub Copilot. | ||
| CreatedAt | Datetime | Represents the exact date and time when the user or object was first created in the system. This field can be used to track the object's lifecycle or for filtering and sorting based on creation date. | ||
| UpdatedAt | Datetime | Represents the most recent date and time when the user or object was modified. It can be helpful for tracking changes, updates, or for identifying the last time the record was actively managed. | ||
| RepositoryCount | Int | Indicates how many repositories are currently owned by the user. This is a count of all repositories that have been created or forked by the user, providing insight into their activity level in terms of repository creation. | ||
| FollowerCount | Int | Displays the total number of followers associated with the user’s profile. This metric reflects the user’s popularity or influence within the GitHub community. |