TeamSettings
Retrieves settings for a team.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- TeamId supports the '=' operator.
The rest of the filter is executed client-side in the provider.
For example:
SELECT * FROM TeamSettings WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' SELECT * FROM TeamSettings WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40'
Update
The following is an example of updating a TeamSettings table:
UPDATE TeamSettings SET DefaultIterationName = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND TeamId = '619e870e-5242-4218-bedd-c52d8c003591'
Columns
Name | Type | ReadOnly | References | Description |
ProjectId | String | False |
Id of the project. | |
TeamId | String | False |
Teams.Id |
Id of the team. |
BacklogIterationId | String | False |
Id of the backlog iteration. | |
BacklogIterationName | String | False |
Name of the backlog iteration. | |
BacklogIterationPath | String | False |
Relative path of the backlog iteration. | |
BacklogIterationUrl | String | False |
Full http link of the backlog iteration. | |
BacklogIterationAttributesFinishDate | String | False |
Finish date of the iteration. | |
BacklogIterationAttributesStartDate | String | False |
Start date of the iteration. | |
BacklogIterationAttributesTimeFrame | String | False |
Time frame of the iteration, such as past, current or future. | |
IsFeatureCategoryVisible | Boolean | False |
Indicates if the Feature category is visible on this team's backlog | |
IsEpicCategoryVisible | Boolean | False |
Indicates if the Epic category is visible on this team's backlog | |
IsRequirementCategoryVisible | Boolean | False |
Indicates if the Requirement category is visible on this team's backlog | |
BugsBehavior | String | False |
Bug Behavior. | |
DefaultIterationId | String | False |
Id of the default iteration. | |
DefaultIterationName | String | False |
Name of the default iteration. | |
DefaultIterationPath | String | False |
Relative path of the default iteration. | |
DefaultIterationUrl | String | False |
Full http link of the default iteration. | |
DefaultIterationAttributesFinishDate | String | False |
Finish date of the iteration. | |
DefaultIterationAttributesStartDate | String | False |
Start date of the iteration. | |
DefaultIterationAttributesTimeFrame | String | False |
Time frame of the iteration, such as past, current or future. | |
DefaultIterationMacro | String | False |
Default iteration macro. | |
Links | String | True |
Aggregate of the reference links. | |
Url | String | True |
Full http link to the resource. | |
WorkingDays | String | False |
Days that the team is working. |