ADO.NET Provider for Azure DevOps

Build 24.0.9060

Commits

Retrieve git commits for a project.

Table Specific Information

Select

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

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • RepositoryId supports the '=' operator.
  • AuthorName supports the '=' operator.
  • CommitterName supports the '=' operator.
  • PushId supports the '=' operator.
  • ExcludeDeletes supports the '=' operator.
  • HistoryMode supports the '=' operator.
  • IncludePushData supports the '=' operator.
  • IncludeLinks supports the '=' operator.
  • ItemPath supports the '=' operator.
  • VersionType supports the '=' operator.
  • Version supports the '=' operator.
  • VersionOptions supports the '=' operator.
  • CompareVersionType supports the '=' operator.
  • CompareVersion supports the '=' operator.
  • CompareVersionOptions supports the '=' operator.
  • FromCommitId supports the '=' operator.
  • ToCommitId supports the '=' operator.
The rest of the filter is executed client-side in the provider.


NOTE: RepositoryId is required in order to query Commits.

For example:

	SELECT * FROM Commits WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051'
	SELECT * FROM Commits WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND Id = '01832416d11f521e2e8fa1dc3acd9aebd93c773f'
	SELECT * FROM Commits WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND IncludePushData = true

Columns

Name Type References Description
Id [KEY] String Id of the commit.
ProjectId String Id of the project.
RepositoryId String Id of the repository.
AuthorDate Datetime Date of the Git operation.
AuthorEmail String Email address of the user performing the Git operation.
AuthorName String Name of the user performing the Git operation.
ChangeCountsAdd String Counts of the types of changes (edits, deletes, etc.) included with the commit.
ChangeCountsEdit String Counts of the types of changes (edits, deletes, etc.) included with the commit.
ChangeCountsDelete String Counts of the types of changes (edits, deletes, etc.) included with the commit.
Comment String Comment or message of the commit.
CommentTruncated Boolean Indicates if the comment is truncated from the full Git commit comment message.
CommitterDate Datetime Date of the Git operation.
CommitterEmail String Email address of the user performing the Git operation.
CommitterName String Name of the user performing the Git operation.
Links String Aggregate of the reference links.
LinkedWorkItems String List of linked WorkItem Ids.
Parents String An enumeration of the parent commit IDs for this commit.
PushDate Datetime Date of the commit push.
PushedByDisplayName String This is the non-unique display name of the user.
PushedById String Id of the user.
PushedByUrl String The URL of the user resource.
PushId Integer The Id of the commit push.
RemoteUrl String Remote URL path to the commit.
Url String REST URL for this resource.

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. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.

Name Type Description
FromCommitId String A lower bound for filtering commits alphabetically.
ToCommitId String An upper bound for filtering commits alphabetically.
ExcludeDeletes Boolean Only applies when an itemPath is specified. This determines whether to exclude delete entries of the specified path.
HistoryMode String What Git history mode should be used. This only applies to the search criteria when Ids = null and an itemPath is specified.

The allowed values are firstParent, fullHistory, fullHistorySimplifyMerges, simplifiedHistory.

IncludePushData Boolean Whether to include the push information.
IncludeLinks Boolean Whether to include the links.
ItemPath String Path of item to search under.
VersionType String Version type (branch, tag, or commit). Determines how Id is interpreted.
Version String Version string identifier (name of tag/branch, SHA1 of commit).
VersionOptions String Version options - Specify additional modifiers to version (e.g Previous).
CompareVersionType String Version type (branch, tag, or commit). Determines how Id is interpreted.
CompareVersion String Version string identifier (name of tag/branch, SHA1 of commit).
CompareVersionOptions String Version options - Specify additional modifiers to version (e.g Previous).

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