Lists information about the projects that the logged in user's organizations' teams or the teams of the specified organization have collaborator access to.

View-Specific Information

Select

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

• OrganizationLogin supports the '=' comparison operator.
• OrganizationTeamSlug supports the '=' comparison operator.
• Number supports the '=' comparison operator.
• MinPermissionLevel supports the '=' comparison operator.

The add-in uses the GitHub API to process ORDER BY clause conditions built with the following column when OrganizationLogin and OrganizationTeamSlug is specified in the criteria both with the '=' comparison operator, or when OwnerLogin is set to an organization's login and OrganizationTeamSlug is specified in the criteria with the '=' comparison operator. The add-in processes ordering by other columns client-side within the add-in.

• Number
• Title
• UpdatedAt
• CreatedAt

For example, the following queries are processed server side:

SELECT * FROM [Information].[OrganizationTeamProjects] WHERE [Information].[OrganizationTeamProjects].[OrganizationLogin] = 'EXAMPLE' AND [Information].[OrganizationTeamProjects].[OrganizationTeamSlug] = 'EXAMPLE_TEAM'

SELECT * FROM [Information].[OrganizationTeamProjects] WHERE [Information].[OrganizationTeamProjects].[OrganizationLogin] = 'EXAMPLE'

SELECT * FROM [Information].[OrganizationTeamProjects] WHERE [Information].[OrganizationTeamProjects].[OrganizationTeamSlug] = 'EXAMPLE_TEAM'

SELECT * FROM [Information].[OrganizationTeamProjects] WHERE [Information].[OrganizationTeamProjects].[Number] = '1'

SELECT * FROM [Information].[OrganizationTeamProjects] WHERE [Information].[OrganizationTeamProjects].[MinPermissionLevel] = 'ADMIN'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The project ID.
Number	Int			The project's number.
DatabaseId	Int			Identifies the primary key from the database.
Title	String			The project's name.
ShortDescription	String			The project's short description.
Readme	String			The project's readme.
Creator	String			The actor's login name who originally created the project.
Public	Bool			Returns true if the project is public.
Template	Bool			Returns true if this project is a template.
Closed	Bool			Returns true if the project is closed.
ViewerCanClose	Bool			Indicates if the object can be closed by the viewer.
ViewerCanReopen	Bool			Indicates if the object can be reopened by the viewer.
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ResourcePath	String			The HTTP path for this project
Url	String			The HTTP URL for this project
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ClosedAt	Datetime			Identifies the date and time when the object was closed.
CreatedAt	Datetime			Identifies the date and time when the object was created.
OrganizationTeamSlug [KEY]	String	OrganizationTeams.Slug		The slug corresponding to the team.
OrganizationLogin [KEY]	String	Organizations.Login		The organization's login name.
MinPermissionLevel	String			Filter projects based on user role.