PullRequestReviewers
Retrieves a list of reviewers for the specific pull request, sliced across all repositories.
Table Specific Information
Select
The provider 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.
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. |