Pushes
Retrieves pushes associated with a repository, sliced across all repositories.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
The rest of the filter is executed client-side in the provider.
NOTE: RepositoryId is required in order to query Pushes.
- PushId supports the '=' operator.
- ProjectId supports the '=' operator.
- RepositoryId supports the '=' operator.
- PushedById supports the '=' operator.
- Date supports the '>=,<' operators.
- BranchName supports the '=' operator.
SELECT * FROM Pushes WHERE RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' SELECT * FROM Pushes WHERE RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' AND PushId = 16 AND Date >= '2000-01-01'
Insert
The following are examples of inserting into a Pushes table. For example:
INSERT INTO RefUpdates#TEMP (NewObjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'abcd') INSERT INTO Commits#TEMP (Comment, AuthorName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'xyz') INSERT INTO Pushes (ProjectId, RepositoryId, Commits, RefUpdates) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', '84609754-3aa8-4b91-8a56-8ccb48f6d017', Commits#TEMP, RefUpdates#TEMP)
Columns
Name | Type | ReadOnly | References | Description |
PushId [KEY] | Integer | True |
Id of the push. | |
ProjectId | String | True |
Id of the project. | |
Date | Datetime | True |
The date of the push. | |
PushedByDisplayName | String | False |
The display name of the user. | |
PushedById | String | False |
The Id of the user. | |
PushedByUrl | String | False |
The URL of the user. | |
RepositoryDefaultBranch | String | False |
The default of the repository. | |
RepositoryId | String | True |
Repositories.Id |
The Id of the repository. |
RepositoryName | String | False |
Name of the repository. | |
RepositoryProjectId | String | False |
The Project Id. | |
RepositoryProjectName | String | False |
The Project name. | |
RepositoryProjectState | String | False |
The Project state. | |
RepositoryProjectUrl | String | False |
The Project URL. | |
RepositoryRemoteUrl | String | False |
The Remote URL of the repository. | |
RepositoryUrl | String | False |
The URL of the repository. | |
Url | String | False |
The URL of the push. |
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 |
BranchName | String |
Branch name. |
RefUpdates | String |
Branch name. |
Commits | String |
List of inputs for the specific task group. |