Pushes
Retrieves pushes associated with the specified repository.
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 |
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. |