FireDAC Components for Azure DevOps

Build 21.0.7930

Pushes

Retrieves pushes associated with the specified repository.

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
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'

Columns

Name Type References Description
PushId [KEY] Integer Id of the push.
ProjectId String Id of the project.
Date Datetime The date of the push.
PushedByDisplayName String The display name of the user.
PushedById String The Id of the user.
PushedByImageUrl String The image URL of the user.
PushedByUniqueName String The unique name of the user.
PushedByUrl String The URL of the user.
RepositoryDefaultBranch String The default of the repository.
RepositoryId String

Repositories.Id

The Id of the repository.
RepositoryName String Name of the repository.
RepositoryProjectId String The Project Id.
RepositoryProjectName String The Project name.
RepositoryProjectState String The Project state.
RepositoryProjectUrl String The Project URL.
RepositoryRemoteUrl String The Remote URL of the repository.
RepositoryUrl String The URL of the repository.
Url String 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.

Name Type Description
BranchName String Branch name.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930