GitBranches

Retrieves a collection of git branch, sliced across all repositories.

Table Specific Information

Select

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

ProjectId supports the '=' operator.
RepositoryId supports the '=' operator.
IncludeLinks supports the '=' operator.
MyBranches supports the '=' operator.
IncludeStatuses supports the '=' operator.
LatestStatusesOnly supports the '=' operator.

The rest of the filter is executed client-side in the connector.

NOTE: RepositoryId is required in order to query GitBranches.

For example:

	SELECT * FROM GitBranches WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051'
	SELECT * FROM GitBranches WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND IncludeLinks = true

Update

The following is an example of updating a GitBranches table:

UPDATE GitBranches SET isLocked = true WHERE name = 'abc' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND RepositoryId = 'e50698d4-bb6e-400f-a1a0-5f4d17517d9e'

Columns


Name	Type	ReadOnly	References	Description
ObjectId [KEY]	String	True		Path for the branch.
ProjectId	String	False		Id of the project this branch belongs to.
RepositoryId	String	False	Repositories.Id	Id of the repositories.
Name	String	False		Name of the branch.
CreatorDisplayName	String	True		The non-unique display name of the user who created this branch.
CreatorUrl	String	True		The URL of the user who created this branch.
CreatorLinksAvatarHref	String	True		Avatar reference link of the creator.
CreatorId	String	True		Id of the creator.
CreatorDescriptor	String	True		Descriptor of the creator.
Links	String	True		Aggregate of the reference links.
Statuses	String	True		Contains the metadata of a service/extension posting a status.
Url	String	True		Full HTTP resource link of the branch.
isLocked	Boolean	False		Represents a boolean value if the branch is locked or not.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。