OrganizationTeamRepositories
Lists information about the repositories that the logged in user's organizations' teams or the teams of the specified organization have access to.
View-Specific Information
Select
The driver uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The driver processes other filters client-side within the driver.
- OrganizationLogin supports the '=' comparison operator.
- OrganizationTeamSlug supports the '=' comparison operator.
The driver uses the GitHub API to process ORDER BY clause conditions built with the following column when OrganizationLogin and OrganizationTeamSlug is specified in the criteria both with the '=' comparison operator, or when OwnerLogin is set to an organization's login and OrganizationTeamSlug is specified in the criteria with the '=' comparison operator. The driver processes ordering by other columns client-side within the driver.
- Name
- StargazerCount
- PushedAt
- CreatedAt
- Permission
SELECT * FROM [Information].[OrganizationTeamRepositories] WHERE [Information].[OrganizationTeamRepositories].[OrganizationLogin] = 'EXAMPLE' AND [Information].[OrganizationTeamRepositories].[OrganizationTeamSlug] = 'EXAMPLE_TEAM'
SELECT * FROM [Information].[OrganizationTeamRepositories] WHERE [Information].[OrganizationTeamRepositories].[OrganizationLogin] = 'EXAMPLE'
SELECT * FROM [Information].[OrganizationTeamRepositories] WHERE [Information].[OrganizationTeamRepositories].[OrganizationTeamSlug] = 'EXAMPLE_TEAM'
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The ID of the repository. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| Name | String | The name of the repository. | ||
| NameWithOwner | String | The repository's name with owner. | ||
| Visibility | String | Indicates the repository's visibility level. | ||
| DiskUsage | Int | The number of kilobytes this repository occupies on disk. | ||
| ForkCount | Int | Returns how many forks there are of this repository in the whole network. | ||
| StargazerCount | Int | Returns a count of how many stargazers there are on this object. | ||
| WatcherCount | Int | The number of watchers in a repository. | ||
| TopicCount | Int | The number of topics that have been applied to the repository. | ||
| TempCloneToken | String | Temporary authentication token for cloning this repository. | ||
| WebCommitSignoffRequired | Bool | Whether contributors are required to sign off on web-based commits in this repository. | ||
| UsesCustomOpenGraphImage | Bool | Whether this repository has a custom image to use with Open Graph as opposed to being represented by the owner's avatar. | ||
| Description | String | The description of the repository. | ||
| DescriptionHTML | String | The description of the repository rendered to HTML. | ||
| ShortDescriptionHTML | String | A description of the repository, rendered to HTML without any links in it. | ||
| ResourcePath | String | The HTTP path for this repository. | ||
| ProjectsResourcePath | String | The HTTP path listing the repository's projects. | ||
| Url | String | The HTTP URL for this repository. | ||
| HomepageUrl | String | The repository's URL. | ||
| MirrorUrl | String | The repository's original mirror URL. | ||
| ProjectsUrl | String | The HTTP URL listing the repository's projects. | ||
| SecurityPolicyUrl | String | The security policy URL. | ||
| SSHUrl | String | The SSH URL to clone this repository. | ||
| OpenGraphImageUrl | String | The image used to represent this repository in Open Graph data. | ||
| MergeCommitTitle | String | How the default commit title will be generated when merging a pull request. | ||
| MergeCommitMessage | String | How the default commit message will be generated when merging a pull request. | ||
| SquashMergeCommitTitle | String | How the default commit title will be generated when squash merging a pull request. | ||
| SquashMergeCommitMessage | String | How the default commit message will be generated when squash merging a pull request. | ||
| DeleteBranchOnMerge | Bool | Whether or not branches are automatically deleted when merged in this repository. | ||
| HasDiscussionsEnabled | Bool | Indicates if the repository has the Discussions feature enabled. | ||
| HasIssuesEnabled | Bool | Indicates if the repository has issues feature enabled. | ||
| HasProjectsEnabled | Bool | Indicates if the repository has the Projects feature enabled. | ||
| HasWikiEnabled | Bool | Indicates if the repository has wiki feature enabled. | ||
| HasVulnerabilityAlertsEnabled | Bool | Whether vulnerability alerts are enabled for the repository. | ||
| HasSponsorshipsEnabled | Bool | Indicates if the repository displays a Sponsor button for financial contributions. | ||
| IsInOrganization | Bool | Indicates if a repository is either owned by an organization, or is a private fork of an organization repository. | ||
| IsBlankIssuesEnabled | Bool | Returns true if blank issue creation is allowed. | ||
| IsSecurityPolicyEnabled | Bool | Returns true if this repository has a security policy. | ||
| IsUserConfigurationRepository | Bool | Is this repository a user configuration repository? | ||
| IsArchived | Bool | Indicates if the repository is unmaintained. | ||
| IsDisabled | Bool | Returns whether or not this repository disabled. | ||
| IsEmpty | Bool | Returns whether or not this repository is empty. | ||
| IsFork | Bool | Identifies if the repository is a fork. | ||
| IsLocked | Bool | Indicates if the repository has been locked or not. | ||
| IsMirror | Bool | Identifies if the repository is a mirror. | ||
| IsPrivate | Bool | Identifies if the repository is private. | ||
| IsTemplate | Bool | Identifies if the repository is a template that can be used to generate new repositories. | ||
| LockReason | String | The reason the repository has been locked. | ||
| TemplateRepositoryId | String | The ID of the repository from which this repository was generated, if any. | ||
| ParentId | String | The repository parent ID, if this is a fork. | ||
| ForkingAllowed | Bool | Whether this repository allows forks. | ||
| AutoMergeAllowed | Bool | Whether or not Auto-merge can be enabled on pull requests in this repository. | ||
| SquashMergeAllowed | Bool | Whether or not squash-merging is enabled on this repository. | ||
| RebaseMergeAllowed | Bool | Whether or not rebase-merging is enabled on this repository. | ||
| MergeCommitAllowed | Bool | Whether or not PRs are merged with a merge commit on this repository. | ||
| AllowUpdateBranch | Bool | Whether or not a pull request head branch that is behind its base branch can always be updated even if it is not required to be up to date before merging. | ||
| ViewerPermission | String | The users permission level on the repository. Will return null if authenticated as an GitHub App. | ||
| ViewerSubscription | String | Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. | ||
| ViewerHasStarred | Bool | Returns a boolean indicating whether the viewing user has starred this starrable. | ||
| ViewerDefaultCommitEmail | String | The last commit email for the viewer. | ||
| ViewerDefaultMergeMethod | String | The last used merge method by the viewer or the default for the repository. | ||
| ViewerPossibleCommitEmails | String | A list of emails this viewer can commit with. | ||
| ViewerCanAdminister | Bool | Indicates whether the viewer has admin permissions on this repository. | ||
| ViewerCanSubscribe | Bool | Check if the viewer is able to change their subscription status for the repository. | ||
| ViewerCanCreateProjects | Bool | Can the current viewer create new projects on this owner. | ||
| ViewerCanUpdateTopics | Bool | Indicates whether the viewer can update the topics of this repository. | ||
| CodeOfConductId | String | The ID of the Code of Conduct. | ||
| CodeOfConductName | String | The formal name of the Code of Conduct. | ||
| CodeOfConductBody | String | The body of the Code of Conduct. | ||
| CodeOfConductKey | String | The key for the Code of Conduct. | ||
| CodeOfConductUrl | String | The HTTP URL for this Code of Conduct. | ||
| CodeOfConductResourcePath | String | The HTTP path for this Code of Conduct. | ||
| DefaultBranchRefId | String | The ref id. | ||
| DefaultBranchRefName | String | The ref 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. | ||
| LatestReleaseId | String | The ID of the release. | ||
| LatestReleaseName | String | The title of the release. | ||
| LicenseId | String | The ID of the license associated with the repository. | ||
| LicenseKey | String |
Licenses.Key | The key of the license associated with the repository. | |
| LanguageId | String | The ID of the current primary language. | ||
| LanguageName | String | The name defined for the current language. | ||
| LanguageColor | String | The color defined for the current language. | ||
| PushedAt | Datetime | Identifies when the repository was last pushed to. | ||
| ArchivedAt | Datetime | Identifies the date and time when the repository was archived. | ||
| 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. | ||
| Permission | String | The permission level the team has on the repository. | ||
| OrganizationTeamSlug [KEY] | String |
OrganizationTeams.Slug | The slug corresponding to the team. | |
| OrganizationLogin [KEY] | String |
Organizations.Login | The organization's login name. |