Branches

Open branches in a repository.

Table Specific Information

Select

The add-in uses the Bitbucket API to process WHERE clause conditions built with the below columns. Filtering on other columns is processed client-side within the add-in.

Name
TargetCommitHash
TargetCommitMessage

The add-in uses the Bitbucket API to process ORDER BY clause conditions built with the below columns. Sorting on other columns is processed client-side within the add-in.

Name
TargetCommitHash
TargetCommitMessage

For example, the following query is processed server side:

SELECT * FROM Branches WHERE Name='mybranch'

Insert

To create a new branch, you must specify the Name and TargetCommitHash fields.

The branch name should not include any prefixes (e.g. refs/heads).

When setting the TargetCommitHash, you should specify the full commit hash.

A sample INSERT is included below:

INSERT INTO Branches (Name, TargetCommitHash) VALUES ('mybranch', 'a391205bc3fed4247g18f7abc788593b4e212562')

Update

UPDATEs are not supported for this table.

Delete

The main branch may not be deleted.

When specified, the branch name should not include any prefixes (e.g. refs/heads).

A sample DELETE is included below:

DELETE FROM Branches where Name='Beth/test-branch-1712689263123'

Columns


Name	Type	ReadOnly	References	Description
Name [KEY]	String	False		Name of the ref.
DefaultMergeStrategy	String	True		The default merge strategy for pull requests targeting this branch.
MergeStrategies	String	True		Available merge strategies for pull requests targeting this branch.
TargetCommitHash	String	False		Hash of the branch's target commit.
TargetCommitMessage	String	True		Message of the branch's target commit.
TargetRepositoryUUID	String	True		UUID of the repository that the branch targets.
TargetRepositoryName	String	True		Name of the repository that the branch targets.
TargetAuthorRaw	String	True		Raw value of the target commit's author.
TargetAuthorUUID	String	True		The target commit's author's account uuid.
TargetAuthorName	String	True		The target commit's author's account display name.