ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a collection of git branch.

Table Specific Information


The 本製品 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 本製品.

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


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'


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


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.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IncludeLinks Boolean

Specifies if referenceLinks should be included in the result.

IncludeStatuses Boolean

Includes up to the first 1000 commit statuses for each ref.

MyBranches Boolean

Includes only branches that the user owns, the branches the user favorites, and the default branch.

LatestStatusesOnly Boolean

rue to include only the tip commit status for each ref.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479