JDBC Driver for GitHub

Build 22.0.8462

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 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462