Lists information about the teams of the logged in user's organizations or the teams of the specified organization.

View-Specific Information

Select

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

• 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 本製品 uses the GitHub API to process ORDER BY clause conditions built with the following column. The 本製品 processes ordering by other columns client-side within the 本製品.

• Name

For example, the following queries are processed server side:

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	Organizations.Id		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.