OrganizationTeamProjects
Lists projects accessible to specific teams within a GitHub organization, including details on collaboration and access rights.
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:
- Number supports the '=,IN' comparison operators.
- OrganizationTeamSlug supports the '=,IN' comparison operators.
- OrganizationLogin supports the '=,IN' comparison operators.
- MinPermissionLevel supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [OrganizationTeamProjects]
SELECT * FROM [OrganizationTeamProjects] WHERE [Number] = 123
SELECT * FROM [OrganizationTeamProjects] WHERE [OrganizationTeamSlug] = 'Val1'
SELECT * FROM [OrganizationTeamProjects] WHERE [OrganizationLogin] = 'Val1'
SELECT * FROM [OrganizationTeamProjects] 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 [OrganizationTeamProjects] ORDER BY [Number]
SELECT * FROM [OrganizationTeamProjects] ORDER BY [Title]
SELECT * FROM [OrganizationTeamProjects] ORDER BY [UpdatedAt]
SELECT * FROM [OrganizationTeamProjects] 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. | ||
| Number | Int | The project’s unique number within the organization or team. | ||
| 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. | ||
| 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 about it. | ||
| 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 this project serves as a template for creating new projects. | ||
| Closed | Bool | Indicates whether the project is currently closed. | ||
| 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. | ||
| OrganizationTeamSlug [KEY] | String |
OrganizationTeams.Slug | The unique slug (URL-friendly identifier) corresponding to the team associated with the project. | |
| OrganizationLogin [KEY] | String |
Organizations.Login | The login (username) of the organization associated with the project. | |
| MinPermissionLevel | String | Filters projects based on the user’s minimum permission level (for example, 'read', 'write', 'admin').
The allowed values are READ, WRITE, ADMIN. | ||
| DatabaseId | Int | (Deprecated) The primary key identifier for the project in the database. |