ItemAssignees
Tracks users assigned to project items, offering a detailed view of task ownership and accountability.
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:
- ItemId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [ItemAssignees]
SELECT * FROM [ItemAssignees] WHERE [ItemId] = 'Val1'
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| ItemId [KEY] | String | A unique identifier for the item being referenced, such as an issue or pull request. | ||
| Id [KEY] | String | A unique identifier for the user assigned to the item. | ||
| DatabaseId | Int | The primary key for the user in the database, used for internal reference. | ||
| Login | String | The username associated with the user's GitHub account, used for authentication and identification. | ||
| Name | String | The full name associated with the user's public GitHub profile. | ||
| String | The publicly visible email address of the user, if they have chosen to make it available. | |||
| TwitterUsername | String | The user's Twitter handle, as provided on their GitHub profile. | ||
| Pronouns | String | The pronouns listed by the user in their public GitHub profile, if provided. | ||
| Bio | String | The user's public biography, offering a brief description about themselves. | ||
| BioHTML | String | The user's public biography formatted in HTML, suitable for display in web applications. | ||
| Company | String | The organization or company associated with the user's public GitHub profile. | ||
| CompanyHTML | String | The organization or company formatted as HTML, suitable for rendering in web pages. | ||
| Location | String | The geographic location provided in the user's public profile, such as city or country. | ||
| AnyPinnableItems | Bool | Indicates whether the user has any repositories, gists, or projects that can be pinned to their profile. | ||
| PinnedItemsRemaining | Int | The number of additional items that the user can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether the user has pinned any repositories or gists to their profile showcase. | ||
| IsEmployee | Bool | Indicates if the user is an employee of GitHub. | ||
| IsHireable | Bool | Indicates if the user is open to job opportunities and marked as hireable. | ||
| IsBountyHunter | Bool | Indicates if the user participates in the GitHub Security Bug Bounty program. | ||
| IsCampusExpert | Bool | Indicates if the user is a participant in the GitHub Campus Experts Program. | ||
| IsFollowingViewer | Bool | Indicates if this user is following the authenticated viewer. This is the inverse of 'ViewerIsFollowing.' | ||
| IsSiteAdmin | Bool | Indicates if the user has site-wide administrative privileges on GitHub. | ||
| IsDeveloperProgramMember | Bool | Indicates if the user is a member of the GitHub Developer Program. | ||
| IsGitHubStar | Bool | Indicates if the user is recognized as a member of the GitHub Stars Program. | ||
| IsSponsoringViewer | Bool | Indicates if the user is sponsoring the authenticated viewer through GitHub Sponsors. | ||
| IsViewer | Bool | Indicates if this user is the currently authenticated viewer. | ||
| ViewerCanFollow | Bool | Indicates if the authenticated viewer has the ability to follow this user. | ||
| ViewerCanSponsor | Bool | Indicates if the authenticated viewer can sponsor this user or organization through GitHub Sponsors. | ||
| ViewerIsFollowing | Bool | Indicates if the authenticated viewer is following this user. | ||
| ViewerIsSponsoring | Bool | Indicates if the currently authenticated viewer is sponsoring this user or organization through GitHub Sponsors. | ||
| ViewerCanCreateProjects | Bool | Indicates if the authenticated viewer has permission to create new projects for this user or organization. | ||
| ViewerCanChangePinnedItems | Bool | Indicates if the viewer can pin repositories or 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, providing a visual summary. | ||
| StatusMessage | String | A brief text message describing the user's current activity or availability. | ||
| StatusIndicatesLimitedAvailability | Bool | Indicates whether the user's status signifies limited availability on GitHub. | ||
| StatusEmojiHTML | String | The user's status emoji formatted as HTML, suitable for rendering in web applications. | ||
| StatusCreatedAt | Datetime | The date and time when the user's status was initially set. | ||
| StatusExpiresAt | Datetime | The expiration date and time for the user's status, after which it is no longer displayed. | ||
| StatusUpdatedAt | Datetime | The date and time when the user's status was last updated. | ||
| StatusOrganizationId | String | The unique identifier of 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 type of interaction limit currently applied to this object, such as restricting comments or contributions. | ||
| InteractionAbilityOrigin | String | The origin or reason for the currently active interaction limit, such as an organization policy. | ||
| InteractionAbilityExpiresAt | Datetime | The date and time when the current interaction limit expires. | ||
| HasSponsorsListing | Bool | Indicates if this user or organization has a GitHub Sponsors listing to receive sponsorships. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly income from GitHub Sponsors for this user or organization, in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated amount for the next GitHub Sponsors payout, in cents (USD). | ||
| SponsorsListingId | String | The unique identifier of the GitHub Sponsors listing. | ||
| SponsorsListingName | String | The full name of the GitHub Sponsors listing associated with this user or organization. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount in US cents spent by this entity on sponsorships through GitHub. Only visible to the user or authorized managers. | ||
| ResourcePath | String | The HTTP path for accessing this user's profile. | ||
| ProjectsResourcePath | String | The HTTP path for viewing this user's GitHub projects. | ||
| Url | String | The HTTP URL for accessing this user's profile. | ||
| ProjectsUrl | String | The HTTP URL listing this user's GitHub projects. | ||
| WebsiteUrl | String | A URL pointing to the user's public website or blog, if provided. | ||
| AvatarUrl | String | A URL pointing to the user's public avatar image. The 'size' argument specifies the dimensions of the square image. | ||
| CopilotEndpointsApi | String | The API endpoint for GitHub Copilot integration. | ||
| CopilotEndpointsOriginTracker | String | The endpoint for tracking the origin of requests made through GitHub Copilot. | ||
| CopilotEndpointsProxy | String | The proxy endpoint for GitHub Copilot requests. | ||
| CopilotEndpointsTelemetry | String | The endpoint for gathering telemetry data related to GitHub Copilot usage. | ||
| CreatedAt | Datetime | The date and time when this object, such as a user or resource, was initially created. | ||
| UpdatedAt | Datetime | The date and time when this object was last updated or modified. | ||
| RepositoryCount | Int | The total number of repositories owned by the user. | ||
| FollowerCount | Int | The total number of users following this user on GitHub. |