Lists information about projects.

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 processed server side:

SELECT * FROM Projects WHERE UserLogin = 'MyUserLogin' AND RepositoryName = 'MyRepo'

SELECT * FROM Projects WHERE Number=2

SELECT * FROM Projects WHERE State = 'all'

Columns

Name	Type	OrderBySupport	Description
Id [KEY]	String		The project ID.
UserLogin	String		The login name of the user.
RepositoryName	String		The name of the repository.
Body	String		The project's description body.
BodyHTML	String		The projects description body rendered to HTML.
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.
Creator	String		The actor's login name who originally created the project.
Name	String	True	The project's name.
Number	Integer		The project's number.
ResourcePath	String		The HTTP path for this project.
State	String		Whether the project is open or closed. The allowed values are OPEN, CLOSED.
UpdatedAt	Datetime	True	Identifies the date and time when the object was last updated.
Url	String		The HTTP URL for this project.
ViewerCanUpdate	Boolean		Check if the current viewer can update this object.