Milestones
Details milestones in a repository, including their goals, deadlines, and associated issues or pull requests for project tracking.
View-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- Number supports the '=,IN' comparison operators.
- State supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [Milestones]
SELECT * FROM [Milestones] WHERE [Number] = 123
SELECT * FROM [Milestones] WHERE [State] = 'OPEN'
The 本製品 processes other filters client-side within the 本製品.
The 本製品 uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:
- Number
- DueOn
- UpdatedAt
- CreatedAt
SELECT * FROM [Milestones] ORDER BY [Number]
SELECT * FROM [Milestones] ORDER BY [DueOn]
SELECT * FROM [Milestones] ORDER BY [UpdatedAt]
SELECT * FROM [Milestones] ORDER BY [CreatedAt]
The 本製品 uses client-side processing when ordering by any other columns. This impacts performance.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | Represents a unique identifier for the milestone, ensuring it can be distinctly referenced or tracked within the project or repository. | ||
| Title | String | Specifies the title of the milestone, which typically summarizes its goal or intended outcome, such as 'Version 2.0 Release' or 'Bug Fixes'. This helps users quickly understand the focus of the milestone. | ||
| Closed | Bool | Indicates whether the milestone has been closed. The criteria for closure might differ depending on the specific project or repository, but a 'true' value signifies that the milestone is no longer active. | ||
| ProgressPercentage | Double | Represents the current completion progress of the milestone, shown as a percentage from 0 to 100. This value is typically calculated based on completed issues or tasks associated with the milestone. | ||
| Description | String | Provides a detailed description outlining the objectives, scope, or tasks related to the milestone. This offers further context for what needs to be achieved to consider the milestone complete. | ||
| Number | Int | A unique sequential number assigned to the milestone within the repository. This number helps identify milestones in the order they were created. | ||
| State | String | Describes the current status of the milestone. Common values include 'OPEN' (active and ongoing) or 'CLOSED' (completed and no longer active).
使用できる値は次のとおりです。OPEN, CLOSED | ||
| ResourcePath | String | Specifies the relative HTTP path used to access this milestone via the GitHub API. This is useful for API interactions and retrieving milestone data programmatically. | ||
| Url | String | Provides the full HTTP URL to directly access this milestone. This URL can be used to view the milestone details in a web browser or interact with the milestone via the API. | ||
| ViewerCanClose | Bool | Indicates whether the current user has the necessary permissions to close the milestone. A value of 'true' means the user can mark the milestone as closed. | ||
| ViewerCanReopen | Bool | Indicates whether the current user has the necessary permissions to reopen the milestone if it was previously closed. A value of 'true' means the user can reinitiate the milestone if needed. | ||
| DueOn | Datetime | Specifies the scheduled date and time by which the milestone is expected to be completed. This serves as a deadline for the milestone, helping teams manage expectations. | ||
| ClosedAt | Datetime | Represents the date and time when the milestone was officially closed. This timestamp is recorded once all tasks or objectives for the milestone are completed. | ||
| UpdatedAt | Datetime | Represents the date and time when the milestone was last modified. This helps track when changes, such as adjustments to scope or due dates, were made. | ||
| CreatedAt | Datetime | Specifies the date and time when the milestone was initially created, providing context for how long the milestone has been in progress. |