Projects
Lists information about the projects of the logged in user, a specific user or a specific organization.
View-Specific Information
Select
The cmdlet uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The cmdlet processes other filters client-side within the cmdlet.
- OwnerLogin supports the '=' comparison operator.
- Number supports the '=' comparison operator.
- MinPermissionLevel supports the '=' comparison operator.
The cmdlet uses the GitHub API to process ORDER BY clause conditions built with the following column. The cmdlet processes ordering by other columns client-side within the cmdlet.
- Number
- Title
- UpdatedAt
- CreatedAt
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. |