Milestones
Lists information about milestones in a repository.
View-Specific Information
You must specify the UserLogin when executing a SELECT query against this view. You can specify the values in the WHERE clause or as connection properties. A value specified in the WHERE clause takes precedence over the connection property.
If you do not specify a UserLogin value, the adapter will use the login name of the authenticated user.
Select
The adapter uses the GitHub Data API API to restrict results to the specified UserLogin and RepositoryName values.
The adapter processes other filters client-side within the adapter.
- UserLogin, RepositoryName, Number, and State support the following operator: =
SELECT * FROM Milestones WHERE UserLogin = 'MyUser' AND RepositoryName = 'MyRepo' SELECT * FROM Milestones WHERE State = 'all' SELECT * FROM Milestones WHERE Number = 1
Columns
Name | Type | OrderBySupport | Description |
Id [KEY] | String | The ID of the milestone. | |
UserLogin | String | The login name of the user. | |
RepositoryName | String | The name of the repository. | |
Closed | Boolean | True if the object is closed (definition of closed may depend on type) | |
ClosedAt | Datetime | Identifies the date and time when the object was closed. | |
CreatedAt | Datetime | True | Identifies the date and time when the object was created. |
Description | String | Identifies the description of the milestone. | |
DueOn | Datetime | True | Identifies the due date of the milestone. |
Number | Integer | True | Identifies the number of the milestone. |
ResourcePath | String | The HTTP path for this milestone. | |
State | String | Identifies the state of the milestone.
The allowed values are OPEN, CLOSED. | |
Title | String | Identifies the title of the milestone. | |
UpdatedAt | Datetime | True | Identifies the date and time when the object was last updated. |
Url | String | The HTTP URL for this milestone. | |
ProgressPercentage | Float | Progress Percentage for this milestone. |