TeamIterations
Retrieve a team's iteration.
Table Specific Information
Select
The provider 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 provider.
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. |