FireDAC Components for Azure DevOps

Build 21.0.7930

Commits

Retrieve git commits for a project.

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
Note: RepositoryId is required in order to query Commits.

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

Projects.Id

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.
LinksChangesHref String Commit changes reference link.
LinksRepositoryHref String Repository reference link.
LinksSelfHref String Self reference link.
LinksWebHref String Web reference link.
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.
PushedByImageUrl String The image url of the user resource.
PushedByUniqueName String The unique name of the user resource.
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.

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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930