Teams

Retrieves a list of all teams and details of specified team.

Table Specific Information

Select

The driver uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

Id supports the '=' operator.
ProjectId supports the '=' operator.

The rest of the filter is executed client-side in the driver.

For example:

	SELECT * FROM Teams WHERE ProjectId = '837ccd31-8159-4db3' AND Id = '7f1d8582-a070-4d2b'

Insert

The following is an example of inserting into the Teams table:

INSERT INTO Teams (ProjectId, Name) VALUES ('837ccd31-8159-4db3', 'TestTeam')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique Identifier of the team.
Description	String	True		The description of the team.
IdentityId	String	True		Id of the identity.
IdentityIsActive	Boolean	True		Indicates whether the identity is active.
IdentityIsContainer	Boolean	True		Indicates whether the identity is a container.
IdentityMasterId	String	True		Master Id.
IdentityMetaTypeId	Integer	True		Meta Type Id.
IdentityProviderDisplayName	String	True		The display name for the identity as specified by the source identity provider.
IdentityResourceVersion	Integer	True		Resource version.
IdentitySubjectDescriptor	String	True		Subject descriptor.
IdentityUrl	String	True		Identity REST API URL to this team.
Name	String	False		The name of the team.
ProjectId	String	True	Projects.Id	The Unique Identifier of the project this team belongs to.
ProjectName	String	True		The name of the project this team belongs to.
Url	String	True		Team REST API URL.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.