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

Table Specific Information

Select

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

• Id supports the '=' operator.

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

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 ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'TestTeam')

Update

The following is an example of updating the Teams table:

UPDATE Teams SET Name='cdata2' WHERE ProjectId='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id='619e870e-5242-4218-bedd-c52d8c003591'

Delete

Due to the fact that there is no way to distinguish between the API response for a successful and a failed DELETE for this table, the affected row count is always -1.

The following is an example of deleting from the Teams table:

DELETE FROM Teams WHERE ProjectId='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id ='619e870e-5242-4218-bedd-c52d8c003591'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique Identifier of the team.
Description	String	False		The description of the team.
IdentityCustomDisplayName	String	True		The custom display name fro the identity.
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		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. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.

Name	Type	Description
ExpandIdentity	Boolean	A value indicating whether or not to expand Identity information in the result WebApiTeam object.
Mine	Boolean	Return all teams requesting user is member. Otherwise return all teams user has read access.