SSIS Components for Azure DevOps

Build 24.0.9063

TfvcBranches

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

Table Specific Information

Select

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'

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.

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