Retrieve git commits for a project, 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:

• 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 connector.

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	Repositories.Id	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).