ItemAssignees
Lists information and values of the 'Assignees' field for the project items.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The 本製品 processes other filters client-side within the 本製品.
- ItemId supports the '=' comparison operator.
SELECT * FROM [Project].[ItemAssignees] WHERE [Project].[ItemAssignees].[ItemId] = 'EXAMPLE'
Columns
| Name | Type | References | OrderBySupport | Description |
| ItemId [KEY] | String | The ID of the item. | ||
| Id [KEY] | String | The ID of the user. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| Login | String | The username used 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 as HTML. | ||
| Company | String | The user's public profile company. | ||
| CompanyHTML | String | The user's public profile company as HTML. | ||
| Location | String | The user's public profile location. | ||
| AnyPinnableItems | Bool | Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item. | ||
| PinnedItemsRemaining | Int | Returns how many more items this profile owner can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Whether or not the owner has pinned any repositories or gists. | ||
| IsEmployee | Bool | Whether or not this user is a GitHub employee. | ||
| IsHireable | Bool | Whether or not the user has marked themselves as for hire. | ||
| IsBountyHunter | Bool | Whether or not this user is a participant in the GitHub Security Bug Bounty. | ||
| IsCampusExpert | Bool | Whether or not this user is a participant in the GitHub Campus Experts Program. | ||
| IsFollowingViewer | Bool | Whether or not this user is following the viewer. Inverse of viewerIsFollowing. | ||
| IsSiteAdmin | Bool | Whether or not this user is a site administrator. | ||
| IsDeveloperProgramMember | Bool | Whether or not this user is a GitHub Developer Program member. | ||
| IsGitHubStar | Bool | Whether or not this user is a member of the GitHub Stars Program. | ||
| IsSponsoringViewer | Bool | True if the viewer is sponsored by this user/organization. | ||
| IsViewer | Bool | Whether or not this user is the viewing user. | ||
| ViewerCanFollow | Bool | Whether or not the viewer is able to follow the user. | ||
| ViewerCanSponsor | Bool | Whether or not the viewer is able to sponsor this user/organization. | ||
| ViewerIsFollowing | Bool | Whether or not this user is followed by the viewer. | ||
| ViewerIsSponsoring | Bool | True if the viewer is sponsoring this user/organization. | ||
| ViewerCanCreateProjects | Bool | Can the current viewer create new projects on this owner. | ||
| ViewerCanChangePinnedItems | Bool | Can the viewer pin repositories and gists to the profile?. | ||
| StatusId | String | The emoji's id. | ||
| StatusEmoji | String | An emoji summarizing the user's status. | ||
| StatusMessage | String | A brief message describing what the user is doing. | ||
| StatusIndicatesLimitedAvailability | Bool | Whether this status indicates the user is not fully available on GitHub. | ||
| StatusEmojiHTML | String | The status emoji as HTML. | ||
| StatusCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| StatusExpiresAt | Datetime | If set, the status will not be shown after this date. | ||
| StatusUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| StatusOrganizationId | String | The organization's id. | ||
| StatusOrganizationLogin | String | The organization's login name. | ||
| InteractionAbilityLimit | String | The current limit that is enabled on this object. | ||
| InteractionAbilityOrigin | String | The origin of the currently active interaction limit. | ||
| InteractionAbilityExpiresAt | Datetime | The time the currently active limit expires. | ||
| HasSponsorsListing | Bool | True if this user/organization has a GitHub Sponsors listing. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly GitHub Sponsors income for this user/organization in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated next GitHub Sponsors payout for this user/organization in cents (USD). | ||
| SponsorsListingId | String | The listing's id. | ||
| SponsorsListingName | String | The listing's full name. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization. | ||
| ResourcePath | String | The HTTP path for this user. | ||
| ProjectsResourcePath | String | The HTTP path listing user's projects. | ||
| Url | String | The HTTP URL for this user. | ||
| ProjectsUrl | String | The HTTP URL listing user's projects. | ||
| WebsiteUrl | String | A URL pointing to the user's public website/blog. | ||
| AvatarUrl | String | A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image. | ||
| CreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| RepositoryCount | Int | The number of repositories that a user owns. | ||
| FollowerCount | Int | The number of followers that a user has. |