ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a collection of branch roots -- first-level children, branches with no parents.

Table Specific Information


The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side in the 本製品.

  • Path supports the '=' operator.
  • ProjectId supports the '=' operator.
  • IncludeParent supports the '=' operator.
  • IncludeChildren supports the '=' operator.
  • IncludeDeleted supports the '=' operator.
  • IncludeLinks supports the '=' operator.
For example:
	SELECT * FROM TfvcBranches WHERE Path = '$/example/example-repo'


Name Type References Description
Path String Path for the branch.
ProjectId String


Id of the project this branch belongs to.
Children String List of children for the branch.
CreatedDate Datetime Creation date of the branch.
Description String Description of the branch.
IsDeleted Boolean Indicates whether the branch is deleted or not.
Links String A collection of REST reference links.
Mappings String List of branch mappings.
OwnerDisplayName String The non-unique display name of the owner.
OwnerId String The Id of the owner.
OwnerImageUrl String The Image URL of the owner.
OwnerUniqueName String The Unique name of the owner.
OwnerUrl String The Full Http url of the owner.
ParentPath String Path of the branch's parent.
RelatedBranches String List of paths of the related branches.
Url String URL to retrieve the branch.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IncludeParent Boolean Return the parent branch, if there is one.
IncludeChildren Boolean Return the child branches for each root branch.
IncludeDeleted Boolean Return deleted branches.
IncludeLinks Boolean Return links.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479