RepositoryReleases
Lists information about releases in repositories.
View-Specific Information
Select
The driver uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- TagName supports the '=' comparison operator.
- RepositoryName supports the '=' comparison operator.
- OwnerLogin supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [RepositoryReleases]
SELECT * FROM [RepositoryReleases] WHERE [TagName] = 'Val1'
SELECT * FROM [RepositoryReleases] WHERE [RepositoryName] = 'Val1'
SELECT * FROM [RepositoryReleases] WHERE [OwnerLogin] = '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
- CreatedAt
ORDER BY is processed server-side only when the query is scoped to a single parent, as shown below. Otherwise the driver processes the ordering client-side.
SELECT * FROM [RepositoryReleases] WHERE [RepositoryName] = 'Val1' AND [OwnerLogin] = 'Val1' ORDER BY [Name]
SELECT * FROM [RepositoryReleases] WHERE [RepositoryName] = 'Val1' AND [OwnerLogin] = 'Val1' ORDER BY [CreatedAt]
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 ID of the release. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| Name | String | The title of the release. | ||
| Description | String | The description of the release. | ||
| ShortDescriptionHTML | String | A description of the release, rendered to HTML without any links in it. Arguments limit (Int) How many characters to return. The default value is 200. | ||
| DescriptionHTML | String | The description of this release rendered to HTML. | ||
| Immutable | Bool | Whether or not the release is immutable. | ||
| IsDraft | Bool | Whether or not the release is a draft. | ||
| IsLatest | Bool | Whether or not the release is the latest release. | ||
| IsPrerelease | Bool | Whether or not the release is a prerelease. | ||
| ViewerCanReact | Bool | Can user react to this subject? | ||
| AuthorId | String | The author's ID of the release. | ||
| Author | String | The author's login name of the release. | ||
| AuthorType | String | The type of the actor who authored the release. | ||
| TagId | String | The ID of the release's Git tag. | ||
| TagName | String | The name of the release's Git tag. | ||
| TagCommitId | String | The ID of the release's Git tag commit. | ||
| TagCommitOid | String | The SHA of the release's Git tag commit. | ||
| Url | String | The HTTP URL for this release. | ||
| ResourcePath | String | The HTTP path for this release. | ||
| CreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| PublishedAt | Datetime | Identifies the date and time when the release was created. | ||
| UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| RepositoryId | String | The ID of the repository. | ||
| RepositoryName | String | The name of the repository. | ||
| OwnerLogin | String | The login field of a user or organization. |