ODBC Driver for Azure DevOps

Build 22.0.8479


List Teams

Table Specific Information


The 本製品 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.
  • ExpandIdentity supports the '=' operator.
  • Mine supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM Teams WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Id='717f1ce9-ee4f-4009-9622-4d22f46e5af2'
	SELECT * FROM Teams WHERE ExpandIdentity = true


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

INSERT INTO Teams (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'Shubham')


The following is an example of updating a Teams table:

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


The following is an example of deleting data in a Teams table:

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


Name Type References Description
ParentReference String
TeamSK [KEY] String
ProjectSK String
TeamId String
TeamName String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479