OrganizationTeamRepositories
Tracks repositories that teams in an organization have access to, along with permission levels for each repository.
View-Specific Information
Select
The driver uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- OrganizationTeamSlug supports the '=,IN' comparison operators.
- OrganizationLogin supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [OrganizationTeamRepositories]
SELECT * FROM [OrganizationTeamRepositories] WHERE [OrganizationTeamSlug] = 'Val1'
SELECT * FROM [OrganizationTeamRepositories] WHERE [OrganizationLogin] = 'Val1'
The driver processes other filters client-side within the driver.
The driver uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:
- Name
- StargazerCount
- PushedAt
- CreatedAt
- Permission
SELECT * FROM [OrganizationTeamRepositories] ORDER BY [Name]
SELECT * FROM [OrganizationTeamRepositories] ORDER BY [StargazerCount]
SELECT * FROM [OrganizationTeamRepositories] ORDER BY [PushedAt]
SELECT * FROM [OrganizationTeamRepositories] ORDER BY [CreatedAt]
SELECT * FROM [OrganizationTeamRepositories] ORDER BY [Permission]
The driver uses client-side processing when ordering by any other columns. This impacts performance.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier (node ID) of the repository. | ||
| DatabaseId | Int | The primary key identifier for the repository in the database, used for internal reference. | ||
| Name | String | The name of the repository, as set by its owner. | ||
| NameWithOwner | String | The repository's name, prefixed with the owner's username or organization (for example, 'owner/repository-name'). | ||
| Visibility | String | Indicates the visibility level of the repository ('public', 'private', or 'internal'). | ||
| DiskUsage | Int | The amount of disk space (in kilobytes) that the repository occupies. | ||
| ForkCount | Int | The total number of forks created from this repository across the network. | ||
| StargazerCount | Int | The total number of users who have starred this repository. | ||
| WatcherCount | Int | The total number of users watching this repository for updates. | ||
| TopicCount | Int | The number of topics assigned to the repository to improve discoverability. | ||
| TempCloneToken | String | A temporary authentication token for cloning the repository. | ||
| WebCommitSignoffRequired | Bool | Indicates whether contributors must sign off on web-based commits to this repository. | ||
| UsesCustomOpenGraphImage | Bool | Indicates whether the repository uses a custom image for Open Graph instead of the owner's avatar. | ||
| Description | String | A brief text description of the repository, as provided by the owner. | ||
| DescriptionHTML | String | The HTML-rendered version of the repository's description for display purposes. | ||
| ShortDescriptionHTML | String | A simplified version of the repository's description, rendered in HTML without links. | ||
| ResourcePath | String | The relative HTTP path to access the repository on GitHub. | ||
| ProjectsResourcePath | String | The relative HTTP path listing the repository's associated projects. | ||
| Url | String | The absolute HTTP URL to the repository's main page on GitHub. | ||
| HomepageUrl | String | The URL of the repository's homepage, if specified. | ||
| MirrorUrl | String | The URL of the repository's original mirror, if applicable. | ||
| ProjectsUrl | String | The absolute HTTP URL listing the repository's associated projects. | ||
| SecurityPolicyUrl | String | The URL pointing to the repository's security policy, if available. | ||
| SSHUrl | String | The SSH URL used for cloning the repository. | ||
| OpenGraphImageUrl | String | The image used to represent this repository in Open Graph metadata. | ||
| MergeCommitTitle | String | Specifies how the default commit title is generated when merging a pull request (for example, 'pull request title'). | ||
| MergeCommitMessage | String | Specifies how the default commit message is generated when merging a pull request (for example, 'pull request description'). | ||
| SquashMergeCommitTitle | String | Specifies how the default commit title is generated when squash merging a pull request. | ||
| SquashMergeCommitMessage | String | Specifies how the default commit message is generated when squash merging a pull request. | ||
| DeleteBranchOnMerge | Bool | Indicates whether branches are automatically deleted after being merged in this repository. | ||
| HasDiscussionsEnabled | Bool | Indicates whether the Discussions feature is enabled for this repository. | ||
| HasIssuesEnabled | Bool | Indicates whether the Issues feature is enabled for this repository. | ||
| HasProjectsEnabled | Bool | Indicates whether the Projects feature is enabled for this repository. | ||
| HasWikiEnabled | Bool | Indicates whether the Wiki feature is enabled for this repository. | ||
| HasVulnerabilityAlertsEnabled | Bool | Indicates whether vulnerability alerts are enabled for this repository. | ||
| HasSponsorshipsEnabled | Bool | Indicates whether the repository displays a Sponsor button for financial contributions. | ||
| IsInOrganization | Bool | Indicates whether the repository is owned by an organization or is a private fork of an organization repository. | ||
| IsBlankIssuesEnabled | Bool | Indicates whether blank issue creation is allowed for this repository. | ||
| IsSecurityPolicyEnabled | Bool | Indicates whether the repository has a security policy in place. | ||
| IsUserConfigurationRepository | Bool | Indicates whether the repository is a user configuration repository. | ||
| IsArchived | Bool | Indicates whether the repository is archived and unmaintained. | ||
| IsDisabled | Bool | Indicates whether the repository is disabled. | ||
| IsEmpty | Bool | Indicates whether the repository is empty. | ||
| IsFork | Bool | Indicates whether the repository is a fork of another repository. | ||
| IsLocked | Bool | Indicates whether the repository is locked. | ||
| IsMirror | Bool | Indicates whether the repository is a mirror of another repository. | ||
| IsPrivate | Bool | Indicates whether the repository is private and not publicly accessible. | ||
| IsTemplate | Bool | Indicates whether the repository is a template that can be used to generate new repositories. | ||
| LockReason | String | The reason why the repository has been locked, if applicable.
The allowed values are BILLING, MIGRATING, MOVING, RENAME. | ||
| TemplateRepositoryId | String | The unique identifier (node ID) of the template repository from which this repository was generated, if any. | ||
| ParentId | String | The unique identifier (node ID) of the parent repository, if this repository is a fork. | ||
| ForkingAllowed | Bool | Indicates whether forking is allowed for this repository. | ||
| AutoMergeAllowed | Bool | Indicates whether Auto-merge can be enabled on pull requests for this repository. | ||
| SquashMergeAllowed | Bool | Indicates whether squash-merging is enabled for pull requests in this repository. | ||
| RebaseMergeAllowed | Bool | Indicates whether rebase-merging is enabled for pull requests in this repository. | ||
| MergeCommitAllowed | Bool | Indicates whether pull requests can be merged with a merge commit in this repository. | ||
| AllowUpdateBranch | Bool | Indicates whether pull request head branches that are behind their base branches can be updated even if it is not required for merging. | ||
| ViewerPermission | String | Specifies the permission level of the viewer on the repository (for example, 'read', 'write', 'admin'). Returns null if authenticated as a GitHub App.
The allowed values are ADMIN, MAINTAIN, READ, TRIAGE, WRITE. | ||
| ViewerSubscription | String | Indicates whether the viewer is watching, not watching, or ignoring the repository.
The allowed values are IGNORED, SUBSCRIBED, UNSUBSCRIBED. | ||
| ViewerHasStarred | Bool | Indicates whether the viewing user has starred this repository. | ||
| ViewerDefaultCommitEmail | String | The email address used by the viewer for their last commit in this repository. | ||
| ViewerDefaultMergeMethod | String | The last merge method used by the viewer (for example, 'merge', 'squash', 'rebase') or the repository's default merge method. | ||
| ViewerPossibleCommitEmails | String | A list of email addresses the viewer can use for committing in this repository. | ||
| ViewerCanAdminister | Bool | Indicates whether the viewer has administrative permissions on this repository. | ||
| ViewerCanSubscribe | Bool | Indicates whether the viewer can change their subscription status for this repository. | ||
| ViewerCanCreateProjects | Bool | Indicates whether the viewer can create new projects within this repository. | ||
| ViewerCanUpdateTopics | Bool | Indicates whether the viewer can update the topics (tags) for this repository. | ||
| CodeOfConductId | String | The unique identifier (node ID) of the Code of Conduct associated with this repository. | ||
| CodeOfConductName | String | The formal name of the Code of Conduct applied to this repository. | ||
| CodeOfConductBody | String | The text body of the Code of Conduct describing its rules and guidelines. | ||
| CodeOfConductKey | String | The unique key identifier for the Code of Conduct. | ||
| CodeOfConductUrl | String | The absolute HTTP URL to view the Code of Conduct for this repository. | ||
| CodeOfConductResourcePath | String | The relative HTTP path to view the Code of Conduct for this repository. | ||
| DefaultBranchRefId | String | The unique identifier (node ID) of the default branch in this repository. | ||
| DefaultBranchRefName | String | The name of the default branch for this repository (for example, 'main', 'master'). | ||
| InteractionAbilityLimit | String | Specifies the current interaction restriction applied to this repository (for example, 'collaborators only'). | ||
| InteractionAbilityOrigin | String | The source or reason for the currently active interaction restriction (for example, account settings, admin action). | ||
| InteractionAbilityExpiresAt | Datetime | The expiration date and time for the current interaction restriction, if applicable. | ||
| LatestReleaseId | String | The unique identifier (node ID) of the latest release in this repository. | ||
| LatestReleaseName | String | The title of the latest release in this repository. | ||
| LicenseId | String | The unique identifier (node ID) of the license associated with the repository. | ||
| LicenseKey | String |
Licenses.Key | The unique key identifier for the license associated with the repository (for example, 'mit', 'apache-2.0'). | |
| LanguageId | String | The unique identifier (node ID) of the primary programming language used in the repository. | ||
| LanguageName | String | The name of the primary programming language used in the repository (for example, 'JavaScript', 'Python'). | ||
| LanguageColor | String | The hexadecimal color code associated with the primary programming language used in the repository. | ||
| PushedAt | Datetime | The date and time when the repository was last pushed to, in ISO 8601 format. | ||
| ArchivedAt | Datetime | The date and time when the repository was archived, in ISO 8601 format. | ||
| CreatedAt | Datetime | The date and time when the repository was created, in ISO 8601 format. | ||
| UpdatedAt | Datetime | The date and time when the repository was last updated, in ISO 8601 format. | ||
| PlanFeaturesCodeOwners | Bool | Indicates whether the repository supports automatic review requests and enforcement using a CODEOWNERS file. | ||
| PlanFeaturesDraftPullRequests | Bool | Indicates whether the repository allows pull requests to be created as drafts or converted to drafts. | ||
| PlanFeaturesMaximumAssignees | Int | The maximum number of users that can be assigned to an issue or pull request in this repository. | ||
| PlanFeaturesMaximumManualReviewRequests | Int | The maximum number of manually requested reviews allowed on a pull request in this repository. | ||
| PlanFeaturesTeamReviewRequests | Bool | Indicates whether teams can be requested to review pull requests in this repository. | ||
| Permission | String | The permission level that the team has on the repository (for example, 'read', 'write', 'admin', 'maintain', 'triage'). | ||
| OrganizationTeamSlug [KEY] | String |
OrganizationTeams.Slug | The URL-friendly identifier (slug) for the team associated with the repository. | |
| OrganizationLogin [KEY] | String |
Organizations.Login | The login (username) of the organization associated with the repository. |