PullRequestWorkItems
Retrieves a list of work items associated with a 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 PullRequestWorkItems.
For example:
SELECT * FROM PullRequestWorkItems WHERE RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' AND PullRequestId = 2
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Id of the work item. | |
| Url | String | URL of the work item. | |
| ProjectId | String | Id of the project. | |
| RepositoryId | String | Id of the repository. | |
| PullRequestId | Integer |
PullRequests.Id | Id of the pull request. |