TeamSettings
Retrieves settings for a team.
Table Specific Information
Select
The connector 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 connector.
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. |