Retrieve git status for the specific commit.

Table Specific Information

Select

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

• CommitId supports the '=' operator.
• ProjectId supports the '=' operator.
• RepositoryId supports the '=' operator.

The rest of the filter is executed client-side in the connector.

NOTE: RepositoryId and CommitId are required in order to query CommitGitStatus.

For example:

	SELECT * FROM CommitGitStatus WHERE RepositoryId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND CommitId = '01832416d11f521e2e8fa1dc3acd9aebd93c773f'

Columns

Name	Type	References	Description
CommitId	String	Commits.Id	Id of the commit.
ProjectId	String		Id of the project.
RepositoryId	String		Id of the repository.
ContextGenre	String		Genre of the status. Typically name of the service/tool generating the status, can be empty.
ContextName	String		Name identifier of the status.
CreatedByDisplayName	String		The non-unique display name of the user who created the status.
CreatedById	String		The Id of the user who created the status.
CreationDate	Datetime		Creation date and time of the status.
Description	String		Status description. Typically describes current state of the status.
Id	Integer		Id of the status.
State	String		State of the status.
TargetUrl	String		URL with status details.
UpdatedDate	Datetime		Last updated date and time of the status.