ItemReviewers
Lists information and values of the 'Reviewers' field for the project items.
View-Specific Information
Select
The connector uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The connector processes other filters client-side within the connector.
- ItemId supports the '=' comparison operator.
SELECT * FROM [Project].[ItemReviewers] WHERE [Project].[ItemReviewers].[ItemId] = 'EXAMPLE'
Columns
| Name | Type | References | OrderBySupport | Description |
| ItemId [KEY] | String | The ID of the item. | ||
| NodeId [KEY] | String | The ID of the object. | ||
| UserId | String | The ID of the user. | ||
| UserDatabaseId | Int | Identifies the primary key from the database. | ||
| UserLogin | String | The username used to login. | ||
| UserName | String | The user's public profile name. | ||
| UserEmail | String | The user's publicly visible profile email. | ||
| UserTwitterUsername | String | The user's Twitter username. | ||
| UserPronouns | String | The user's profile pronouns. | ||
| UserBio | String | The user's public profile bio. | ||
| UserBioHTML | String | The user's public profile bio as HTML. | ||
| UserCompany | String | The user's public profile company. | ||
| UserCompanyHTML | String | The user's public profile company as HTML. | ||
| UserLocation | String | The user's public profile location. | ||
| UserAnyPinnableItems | 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. | ||
| UserPinnedItemsRemaining | Int | Returns how many more items this profile owner can pin to their profile. | ||
| UserItemShowcaseHasPinnedItems | Bool | Whether or not the owner has pinned any repositories or gists. | ||
| UserIsEmployee | Bool | Whether or not this user is a GitHub employee. | ||
| UserIsHireable | Bool | Whether or not the user has marked themselves as for hire. | ||
| UserIsBountyHunter | Bool | Whether or not this user is a participant in the GitHub Security Bug Bounty. | ||
| UserIsCampusExpert | Bool | Whether or not this user is a participant in the GitHub Campus Experts Program. | ||
| UserIsFollowingViewer | Bool | Whether or not this user is following the viewer. Inverse of viewerIsFollowing. | ||
| UserIsSiteAdmin | Bool | Whether or not this user is a site administrator. | ||
| UserIsDeveloperProgramMember | Bool | Whether or not this user is a GitHub Developer Program member. | ||
| UserIsGitHubStar | Bool | Whether or not this user is a member of the GitHub Stars Program. | ||
| UserIsSponsoringViewer | Bool | True if the viewer is sponsored by this user/organization. | ||
| UserIsViewer | Bool | Whether or not this user is the viewing user. | ||
| UserViewerCanFollow | Bool | Whether or not the viewer is able to follow the user. | ||
| UserViewerCanSponsor | Bool | Whether or not the viewer is able to sponsor this user/organization. | ||
| UserViewerIsFollowing | Bool | Whether or not this user is followed by the viewer. | ||
| UserViewerIsSponsoring | Bool | True if the viewer is sponsoring this user/organization. | ||
| UserViewerCanCreateProjects | Bool | Can the current viewer create new projects on this owner. | ||
| UserViewerCanChangePinnedItems | Bool | Can the viewer pin repositories and gists to the profile?. | ||
| UserStatusId | String | The emoji's id. | ||
| UserStatusEmoji | String | An emoji summarizing the user's status. | ||
| UserStatusMessage | String | A brief message describing what the user is doing. | ||
| UserStatusIndicatesLimitedAvailability | Bool | Whether this status indicates the user is not fully available on GitHub. | ||
| UserStatusEmojiHTML | String | The status emoji as HTML. | ||
| UserStatusCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| UserStatusExpiresAt | Datetime | If set, the status will not be shown after this date. | ||
| UserStatusUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| UserStatusOrganizationId | String | The organization's id. | ||
| UserStatusOrganizationLogin | String | The organization's login name. | ||
| UserInteractionAbilityLimit | String | The current limit that is enabled on this object. | ||
| UserInteractionAbilityOrigin | String | The origin of the currently active interaction limit. | ||
| UserInteractionAbilityExpiresAt | Datetime | The time the currently active limit expires. | ||
| UserHasSponsorsListing | Bool | True if this user/organization has a GitHub Sponsors listing. | ||
| UserMonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly GitHub Sponsors income for this user/organization in cents (USD). | ||
| UserEstimatedNextSponsorsPayoutInCents | Int | The estimated next GitHub Sponsors payout for this user/organization in cents (USD). | ||
| UserSponsorsListingId | String | The listing's id. | ||
| UserSponsorsListingName | String | The listing's full name. | ||
| UserTotalSponsorshipAmountAsSponsorInCents | 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. | ||
| UserResourcePath | String | The HTTP path for this user. | ||
| UserProjectsResourcePath | String | The HTTP path listing user's projects. | ||
| UserUrl | String | The HTTP URL for this user. | ||
| UserProjectsUrl | String | The HTTP URL listing user's projects. | ||
| UserWebsiteUrl | String | A URL pointing to the user's public website/blog. | ||
| UserAvatarUrl | String | A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image. | ||
| UserCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| UserUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| UserRepositoryCount | Int | The number of repositories that a user owns. | ||
| UserFollowerCount | Int | The number of followers that a user has. | ||
| BotId | String | The ID for this bot. | ||
| BotDatabaseId | Int | Identifies the primary key from the database. | ||
| BotLogin | String | The username of the actor. | ||
| BotUrl | String | The HTTP URL for this bot | ||
| BotResourcePath | String | The HTTP path for this bot | ||
| BotCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| BotUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| MannequinId | String | The ID for this mannequin. | ||
| MannequinDatabaseId | Int | Identifies the primary key from the database. | ||
| MannequinLogin | String | The username of the actor. | ||
| MannequinEmail | String | The mannequin's email on the source instance. | ||
| MannequinUrl | String | The URL to this resource. | ||
| MannequinResourcePath | String | The HTML path to this resource. | ||
| MannequinCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| MannequinUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| MannequinClaimantId | String | The ID of the claimant. | ||
| MannequinClaimantLogin | String | The username used to login. | ||
| TeamId | String | The ID of the team. | ||
| TeamDatabaseId | Int | Identifies the primary key from the database. | ||
| TeamOrganizationId | String | The ID of the organization. | ||
| TeamParentTeamId | String | The ID of the parent team of the team. | ||
| TeamParentTeamName | String | The name of the parent team of the team. | ||
| TeamName | String | The name of the team. | ||
| TeamDescription | String | The description of the team. | ||
| TeamPrivacy | String | The level of privacy the team has. | ||
| TeamSlug | String | The slug corresponding to the team. | ||
| TeamUrl | String | The HTTP URL for this team | ||
| TeamAvatarUrl | String | A URL pointing to the team's avatar. | ||
| TeamCombinedSlug | String | The slug corresponding to the organization and team. | ||
| TeamDiscussionsUrl | String | The HTTP URL for team discussions | ||
| TeamMembersUrl | String | The HTTP URL for the team' members | ||
| TeamNotificationSetting | String | The notification setting that the team has set. | ||
| TeamRepositoriesUrl | String | The HTTP URL for this team's repositories | ||
| TeamResourcePath | String | The HTTP path for this team | ||
| TeamTeamsUrl | String | The HTTP URL for this team's teams | ||
| TeamViewerSubscription | String | Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. | ||
| TeamDiscussionsResourcePath | String | The HTTP path for team discussions | ||
| TeamEditTeamUrl | String | The HTTP URL for editing this team | ||
| TeamMembersResourcePath | String | The HTTP path for the team' members | ||
| TeamNewTeamUrl | String | The HTTP URL creating a new team | ||
| TeamRepositoriesResourcePath | String | The HTTP path for this team's repositories | ||
| TeamTeamsResourcePath | String | The HTTP path for this team's teams | ||
| TeamViewerCanAdminister | Bool | Team is adminable by the viewer. | ||
| TeamViewerCanSubscribe | Bool | Check if the viewer is able to change their subscription status for the repository. | ||
| TeamEditTeamResourcePath | String | The HTTP path for editing this team | ||
| TeamNewTeamResourcePath | String | The HTTP path creating a new team | ||
| TeamCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| TeamUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| TeamReviewRequestDelegationAlgorithm | String | What algorithm is used for review assignment for this team. | ||
| TeamReviewRequestDelegationEnabled | Bool | True if review assignment is enabled for this team. | ||
| TeamReviewRequestDelegationMemberCount | Int | How many team members are required for review assignment for this team. | ||
| TeamReviewRequestDelegationNotifyTeam | Bool | When assigning team members via delegation, whether the entire team should be notified as well. |