TfvcBranches
Retrieves a collection of branch roots -- first-level children, branches with no parents.
Table Specific Information
Select
The connector 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 connector.
- 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
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. |