Retrieve a team's iteration.

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

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

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'

Insert

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')

Update

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'

Delete

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'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Id of the iteration.
ProjectId	String	True	Projects.Id	Id of the project.
TeamId	String	True	Teams.Id	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.