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

Table Specific Information

Select

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

NOTE:The table automatically slices on the RepositoryId. Specifying this filter can improve performance.

• 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

When performing an Insert, the following fields are required: RepositoryId, Commits, RefUpdates

The following is an example of inserting into the Pushes table:

INSERT INTO Pushes (RepositoryId, Commits, RefUpdates) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', '{"comment":"newcomment","changes":[{"changeType": "add","item": {"path": "/readme.md"},"newContent": {"content": "My first file!","contentType": "rawtext"}}]}', '{"name":"refs/head/D-124","oldObjectId":"0000000000000000000000000000000000000000"}')

Update

UPDATEs are not supported for this table.

Delete

DELETEs are not supported for this table.

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 aggregate.
Commits	String	Commit aggregate.