TfvcBranches
Retrieves a collection of branch roots -- first-level children, branches with no parents.
Table Specific Information
Select
The provider 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 provider.
- 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'
Columns
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. | |
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-Columns
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. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
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. |