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 '=' comparison operator.

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 ASC (when OrganizationLogin is specified in the criteria with the '=' comparison operator or when OwnerLogin is set to an organization's login)

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.
ParentTeamId	String			The ID of the parent team of the team.
ParentTeamName	String			The name of the parent team of the team.
Name	String			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
AvatarUrl	String			A URL pointing to the team's avatar.
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.
ReviewRequestDelegationAlgorithm	String			What algorithm is used for review assignment for this team.
ReviewRequestDelegationEnabled	Bool			True if review assignment is enabled for this team.
ReviewRequestDelegationMemberCount	Int			How many team members are required for review assignment for this team.
ReviewRequestDelegationNotifyTeam	Bool			When assigning team members via delegation, whether the entire team should be notified as well.
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	OrganizationMembers.Login		User logins to filter by.