Repositories
Lists information about a user's or organization's repositories.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The 本製品 processes other filters client-side within the 本製品.
- Name supports the '=, !=' comparison operators.
- OwnerLogin supports the '=' comparison operator.
- DiskUsage supports the '=, >, >=, <, <=' comparison operators.
- ForkCount supports the '=, >, >=, <, <=' comparison operators.
- StargazerCount supports the '=, >, >=, <, <=' comparison operators.
- TopicCount supports the '=, >, >=, <, <=' comparison operators.
- IsArchived supports the '=' comparison operator.
- IsFork supports the '=' comparison operator.
- IsMirror supports the '=' comparison operator.
- IsPrivate supports the '=' comparison operator.
- LicenseKey supports the '=, !=' comparison operators.
- LanguageName supports the '=, !=' comparison operators.
- PushedAt supports the '=, >, >=, <, <=' comparison operators.
- CreatedAt supports the '=, >, >=, <, <=' comparison operators.
The 本製品 uses the GitHub API to process ORDER BY clause conditions built with the following column. The 本製品 processes ordering by other columns client-side within the 本製品.
- UpdatedAt
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[Name] = 'EXAMPLE'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[OwnerLogin] = 'EXAMPLE'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[DiskUsage] = '100'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[ForkCount] = '100'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[StargazerCount] = '100'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[TopicCount] = '100'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsArchived] = 'true'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsFork] = 'true'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsMirror] = 'true'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsPrivate] = 'true'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[LicenseKey] = 'EXAMPLE'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[LanguageName] = 'EXAMPLE'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[PushedAt] = '2000-01-01 01:00:00.0'
SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[CreatedAt] = '2000-01-01 01:00:00.0'
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. | ||
| OwnerId | String | The repository's owner ID. | ||
| OwnerLogin | String | The login field of a user or organization. | ||
| 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 | True | Identifies the date and time when the object was last updated. |