GitBranches

Retrieves a collection of git branch.

Table Specific Information

Select

The driver 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 driver.

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	Projects.Id	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.
CreatorUniqueName	String	True		Unique name of the creator.
CreatorImageUrl	String	True		Image URL of the creator.
CreatorDescriptor	String	True		Descriptor of the creator.
LinksSelfHref	String	True		Self reference link.
LinksRepositoryHref	String	True		Repository reference link.
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

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.