OrganizationTeams
Lists information about the teams of the logged in user's organizations or the teams of the specified organization.
View-Specific Information
Select
The provider uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The provider processes other filters client-side within the provider.
- OrganizationLogin supports the '=' comparison operator.
- Privacy supports the '=' comparison operator.
- Slug supports the '=' comparison operator.
- NotificationSetting supports the '=' comparison operator.
- LdapMapped supports the '=' comparison operator.
- Role supports the '=' comparison operator.
- RootTeamsOnly supports the '=' comparison operator.
- UserLogins supports the '=, IN' comparison operators.
The provider uses the GitHub API to process ORDER BY clause conditions built with the following column. The provider processes ordering by other columns client-side within the provider.
- Name
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[OrganizationLogin] = 'EXAMPLE'
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[Privacy] = 'EXAMPLE'
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[Slug] = 'EXAMPLE'
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[NotificationSetting] = 'EXAMPLE'
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[LdapMapped] = 'true'
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[Role] = 'EXAMPLE'
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[RootTeamsOnly] = 'true'
SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[UserLogins] = 'EXAMPLE'
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The ID of the team. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| OrganizationId | String | The ID of the organization. | ||
| OrganizationLogin | String |
Organizations.Login | The organization's login name. | |
| Name | String | True | The name of the team. | |
| Description | String | The description of the team. | ||
| Privacy | String | The level of privacy the team has. | ||
| Slug | String | The slug corresponding to the team. | ||
| Url | String | The HTTP URL for this team. | ||
| CombinedSlug | String | The slug corresponding to the organization and team. | ||
| DiscussionsUrl | String | The HTTP URL for team discussions. | ||
| MembersUrl | String | The HTTP URL for the team' members. | ||
| NotificationSetting | String | The notification setting that the team has set. | ||
| RepositoriesUrl | String | The HTTP URL for this team's repositories. | ||
| ResourcePath | String | The HTTP path for this team. | ||
| TeamsUrl | String | The HTTP URL for this team's teams. | ||
| ViewerSubscription | String | Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. | ||
| DiscussionsResourcePath | String | The HTTP path for team discussions. | ||
| EditTeamUrl | String | The HTTP URL for editing this team. | ||
| MembersResourcePath | String | The HTTP path for the team' members. | ||
| NewTeamUrl | String | The HTTP URL creating a new team. | ||
| RepositoriesResourcePath | String | The HTTP path for this team's repositories. | ||
| TeamsResourcePath | String | The HTTP path for this team's teams. | ||
| ViewerCanAdminister | Bool | Team is adminable by the viewer. | ||
| ViewerCanSubscribe | Bool | Check if the viewer is able to change their subscription status for the repository. | ||
| EditTeamResourcePath | String | The HTTP path for editing this team. | ||
| NewTeamResourcePath | String | The HTTP path creating a new team. | ||
| CreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| LdapMapped | Bool | If true, filters teams that are mapped to an LDAP Group (Enterprise only). | ||
| Role | String | If non-null, filters teams according to whether the viewer is an admin or member on team. | ||
| RootTeamsOnly | Bool | If true, restrict to only root teams. | ||
| UserLogins | String | User logins to filter by. |