ADO.NET Provider for Azure DevOps

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060