Watchers
A list of users watching the repository.
View-Specific Information
You must specify the UserLogin when executing a SELECT query against this view. You can specify the values in the WHERE clause or as connection properties. A value specified in the WHERE clause takes precedence over the connection property.
If you do not specify a UserLogin value, the driver will use the login name of the authenticated user.
Select
The driver uses the GitHub API to restrict results to the specified UserLogin and RepositoryName values.
The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.
- UserLogin and RepositoryName support the following operator: =
SELECT * FROM Watchers WHERE RepositoryName = 'MyRepo' SELECT * FROM Watchers WHERE UserLogin = 'MyUser' AND RepositoryName = 'MyRepo'
Columns
Name | Type | OrderBySupport | Description |
Id [KEY] | String | The ID of the user. | |
UserLogin | String | The login name of the user. | |
RepositoryName [KEY] | String | The name of the repository. | |
Name | String | The user's public profile name. | |
Company | String | The user's public profile company. | |
CompanyHTML | String | The user's public profile company as HTML. | |
CreatedAt | Datetime | Identifies the date and time when the object was created. | |
String | The user's publicly visible profile email. | ||
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. | |
IsDeveloperProgramMember | Bool | Whether or not this user is a GitHub Developer Program member. | |
IsEmployee | Bool | Whether or not this user is a GitHub employee. | |
IsHireable | Bool | Whether or not the user has marked themselves as for hire. | |
IsSiteAdmin | Bool | Whether or not this user is a site administrator. | |
IsViewer | Bool | Whether or not this user is the viewing user. | |
Location | String | The user's public profile location. | |
PinnedItemsRemaining | Integer | Returns how many more items this profile owner can pin to their profile. | |
ProjectsUrl | String | The HTTP URL listing user's projects. | |
ResourcePath | String | The HTTP path for this user. | |
TwitterUsername | String | The user's Twitter username. | |
UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | |
URL | String | The HTTP URL for this user. | |
ViewerCanChangePinnedItems | Bool | Can the viewer pin repositories and gists to the profile?. | |
ViewerCanCreateProjects | Bool | Can the current viewer create new projects on this owner. | |
ViewerCanFollow | Bool | Whether or not the viewer is able to follow the user. | |
ViewerIsFollowing | Bool | Whether or not this user is followed by the viewer. | |
WebsiteUrl | String | A URL pointing to the user's public website/blog. |