Projects
Holds metadata and organization-related details for GitHub projects, enabling structured project tracking.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- OwnerLogin supports the '=,IN' comparison operators.
- Number supports the '=,IN' comparison operators.
- MinPermissionLevel supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [Projects]
SELECT * FROM [Projects] WHERE [OwnerLogin] = 'Val1'
SELECT * FROM [Projects] WHERE [Number] = 123
SELECT * FROM [Projects] WHERE [MinPermissionLevel] = 'READ'
The add-in processes other filters client-side within the add-in.
The add-in uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:
- Number
- Title
- UpdatedAt
- CreatedAt
SELECT * FROM [Projects] ORDER BY [Number]
SELECT * FROM [Projects] ORDER BY [Title]
SELECT * FROM [Projects] ORDER BY [UpdatedAt]
SELECT * FROM [Projects] ORDER BY [CreatedAt]
The add-in uses client-side processing when ordering by any other columns. This impacts performance.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier (node ID) of the project. | ||
| OwnerLogin | String | The login (username) of the owner of the project, which could be a user or an organization. | ||
| Number | Int | The unique number assigned to the project within its scope (for example, repository, organization). | ||
| FullDatabaseId | Long | The primary key identifier for the project in the database, represented as a BigInt. | ||
| Title | String | The name or title of the project, as set by its creator. | ||
| ShortDescription | String | A brief description of the project, summarizing its purpose or goals. | ||
| Readme | String | The README content associated with the project, providing detailed information or instructions. | ||
| Creator | String | The login (username) of the user who originally created the project. | ||
| Public | Bool | Indicates whether the project is public and accessible to everyone. | ||
| Template | Bool | Indicates whether the project is a template that can be used to create new projects. | ||
| Closed | Bool | Indicates whether the project is currently closed and no longer active. | ||
| ViewerCanClose | Bool | Indicates whether the current viewer has permission to close the project. | ||
| ViewerCanReopen | Bool | Indicates whether the current viewer has permission to reopen the project. | ||
| ViewerCanUpdate | Bool | Indicates whether the current viewer has permission to update the project. | ||
| ResourcePath | String | The relative HTTP path to access the project on GitHub. | ||
| Url | String | The absolute HTTP URL to access the project on GitHub. | ||
| UpdatedAt | Datetime | The date and time when the project was last updated, in ISO 8601 format. | ||
| ClosedAt | Datetime | The date and time when the project was closed, in ISO 8601 format. | ||
| CreatedAt | Datetime | The date and time when the project was created, in ISO 8601 format. | ||
| MinPermissionLevel | String | Filters projects based on the user’s minimum permission level (for example, 'read', 'write', 'admin').
The allowed values are READ, WRITE, ADMIN. |