ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieve a team's iteration.

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.
  • TeamId supports the '=' operator.
  • AttributesTimeFrame supports the '=' operator.

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

For example:

	SELECT * FROM TeamIterations WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM TeamIterations WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = '2bc932aa-21bd-4d2f-860d-43c843b46431'
	SELECT * FROM TeamIterations WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND AttributesTimeFrame = 'current'


The following are examples of inserting into TeamIterations table:

INSERT INTO TeamIterations (ProjectId,TeamId,Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937','619e870e-5242-4218-bedd-c52d8c003591','hello@122')
This example shows how to add a separate Iterations table:
INSERT INTO TeamIterations (ProjectId, TeamId, Id) VALUES ('c831d3b4-a289-462f', '7f1d8582-a070-4d2b', 'afaad11d-8025-4c31')


The following is an example of updating a TeamIterations table:

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


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

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


Name Type ReadOnly References Description
Id [KEY] String True

Id of the iteration.

ProjectId String True


Id of the project.

TeamId String True


Id of the team.

AttributesFinishDate Datetime False

Finish date of the iteration.

AttributesStartDate Datetime False

Start date of the iteration.

AttributesTimeFrame String False

Time frame of the iteration, such as past, current or future.

LinksCapacityHref String True

Capacity reference link.

LinksClassificationNodeHref String True

Classification node reference link.

LinksProjectHref String True

Project reference link.

LinksSelfHref String True

Self reference link.

LinksTeamHref String True

Team reference link.

LinksTeamDaysOffHref String True

Team days off reference link.

LinksTeamIterationsHref String True

Team iterations reference link.

LinksTeamSettingsHref String True

Team settings reference link.

LinksWorkItemsHref String True

Work items reference links.

Name String False

Name of the iteration.

Path String False

Relative path of the iteration.

Url String False

Full http link to the resource.

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