TeamSettings

Retrieves settings for a team..

Table Specific Information

Select

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

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	Projects.Id	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.
LinksClassificationNode	String	True		Classification node reference link.
LinksProjectHref	String	True		Project reference link.
LinksSelfHref	String	True		Self reference link.
LinksTeamHref	String	True		Team reference link.
LinksTeamFieldValuesHref	String	True		Team field values reference link.
LinksTeamIterationsHref	String	True		Team iterations reference link.
Url	String	True		Full http link to the resource.
WorkingDays	String	False		Days that the team is working.

JDBC Driver for Azure DevOps

TeamSettings

Table Specific Information

Select

Update

Columns