Retrieve a team's iteration.

Table Specific Information

Select

The connector 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 connector.

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	False		Id of the iteration.
ProjectId	String	False		Id of the project.
TeamId	String	False	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.
Links	String	True		Aggregate of the 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.