Retrieves a collection of branch roots -- first-level children, branches with no parents.
Table Specific Information
The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
- Path supports the '=' operator.
- ProjectId supports the '=' operator.
- IncludeParent supports the '=' operator.
- IncludeChildren supports the '=' operator.
- IncludeDeleted supports the '=' operator.
- IncludeLinks supports the '=' operator.
SELECT * FROM TfvcBranches WHERE Path = '$/example/example-repo'
|Path||String||Path for the branch.|
|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.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|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.|