Retrieves a list of reviewers for the specific pull request

Table Specific Information

Select

The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

• ProjectId supports the '=' operator.
• RepositoryId supports the '=' operator.
• PullRequestId supports the '=' operator.

The rest of the filter is executed client-side in the connector.

NOTE: RepositoryId and PullRequestId are required in order to query PullRequestReviewers.

For example:

	SELECT * FROM PullRequestReviewers WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' AND PullRequestId = 2
	SELECT * FROM PullRequestReviewers WHERE RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' AND PullRequestId = 2

Insert

The following is an example of inserting into a PullRequestReviewers table:

INSERT INTO PullRequestReviewers (ProjectId, RepositoryId, PullRequestId, Id, Vote) VALUES ('c831d3b4-a289-462f', 'b20311e2-b5e4-444f', 2, '0c51c6d1-49b7-661b', 5)

Update

The following is an example of updating a PullRequestReviewers table:

UPDATE PullRequestReviewers SET DisplayName = 'cdata1', hasDeclined = false WHERE ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2' AND RepositoryId = '6b9dab15-dfe0-4488-a2b1-c5fe2a34b2cb' AND PullRequestId = 1 AND Id = '6a10066b-ee05-40c0-a207-b9fcbac568be'

Delete

The following is an example of deleting data in a PullRequestReviewers table:

DELETE FROM PullRequestReviewers WHERE ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2' AND RepositoryId = '6b9dab15-dfe0-4488-a2b1-c5fe2a34b2cb' AND PullRequestId = 1 AND Id = '6a10066b-ee05-40c0-a207-b9fcbac568be'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Id of the reviewer
ProjectId	String	True		Id of the project.
RepositoryId	String	True		Id of the repository.
PullRequestId [KEY]	Integer	True	PullRequests.Id	Id of the pullrequest.
DisplayName	String	False		Display name of the reviewer.
ReviewerUrl	String	False		URL to retrieve information about the reviewer.
Url	String	False		This url is the full route to the source resource of the reviewer.
Vote	Integer	False		Vote on a pull request: 10 - approved, 5 - approved with suggestions, 0 - no vote, -5 - waiting for author, -10 - rejected.
isFlagged	Boolean	False		Whether a pull request is flagged.
hasDeclined	Boolean	False		Whether a pull request has been declined.