CommitGitStatus
Retrieve git status for the specific commit.
Table Specific Information
Select
The provider 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.
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. |