Pushes

Retrieves pushes associated with a repository, sliced across all repositories.

Table Specific Information

Select

The adapter 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 adapter.

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.

For example:

	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.