Retrieves a list of reviewers for the specific pull request, 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:

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

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

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 [KEY]	String	True		Id of the repository.
PullRequestId	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.