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 driver will use the login name of the authenticated user.

Select

The driver uses the GitHub API to restrict results to the specified UserLogin and RepositoryName values.

The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

• UserLogin, RepositoryName, Number, and State support the following operator: =

For example, the following queries are executed server side:

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.