FireDAC Components for Azure DevOps

Build 21.0.7930

TeamIterations

Retrieve a team's iteration.

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

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

Columns

Name Type References Description
Id [KEY] String Id of the iteration.
ProjectId String

Projects.Id

Id of the project.
TeamId String

Teams.Id

Id of the team.
AttributesFinishDate Datetime Finish date of the iteration.
AttributesStartDate Datetime Start date of the iteration.
AttributesTimeFrame String Time frame of the iteration, such as past, current or future.
LinksCapacityHref String Capacity reference link.
LinksClassificationNodeHref String Classification node reference link.
LinksProjectHref String Project reference link.
LinksSelfHref String Self reference link.
LinksTeamHref String Team reference link.
LinksTeamDaysOffHref String Team days off reference link.
LinksTeamIterationsHref String Team iterations reference link.
LinksTeamSettingsHref String Team settings reference link.
LinksWorkItemsHref String Work items reference links.
Name String Name of the iteration.
Path String Relative path of the iteration.
Url String Full http link to the resource.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930