Lists information about the projects of the logged in user, a specific user or a specific organization.

View-Specific Information

Select

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

• OwnerLogin supports the '=' comparison operator.
• Number supports the '=' comparison operator.
• MinPermissionLevel supports the '=' comparison operator.

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

• Number
• Title
• UpdatedAt
• CreatedAt

For example, the following queries are processed server side:

SELECT * FROM [Information].[Projects] WHERE [Information].[Projects].[OwnerLogin] = 'EXAMPLE'

SELECT * FROM [Information].[Projects] WHERE [Information].[Projects].[Number] = '100'

SELECT * FROM [Information].[Projects] WHERE [Information].[Projects].[MinPermissionLevel] = 'ADMIN'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The project ID.
OwnerLogin	String			The login of the owner of the project.
Number	Int			The project's number.
DatabaseId	Int			Identifies the primary key from the database.
Title	String			The project's name.
ShortDescription	String			The project's short description.
Readme	String			The project's readme.
Creator	String			The actor's login name who originally created the project.
Public	Bool			Returns true if the project is public.
Template	Bool			Returns true if this project is a template.
Closed	Bool			Returns true if the project is closed.
ViewerCanClose	Bool			Indicates if the object can be closed by the viewer.
ViewerCanReopen	Bool			Indicates if the object can be reopened by the viewer.
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ResourcePath	String			The HTTP path for this project
Url	String			The HTTP URL for this project
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ClosedAt	Datetime			Identifies the date and time when the object was closed.
CreatedAt	Datetime			Identifies the date and time when the object was created.
MinPermissionLevel	String			Filter projects based on user role.