Lists information about milestones in a repository.

View-Specific Information

Select

The connector uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The connector processes other filters client-side within the connector.

• Number supports the '=' comparison operator.
• State supports the '=' comparison operator.

The connector uses the GitHub API to process ORDER BY clause conditions built with the following column. The connector processes ordering by other columns client-side within the connector.

• Number
• DueOn
• UpdatedAt
• CreatedAt

For example, the following queries are processed server side:

SELECT * FROM [Repository].[Milestones] WHERE [Repository].[Milestones].[Number] = '100'

SELECT * FROM [Repository].[Milestones] WHERE [Repository].[Milestones].[State] = 'all'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the milestone.
Title	String			Identifies the title of the milestone.
Closed	Bool			True if the object is closed (definition of closed may depend on type).
ProgressPercentage	Double			Progress Percentage for this milestone.
Description	String			Identifies the description of the milestone.
Number	Int			Identifies the number of the milestone.
State	String			Identifies the state of the milestone.
ResourcePath	String			The HTTP path for this milestone.
Url	String			The HTTP URL for this milestone.
ViewerCanClose	Bool			Indicates if the object can be closed by the viewer.
ViewerCanReopen	Bool			Indicates if the object can be reopened by the viewer.
DueOn	Datetime			Identifies the due date of the milestone.
ClosedAt	Datetime			Identifies the date and time when the object was closed.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
CreatedAt	Datetime			Identifies the date and time when the object was created.